Launch email From Text Object

[jmonroe918]

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

[iktrayanov]

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]

Ivan:

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

Thanks.

Jeff

[iktrayanov]

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.

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

[#5]

Hi, Below links may help you

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

[#6]

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]

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

[#8]

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]

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]

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