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'l 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 (Nonblans) 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 (using Word
2002 (10.6754.6626) SP3)

Any ideas?

TIA
Paul Lautman