PDF email distribution with macro

[#1]

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

[Clever_Anjos]

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

next

[Clever_Anjos]

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