Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
jmonroe918
Creator II
Creator II

Launch email From Text Object

I have a text object where I would like to launch MS Outlook with a particular email address and standard subject text. From there requestor will type the content of the email.

Thanks for the help.

Jeff

18 Replies
iktrayanov
Creator III
Creator III

Go to action tab on your text object and add External>>Launch in the application browse to your saved outlook template. Now if you click on the text object it will open your template.

Hope that helps.

jmonroe918
Creator II
Creator II
Author

Ivan:

Thanks for the response. What do you mean by "outlook template"?

Thanks.

Jeff

iktrayanov
Creator III
Creator III

Create a template for your message.

Create an email message template

Use email templates to send messages that include information that infrequently changes from message to message. Compose and save a message as a template, and then reuse it when you want it. New information can be added before the template is sent as an email message.

  1. On the Home tab, in the New group, click New E-mail.

Keyboard shortcut     To create an email message, press CTRL+SHIFT+M.

In the message body, enter the content that you want.

  1. In the message window, click the File tab.
  2. Click Save As.
  3. In the Save As dialog box, in the Save as type list, click Outlook Template.
  4. In the File name box, type a name for your template, and then click Save.
Not applicable

Hi, Below links may help you

http://community.qlik.com/thread/100056

Not applicable

Hi Ivan,

I am tring to get the email address of current user using VB script in QlikView.

But I am getting as NT\user. Please help me in getting the email address of current user.

My script

Set objEmail = CreateObject("CDO.Message")

Set WshNetwork = CreateObject("WScript.Network")

objEmail.From = WshNetwork.UserName & "@mydomain.com"

iktrayanov
Creator III
Creator III

This will get the email for the current user and put it in a variable.

Not applicable

Hi Ivan,

Thank you very much for your reply. But I still have the problem.

My NT ID or Username is Domain\ABCD

My Email address is xx.yy@tt.com

Based on your macro I am getting ABCD@tt.com. But I am in need of xx.yy@tt.com

Please help me on getting this.

Regards,

Arun.

ThornOfCrowns
Specialist II
Specialist II

Have a look at this: http://community.qlik.com/docs/DOC-6079

The start of the code describes how to pull the Account Name etc. from the Active Directory account.

iktrayanov
Creator III
Creator III

Try this one.

Sub GetAddress

Set objOL = CreateObject("Outlook.Application")     

   

set v2 = ActiveDocument.Variables("Variable2")

v2.SetContent objOL.Application.Session.CurrentUser.Address ,true

   

End Sub