topic Re: Click on text object should open Outlook window in QlikView

Click on text object should open Outlook window

Thu, 17 May 2012 13:17:31 GMT

I have a text object in which I have mentioned an email id. When I click on the id, outlook window should open with my id as from-id and id in the textbox as to-id.

Click on text object should open Outlook window

Thu, 17 May 2012 13:32:16 GMT

I would use a trigger to select the ID field. Document Properties -> Trigger -> Field event procedure. Select Field ID and button Add action To Selct. This action would make the Open URL, which is in the External type actions.

URL you would put in something like the following:

'mailto:' & direccionEmail

I hope I've been helpful.

A greeting.

Re: Click on text object should open Outlook window

IAMDV — Thu, 17 May 2012 13:32:45 GMT

Here you go...please find the attachment

You need to store your id field in the QV Variable and you can call the variable content in the VB Script.

Good luck!

Cheers - DV

www.QlikShare.com

Re: Click on text object should open Outlook window

IAMDV — Thu, 17 May 2012 22:30:17 GMT

wishes29 - Have you got this working? Please let me know if you need more help with VB Script.

Thanks,

www.QlikShare.com

Click on text object should open Outlook window

Anonymous — Fri, 18 May 2012 20:17:47 GMT

Hi Deepak,

I tried your macro to open Outlook with my e-mail address. ( if somebody wants to send me e-mail)

I got an error "ActiveX component can't create object: 'Outlook.Application' " row#7

Regards,

Click on text object should open Outlook window

Anonymous — Fri, 18 May 2012 20:24:35 GMT

Sorry Deepak,

I found out it

<URL>mailto:'&your_emailaddress_field

Thanks,

Re: Click on text object should open Outlook window

Sun, 20 May 2012 22:23:39 GMT

Hello vovan4ik.

Do you try my proposal? I don´t need macro.

I would use a trigger to select the ID field. Document Properties -> Trigger -> Field event procedure. Select Field ID and button Add action To Select. This action would make the Open URL, which is in the External type actions.

URL you would put in something like the following:

'mailto:' & your_emailaddress_field

I hope I've been helpful.

A greeting.