I have seen the same behavior with some queries not being visible to Word
merges. Use of NZ() in a query or using grouping in the FINAL query seems to
make the query invisible to Word, even though it works fine within Access.

BUT, I've got a bigger problem -- I have a secured database with most users
only allowed to see personnel records within their group. I have a single
user logon for each group and an initial query that restricts records to
those with the group matching currentuser(). This works well WITHIN Access,
but when I try to link (using ODBC) a Word merge to it, I can see the query
name, but I get a Word message telling me that there are no records.

"Judy Grimes" wrote:

Hi!

Maybe I can help. I had the same problem, converting a Mail Merge document
from Word 97 to Word 2003. I could not "see" the query in the list to
reconnect it to the Word document. It turns out the query was a parameter
query and when I removed the parameter, I could "see" it in Word.

So I had a Mail Merge document using a parameter query in my Access database
to select the data for the document. The parameter indicated the record to
be used for the basic data in the document. I can't relink the document with
it's data in Office 2003 without removing the parameter. So I have to
manually find the record to use each time, rather than have the query produce
it. Is there any way to make this work like it did before?

"Jeff" wrote:

Hi Sarah.

Very strange issue. I just have a couple of questions for you on this. In
access, can you create a "create table" query, and create a table, using the
query you're trying to do the mail merge from? If you do, then are you able
to see that created table?

I'm not sure why it might be doing that. It seems weird. But I'm just
curious if you tried it a different way, if you'd be able to see the
addresses you're looking for.

Jeff

"SarahB" wrote:

I am using Word 2003 and Access 2003

I have a database with many queries, some of which are different types. I
am trying to create a mail merge with a regular Select query.

When I say to use that database as a data source, all of my other select
queries and tables are in the list for me to choose from except that one.