having problem while implementing for loop in macro

[tripatirao]

• Hi All,

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

[tripatirao]

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

[Frank_Hartmann]

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

[tripatirao]

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

[Frank_Hartmann]

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

[tripatirao]

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

[Frank_Hartmann]

Fill in the correct gmail smtp settings:

mail Server = "smtp.gmail.com"

SMTPport = 465

[tripatirao]

Dear Frank,

Thanks for help.

Code is working properly.

Just changesd SMTPport =25

Regards

Tripati