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.
How do I include multiple records into an email?
There are several ways to add multiple records to an email:
- Use an embedded object like a query or report for the message. Examples of this are included in the sample database IDs 11, 12, 13, and 14. Text messages are easier than HTML but both are possible.
- Attach a report with the information you want to display separate from the email message. This lets you use the power of Access reports to combine data from lots of sources. The challenge is generating the text and/or HTML output that works with emails.
- In the data source for the email blast, create a field with the text to insert and reference that field in the message. From your application, generate the text you want to display and put it in the field. You'll need to use VBA code to do this.