I have an access .accdb format file which contains a table and a query. One of the query values is determined by a function in the VBA project.

My goal is to use this database as the source for a Word mail merge process. However, when I attempt to attach define the source for the mail merge in Word, the only data available is the table data.

From what I've read and (with very limited understanding of Access to start with) it seems that Access queries can't used (or be connected) as the data source in a Word mail merge.

If true, can anyone suggest the best or (generally accepted) method for using the query data as a mail merge source. I can successfully export the query to and Excel file and use the Excel file as the data source, but that just seems cumbersome and I'm thinking there should be a better way.

Thanks.