topic Create email by linking on cell in table? in QlikView

Create email by linking on cell in table?

Thu, 10 Sep 2009 19:11:10 GMT

Hi all, I'm quite new to this.... I have an Excel file of names and contacts, and I want to Load this to use in a table giving users the ability to click on a cell and have their email program open a new window to create an email. Thanks.

Create email by linking on cell in table?

Thu, 10 Sep 2009 19:36:42 GMT

Hi Karen,

You could use 'INFO LOAD' to link a mailto-URL to your values. Check the attached QVW for an example.

The 'INFO LOAD' statement in the script links each value in the 'contact' field to a mailto-URL; if you've made a selection in the QVW which links to 1 single 'contact' value, the (i) icon will appear in the 'contact' listbox. Click this icon, and your default mail program will open with a new e-mail adressed to this person. Google for 'mailto url' to find an explanation of what you can put into a mailto-URL.

With regards,

Martijn ter Schegget

PS: same trick also works with website URLs and filenames - Rob Wunderlich uses this last version to link to the various QlikView cookbook examples from the 'index' QlikView application.

Create email by linking on cell in table?

Thu, 10 Sep 2009 21:40:36 GMT

Thank you Martijn, I've tried it and it works. I just wonder how to make this more obvious to the user..?? Any ideas?

Create email by linking on cell in table?

Fri, 11 Sep 2009 00:09:25 GMT

Martijn, I've worked out a solution using conditions. Thanks for your help