Total Access Emailer lets you easily send personalized emails to everyone in your list from a table or query. It also lets you customize every email by using the values from fields in your data source for the email subject and message.
Rather than individual fields, what if you want to insert multiple records in your message?
Yes, you can! Here are a few ways to accomplish this:
- 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.