how do i set up mail merge to acces queries in office 2000

[Tiani]

I am trying to set up a mail merge in word 2000 to an acces database, however
word is not showing all queries.

do you know how to show all queries so that i can set up the mail merge

Thanks
Tiani

 

[Peter Jamieson]

Normally you see all the queries, especially when you connect from Word
using the default mechanism (DDE), which opens a copy of Access.

However, it is possible that the queries have been inserted in a way that
makes them invisible to Word, or that someone has marked them as Hidden in
the Properties for the query in Access, or that the database uses workgroup
security and the queries are not visible to the default user ("Admin"). Or
maybe there is something else you can see that is special about the hidden
queries? If you are allowed to add material to this database, you might be
able to work around this problem by adding new queries that simply do

SELECT * FROM queryname

for each query you cannot see.

Peter Jamieson

 

[tweetyangel]

I am having the same problem. Any query that contains a prompt as a
condition does not show up anymore. The only way to get them to show up is
to remove the prompt, this causes the users of mail merge to have to edit the
recipient list and limit the data in Word instead of in Access. This is
horrible!

 

[tweetyangel]

I just found another post that tells you how to work around this... awesome!!!
"From the Tools menu, select Options and then go to the General tab and check
the "Confirm conversions at open" item. Then try the other methods of
connecting to the data source that will become available to you."