I have a number of mail merge documents that I have used in my business for many years. They are Word files that link to an Access query to create mailing lists, order forms, etc. with clients’ names and addresses.
I just tried to use one, and it yielded a small subset (10) of the correct number of records (36) that are given by the query when run in Access. I tried another merge doc, and it yielded no results, even though it should have 300 records.
I have not changed much since the last time I ran the query successfully in May. I moved the Access file to a different directory, which shouldn’t have affected anything. But I copied it back and ran it from the old location, with the same results.
I’ve installed a few recommended updates from Microsoft since then, but I can’t think of any reason why these merges shouldn’t work anymore.
Any suggestions? Please don’t suggest getting Office 2007 or 2010. I’m perfectly happy with 2003, and everything was working fine with it until today.
(I found a workaround: I copied the query results from Access to an Excel sheet, then linked the merge doc to that. But it’s an extra step that I shouldn’t have to take, so I’d like to figure out the problem between Word and Access.)