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.
Does Total Access Emailer support parameter queries as the data source of an email blast?
Total Access Emailer does not allow a parameter query for your data source since it requires user input when it is run. This would be bad if you tried to run multiple email blasts and it paused for each one, or if you used the VBA interface to programmatically run the email blast in unattended mode.
Fortunately, there is a way around this limitation while still supporting parameters to customize the query's selections. Rather than using a query with parameters, do the following:
- Create a table to store the parameters for your query using a separate field for each parameter.
- Create a copy of your query and link it to the table storing your parameters so that it generates the results you want.
- Use this query as the data source in your Total Access Emailer email settings.
- Manually or programmatically update the values in the parameters table before running your email blast.