Total Access Emailer is the world's most popular Microsoft Access email add-in product and VBA code library. Simplify the way you communicate with your contacts, and easily share the data and reports from your Microsoft Access databases with personalized emails for each recipient.
Using Total Access Emailer, can I attach reports with data filtered for each recipient?
Yes. This is one of the most powerful features of Total Access Emailer. You can easily attach reports as PDF files and filter them for each recipient without any programming. It's similar to the way you set master and child link fields for subforms and subreports.
For instance, your data source may have a CustomerID in addition to the email address. You can attach a report that's filtered by CustomerID so each email has your report filtered by its ID. Each email can have multiple reports attached. Attachments can even be compressed into a zip file and password protected if you like.
For more information, visit: Emailing Microsoft Access Reports and Data Filtered for Each Recipient