Solved: Script for Exporting and Sending email - Page 3 - Qlik Community

Report Inappropriate Content · ‎2011-07-11

Hi Everybody,

Please help me the script to export the Qlikview documents into Excell/PDF file and the script to send email in Qlikview environment.

Many thanks,

Tai.

Report Inappropriate Content · ‎2011-12-28

I haven't tried PPT. We try to make it all dynamic, meaning : exporting to XLS and let the powerpoint point to that XLS.

If you really want PPT, I'm afraid I can't help you 😞

Why don't you produce PDF ? In QV, you can import pictures and use them in the reports. By making use of the Z (euch, how is it called in QV?), you can send the pictures to the back and set charts/tables/... in front of them.

In that way, you create an attractive PDF, but please take in mind that the PDF grows a lot. It could be a PDF of 2MB, that's heavy...

Otherwise, try to have a look on how to 'import' dynamic data in PPT's from XLS and use the same script in a VBS-file to distribute them to your recepients.

Jochen

udaya_kumar · ‎2011-12-28

ok thanks for reply jochen,

but the client requirement is, to export qlikview objects to powerpoint on button click in qlikview.

And it should be dynamic in the powerpoint also and if we send that ppt to others, it should work fine as dynamic.

Report Inappropriate Content · ‎2011-12-28

The way I would do it : export in QV to an image and use that image in PPT. In the macro point to the PPT-file to send out.

udaya_kumar · ‎2011-12-28

sorry, i didnt get the logic you explained,

can you explain in detail?

udaya_kumar · ‎2011-12-28

hi jochen,

i understood the logic, but i want it to be dynamic in ppt,

but you are telling to export as image right,

i want it to be interactive in powerpoint

Report Inappropriate Content · ‎2011-12-28

I've found a topic on that :

Report Inappropriate Content · ‎2011-12-28

SH|t, url doesn't work

Try to search for 'Export Image to insert in PPT' here on the forum

udaya_kumar · ‎2011-12-28

Can you share that topic jochen?

Report Inappropriate Content · ‎2012-01-15

Thank you very much for sharing this with us. Great function!

If you ever come to Serbia, I own you a dinner.

Report Inappropriate Content · ‎2012-02-01

Hello all,

I had looked for this kind of operations (sending email with attachments authomatically from QlikView) for long time and I found a couple of videos on YouTube that present a specific tool to compute such operations:

http://www.youtube.com/watch?v=FfKiEeoxIC8&feature=related

http://www.youtube.com/watch?v=Nye6kqS9nQY&feature=related

BR