Mail merge with a date range

J

Jeffh

I currently use Albert Kallal's Super Easy Mail Merge program and it works
perfectly. I would like to knwo whether the code can be modified to include
the ability to merge records using a date range. Currently, the utility
offers to merge either all records or just one. I have a query set up to give
me the desired results

Select * from tablename where [Date] between [Start Date] and [End Date]

The Date field in the table is set up using a default value of Date()

I have tried to modify the code behind the Merge All records button without
success. Does anyone have an example of how to do this? Thanks in advance
 
Top