View Single Post
  #7   Report Post  
Judy Grimes
 
Posts: n/a
Default

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.