When I open a mail merge document, Word tells me something like “Opening this document will run the following SQL command: SELECT * FROM ‘Sheet3$’ …”. It doesn’t tell me the actual DataBase that it’ll be using but hey – can’t have everything!
Anyway, in my merge I only want records that have something in the “Name” field. So I go to the “Mail Merge Recipients” dialog and using the Filter drop down arrow, select (Nonblanks). I can then perform the merge.
BUT!!! If I save the main document with (Nonblanks) selected, when I subsequently open it, I see the new SQL statement as “SELECT * FROM ‘Sheet3$’ WHERE (‘Name’ IS NOT NULL And ‘Name’ ”)” as expected BUT!!! it then tells me that it cannot find the data source, and I have to go through the file dialogs to link it to the source once again, and in the process it looses the (Nonblanks) selection once again.
If I save it with the “simple” “SELECT * FROM ‘Sheet3$'” (i.e. no filters applied to the Recipients) then it remembers the data source, if I have a filter applied then it remembers the filter but forgets the source.
So, how can I get it to remember BOTH the filter AND the source?
Any ideas?
TIA
Paul Lautman