Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
I´ve found the code you need: Loop through all filter values then print to PDF