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.
When using Total Access Emailer, how do I limit my email recipients to a date range? What is the best way to do this?
Total Access Emailer does not filter the data you provide as the data source (table or query). You should provide a query that contains the filter.
Queries can be filtered on many fields, not just dates, so it's impractical for Total Access Emailer to replicate what Access queries already do. You can specify a date range directly in your query or have it reference fields in another table.
The latter can be done by creating a table with fields for the date(s) and just one record. Your query would use those fields in its criteria to filter its data. When you update the data, your query automatically uses the new date value(s) without the need to modify the query.