Word 2007 mail merge not filtering correctly
Posted on 2011-09-29
I have several mail merge documents (Word 2007) that use an Access 2007 query as the datasource. The Access query is filtered with criteria entered for some columns ... however, when I open the Word mail merge document, it retrieves ALL records and seems to ignore the criteria filters I have in the query ??!! I am aware I can filter within the Word document itself, but I prefer not to do that to keep the merges user-friendly for the users.
Does anyone know why the filtering criteria works at the query level, but not in the mail merge documents?