topic Re: Email a plain text table with a macro? in QlikView

Email a plain text table with a macro?

Thu, 24 Jan 2013 13:50:15 GMT

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

Re: Email a plain text table with a macro?

flipside — Thu, 24 Jan 2013 16:07:16 GMT

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

Re: Email a plain text table with a macro?

Thu, 24 Jan 2013 16:56:25 GMT

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

Re: Email a plain text table with a macro?

Mon, 04 Feb 2013 15:15:11 GMT

Hi Ralph

How did you manage to do it? Please share 😉