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.
Can I embed Access objects in my Total Access Emailer emails?
Yes. Total Access Emailer includes the ability to embed tables, queries/views, and reports directly in your email messages and attachments. Easily filter the data so each recipient receives their own information based on fields in your data source.
The simplest result is using data from a table or query to send each person their set of records like a list of invoices, tasks, etc.
The most powerful feature is using the Access report generator to create sophisticated HTML messages. Any Access report you create can be exported to HTML, which you can now filter and email to each recipient. Leverage the power of Access reports to create emails that are nicely formatted with complex data, lots of detail rows, groupings, summaries, and even subreports.
For more information, refer to the "Embedded Objects" topic in the help file or visit Emailing Microsoft Access Reports and Data Filtered for Each Recipient.