topic Re. :Contact us Email Button in QlikView

Contact us Email Button

Thu, 21 Apr 2011 12:19:22 GMT

Does anyone know how to add a button that will open up a new Email Message with the TO: field pre populated?

Thanks

Dan

Re. :Contact us Email Button

Thu, 21 Apr 2011 13:52:32 GMT

Hi Daniel,

You just have to create a text control.

In its properties, on "Action" tab, choose : "Open URL"

In the command line, write :

mailto:info@kogent360.com

(Put your mail address instead of)

Hope this helps you.

Kindly,

Re. :Contact us Email Button

Thu, 21 Apr 2011 15:14:12 GMT

Thanks Greg, works perfectly

Re. :Contact us Email Button

Anonymous — Thu, 21 Apr 2011 15:40:12 GMT

Great Tip! That almost seemed too easy to work, but it works great. Thanks!!!

Re. :Contact us Email Button

Thu, 21 Apr 2011 15:42:09 GMT

I didn't know you could put mailto: in the address bar... that's pretty awesome thanks.

Re. :Contact us Email Button

Thu, 21 Apr 2011 15:43:57 GMT

This was very helpful to me too, Thanks for posting

Re. :Contact us Email Button

Thu, 21 Apr 2011 15:53:09 GMT

Your welcome ;-)))

Re. :Contact us Email Button

Mon, 25 Apr 2011 16:10:24 GMT

I could have sworn this was working the other day and now I'm getting a "failed to launch" message... any idea why?

Re. :Contact us Email Button

montubhardwaj — Mon, 25 Apr 2011 19:41:13 GMT

Wow.... Pretty nice... thanks for sharing.....I have few more question on this:

1. Can we also add Subject automatically?

2. How can we add members into Cc?

3. Will this work only for outlook? can the same method be used to send mail through Lotus notes or through like Gmail etc ?

Many thanks in advance!

Re. :Contact us Email Button

montubhardwaj — Tue, 26 Apr 2011 10:13:05 GMT

Hello Greg,

Can you please put some light on the above doubts? thanks for your time.

Re. :Contact us Email Button

Tue, 26 Apr 2011 15:34:36 GMT

So it seems like the Open URL triggers just randomly work or don't work for me... any clue why? Sometimes they do and then an hour later it will just say like "Launch failed" or something like that. It did the same thing whether it was www.google.com or mailto:someaddress@somewhere.com

Weird.... there are a few other QV related things that just don't seem to work but then when I restart they work fine as well but off the top of my head I can't think of them.

Re. :Contact us Email Button

Anonymous — Tue, 26 Apr 2011 15:46:59 GMT

Subject would be like this:

mailto:info@kogent360.com?subject=Your Subject

Contact us Email Button

guytzumer — Wed, 27 Apr 2011 08:39:13 GMT

Code for combine mail, cc, body - and two lines in the body -

mailto:someone@somewhere.com? CC=somebody@somewhereelse.com & subject=Email Example & body=AAAAAA %0A BBBBBB

enjoy

guy tzumer

Contact us Email Button

Wed, 27 Apr 2011 09:34:02 GMT

Thanks Tzumer.

It's really helpful

Re: Contact us Email Button

Fri, 06 Sep 2013 16:53:21 GMT

Hi Guy,

I'm able to get the mailto: part to work, the CC and more importantly the subject part is not working.

I use the following code:

mailto:Accountability@abc.com CC=amodi@abc.com & subject=Case Escalation from Dashboard.

While the To part works, CC shows up in to the To line with the text "CC=", the subject does not populate at all.

Would you know what is wrong with my code.

Thanks,

Amitesh

Re: Contact us Email Button

Fri, 06 Sep 2013 16:59:15 GMT

Hi Amitesh,

It seems that you missed the sign ? , before CC=

Thanks,

ASINGH

Re: Contact us Email Button

Fri, 06 Sep 2013 17:22:14 GMT

Thanks Angad,

I had tried earlier with the ? it is just that I had a space after it, which I removed this time around and it worked.

What confused me were the special envelope like symbols, so for anyone getting confused like me use the URL similar to the following:

mailto:anyone@abcd.com ?CC=xyz@abcd.com & subject=Case Escalation from GPODB

Thanks,

Amitesh

Edit: Oops, I see that my own reply appears with the 'envelope' symbol, just know not to use spaces between mailto:emailid?CC=emailid

Re: Contact us Email Button

Anonymous — Fri, 06 Sep 2013 18:08:40 GMT

I know this is already answered, but you can also control Outlook through the object model. I have a button on one of my documents that attaches files to the email messages. Here is some vbscript code that you can assign to a button in QlikView. It will open an Outlook message, and set properties of the object like add attachments, set the subject, body, and to fields:

Sub Send()

Set objOL = CreateObject("Outlook.Application")

Set objMsg = objOL.CreateItem(olMailItem)

objMsg.Attachments.Add "c:\samplefile1.txt"

objMsg.Attachments.Add "c:\samplefile2.txt"

objMsg.subject = "Subject line"

objMsg.body = "Your files are ready to send."

objMsg.to = "test@domain.com"

objMsg.Display

End sub

Geoff

Re: Contact us Email Button

Fri, 06 Sep 2013 18:36:08 GMT

Hi Geoff,

In the properties of the button that you mentioned, what do you choose under Actions.

I chose Run Macro . If it is Run Macro, then I tried it by pasting your script. I kept the Scripting Engine as VBScript.

Allowed System Access for Security. But when I click Test, it goes to the second line of your code and says

ActiveX component can't create object: 'Outlook.Application'

I agree that there is NO Outlook on my server so I save it and test it on the browser on my machine, but the button does not work. I guess it is not clear to me what you are doing exactly.

Thanks,

Amitesh

Re: Contact us Email Button

Bill_Britt — Fri, 06 Sep 2013 18:41:10 GMT

This would only work with the Plugin. In AJAX most macros are ran server side.

Bill