Word 2003; Mail merge from Access query; blank data set

[Chris M.]

Open a Word mail merge document formatted as labels.
Browse to data source that is a query (with known data).
The query datasheet view within the mail merge wizard
appears to contain the correct number of rows but no data.

Using the same steps, but specifying a table instead of a
query works OK (but of course defeats the value of being
able to use queries).

Has anyone run into this and overcome it?

Thanks!
Chris M.

 

[Cindy Meister -WordMVP-]

Hi Chris,

Is the query using any wildcards, such as * or ?

If you activate "Confirm conversions on open" in
Tools/Options/General, then select DDE or ODBC after
choosing the *.mdb file, does the problem go away?

Open a Word mail merge document formatted as labels.
Browse to data source that is a query (with known data).
The query datasheet view within the mail merge wizard
appears to contain the correct number of rows but no data.

Using the same steps, but specifying a table instead of a
query works OK (but of course defeats the value of being
able to use queries).

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan
24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail