Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My requirement is when I click a button lets say 'Generate PPT' qlikview engine will select each values in country field one by one and it will send all charts to ppt.
i want to do this by using for loop in macro.
I am able to generate ppt for all country but not able implementing forloop to select country name automatically.
I have added for loop in macro but when running macro. One ppt is opening and qlikview application got hanged.
Please help me regarding this. I have attached macro code which i am using.
Regards
Tripati
Dear Frank,
Now I have last requirement ,I have to send these PPT to email.
Can you please assist me how to do this.
Regards
Tripati
to how many receivers do you have to send these reports?
One countryreport to one receiver or all countryreports to all receivers? ....
Please give more detail on your requirement
Dear Frank,
Right now I have 12 country report with me. If I click a button all 12 reports will go to only one email id.
Kindly let me know any more information you want from my side.
Regards
Tripati
I have attached the piece of code which you will have to paste/insert above the "End sub" statement of your export macro. You will just have to adapt your email, pass, smtpport, mailserver, mailsubject, mailbody and the paths of the generated reports.
hope this helps
Dear Frank,
Thanks for your reply.
I have added the code given by you. But no luck.
After exporting ppt to desired folder it is asking for reciever mail id in qlikview front application.Once I enter the reciever email, it is coming back to vb script editor.
Note:I am doing entire things in local system not in server and the reciever emal id and sender email id domain is gmail.
For your reference I have attached the script.Please check and do the needful.
Regards
Tripati
Fill in the correct gmail smtp settings:
mail Server = "smtp.gmail.com"
SMTPport = 465
Dear Frank,
Thanks for help.
Code is working properly.
Just changesd SMTPport =25
Regards
Tripati