topic Re: Re: Launch email From Text Object in QlikView

Launch email From Text Object

jmonroe918 — Sun, 19 Jan 2014 21:38:04 GMT

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

Re: Launch email From Text Object

iktrayanov — Sun, 19 Jan 2014 22:24:58 GMT

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.

Re: Launch email From Text Object

jmonroe918 — Sun, 19 Jan 2014 22:28:19 GMT

Ivan:

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

Thanks.

Jeff

Re: Launch email From Text Object

iktrayanov — Sun, 19 Jan 2014 22:31:58 GMT

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.

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.

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

Re: Launch email From Text Object

Mon, 20 Jan 2014 05:39:00 GMT

Hi, Below links may help you

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

Re: Launch email From Text Object

Tue, 18 Mar 2014 10:35:12 GMT

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"

Re: Re: Launch email From Text Object

iktrayanov — Tue, 18 Mar 2014 20:52:38 GMT

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

Re: Re: Launch email From Text Object

Wed, 19 Mar 2014 11:31:15 GMT

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.

Re: Launch email From Text Object

ThornOfCrowns — Wed, 19 Mar 2014 12:07:55 GMT

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.

Re: Re: Launch email From Text Object

iktrayanov — Wed, 19 Mar 2014 14:25:23 GMT

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

Re: Re: Launch email From Text Object

iktrayanov — Wed, 19 Mar 2014 14:38:30 GMT

After this you need to parse the result something like this

=subfield(Variable2, '=' ,5)&'@MyDomain.com'

Re: Re: Launch email From Text Object

Thu, 20 Mar 2014 08:15:30 GMT

Hi Ivan,

Awesome!! Thank you so much. It worked out well. In case of any query in QlikView I would contact you.

Wish you a great time ahead. Bye for now.

Regards,

Arun.

Re: Re: Launch email From Text Object

Fri, 28 Mar 2014 05:24:49 GMT

Hi Ivan,

I am having data extracted from SQL table and I am matching it with an inline table to get a field.

But the null data is not coming in the chart. Please help me on this.

Below is my inline table

Start:

ADD LOAD * Inline [_HW_Code, _SW, _SW Name, _BUSINESS, _Domain, _SW Domain Desc, _L1, _L2

BB, RR, Services, Support, <NULL>, <NULL>, Services, Services

<NULL>, <NULL>, Others, Others, Others, Others, Others, Others

] ;

Below is my Dimension expression in sparkline chart

=if(HW=_HW_Code,if(Match([_L1],'Segment','Services','Software','Engineering','Technology','Support')>0,[_L1],'Others')
,If(IsNull(_HW_Code),'Others'))

Note:

'Supress when value is null' is NOT ticked, nor is 'Supress zero-values' or 'Supress Missing'.

Re: Re: Launch email From Text Object

iktrayanov — Fri, 28 Mar 2014 14:17:06 GMT

When loading your data from SQL try using NullAsValue statement before the load(see QlikView help for NullAsValue and NullAsNull)

Re: Re: Launch email From Text Object

iktrayanov — Fri, 28 Mar 2014 14:36:23 GMT

Also before your inline load add this

SET NULLINTERPRET=<NULL>;

Regards,

Ivan

Re: Re: Launch email From Text Object

Fri, 28 Mar 2014 15:00:34 GMT

Hi Ivan,

Thank you very much. It worked.

Regards,

Arun.

Re: Re: Launch email From Text Object

iktrayanov — Fri, 28 Mar 2014 15:09:50 GMT

Arun,

You may want to start a new tread if you have a question unrelated to this one.

Regards,

Ivan

Re: Launch email From Text Object

Josh_Good — Fri, 28 Mar 2014 16:27:18 GMT

You can use the Open URL action and set the URL using the mailto keyword.

For example you could write the following the URL to send an email to Obama@whiltehouse.gov with the subject Congrats Obama.

='mailto:obama@whitehouse.gov?subject=Congrats%20Obama'

Re: Re: Launch email From Text Object

Fri, 28 Mar 2014 17:21:00 GMT

Hi Ivan,

Thank you for your suggestion. I tried several times, but I have been denied logging a new thread. But I am able to reply to the existing threads, Strange!

Regards,

Arun.