Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I know there are several discussions around creating a macro that copies a table from Qlikview into Excel and then emails it to users but I was wondering is there a way to copy a table from Qlikview into the body of the email (similar to copy the full table to clipboard and then pasting it into an email). Essentially I need to do this for a simple table (only 3 or 4 columns and 20 rows at max) but it can not be an attachment or image.
Any help is appreciated.
Thanks,
Ralph
Hi Ralph,
One way is to use the mailto command as follows ...
Say you have a table of countries with their capital cities. First create a variable called TB01 (for example) ...
='Country,Capital%0A' & concat(Country & ',' & Capital,'%0A')
... then another variable called mailto ...
=Replace('mailto:fname.lname@company.com&subject=Here is the data you need&body=' & TB01,' ','%20')
Then just use an action (Open URL) on a button with the URL set as ...
=mailto
It's only plain text but avoids using macros.
flipside
Hi flipside, thanks for that. I managed to create a macro which does what I required although I am having issues doing this through Access Point. I'll give your solution a go and see if helps.
Thanks again,
Ralph
Hi Ralph
How did you manage to do it? Please share 😉