Mail Merge from Access Queries no longer work

Topic

New Reply

I use Access and Word 2010 in Windows 7. I have a number of mail-merge letters I use for a nonprofit organization. These have worked just fine for years, until a few months ago. Now, I can no longer merge from Access queries directly. The queries still work fine, and I can export them to an Excel spreadsheet and use the spreadsheet as my data source for the merge, but that adds several steps and must be reconstructed every month. Any ideas as to why Word can’t find data in Access queries anymore?

Reply | Quote

Replies

What version of Access were you previously using? Beginning with Word 2002 the mail merge process was revised completely and parameter queries no longer worked as they had previously. See All queries do not show up when mail merging for a more detailed description of the issues and the workarounds.

Reply | Quote

The revelation that I couldn’t use * as a wildcard in my query was the key. I changed 11/*/12 to “between 11/1/12 and 11/30/12” and my merge documents worked just fine. I still do not understand using OLE DB wildcards.

Reply | Quote