topic Re: PDF email distribution with macro in QlikView

PDF email distribution with macro

Wed, 25 Nov 2020 16:16:04 GMT

Hello all,

Please pardon me with the same question being asked many times. But I could not find the answer anywhere. I was able to send pdf via email using macro Macro to export AND mail report as PDF shared in the thread. Thanks to JochenAndries‌

But is there any way is it possible to send pdf via email to 100 users with only data each user should suppose to see?

Any help is greatly appreciated.

Best

Parth

Re: PDF email distribution with macro

Clever_Anjos — Thu, 17 Nov 2016 21:09:56 GMT

Yes, it´s possible.

First of all you should think with field selections should be applyed to each user.

Them load a table with fields

email_address for each user and search pattern to field.

Then into your macro, you should do (pseudo-code)

For each value in your table_email

Apply the selection

send email

Re: PDF email distribution with macro

Clever_Anjos — Thu, 17 Nov 2016 21:10:40 GMT

I´ve found the code you need: Loop through all filter values then print to PDF