recipients list is empty

[Susan]

When I do a mail merge in word and try to use a query or
table from Access the list is empty. But if I open it in
Access the records are there. I have printed labels with
these tables and queries before. I tried making a new
data base and starting a new mail merge doc. Nothing
works. Help!!!!

 

[Cindy M -WordMVP-]

Hi Susan,

When I do a mail merge in word and try to use a query or
table from Access the list is empty. But if I open it in
Access the records are there. I have printed labels with
these tables and queries before. I tried making a new
data base and starting a new mail merge doc.

Is this Word 2002 or 2003? And the version of Access is the
same?

From the context of your message may we assume that when
this was working, it was in an earlier version of Word?

Are you able to set up a link directly to one of the tables
used in the query? And do these records show up in the
Recipients list?

Open the query in Access and go into the SQL view. Please
copy what you find there (Ctrl+C) and paste it into your
reply so that we can see what kind of query this is.

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

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