Create a powerpoint document from QV and send it by email

[#1]

Hello everyone,

Ia m going to create a powerpoint document and paste in it some objects from Qlikview. With the OCX component, the powerpoint should be updated each time the QV application is reloaded.

What I would like to do is that once the powerpoint is also refreshed, to send it automatically by email.

Is this possible to do it with a macro perhaps ?

Or perhaps I should create the document in a marco and then send it ?

Thank you for your help

Laura

[datanibbler]

Hi Laura,

I did something with VBA at a time, but that's a while ago. I'm not good at it, plus in the new Office, MS has taken out the recorder, making it harder to learn or refresh your knowledge ...

I think, however, that it would probably be easier to create a macro that does both

- refreshes the ppt and

- sends it

than to have the macro triggered by your refreshing the ppt.

<=> I don't know how that QlikkView thing will react to that, try out if the Qlikview_elements in that ppt are also refreshed when you do that.

Best regards,

DataNibbler

[#3]

Thank you for your reply DataNibbler.

when you say create a macro, are you talking about create a macro in my powerpoint document or in the QV application ?

Is it possible to send a powerpoint document by email from Qlikview ?

Thanks again

[ashfaq_haseeb]

Hi,

go through the below posts.

http://community.qlik.com/message/482399#482399

http://community.qlik.com/message/418334#418334

http://community.qlik.com/message/198013#198013

http://community.qlik.com/thread/25067

http://community.qlik.com/message/160894#160894

http://community.qlik.com/message/165717#165717

Regards

ASHFAQ

[datanibbler]

Hi Laura,

I mean a macro in PPT (in VBA, which is common to all Office applications). The order of execution would thus be

1) trigger macro

2) macro refreshes ppt_file -> QlikView_elements in ppt_file are refreshed, too

3) macro sends refreshed ppt_file via email

Best regards,

DataNibbler

I think QlikView has some Sendmail functionality, but I think by default QlikView cannot create ppt files.