Mail Merge from Query in Access - does not list all queries

[K.S.Andersen]

When mail merging I use a query from an Access database.When I ask WORD to
list the queries it only list around half the numbers, but all tables. Is
there any way I can increase the listed number? - I have tried to make a new
query - but it does not show either.
Can anyone help me?
Kjeld Andersen

 

[Cindy M -WordMVP-]

Hi K.S.Andersen,

When mail merging I use a query from an Access database.When I ask WORD to
list the queries it only list around half the numbers, but all tables. Is
there any way I can increase the listed number? - I have tried to make a new
query - but it does not show either.

We need to know which VERSION of Word you're using? And was the database
created in this version of Access, or an earlier one?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 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

 

[K.S.Andersen]

Both programmes are version XP2002
K.S.Andersen

Hi K.S.Andersen,

We need to know which VERSION of Word you're using? And was the database
created in this version of Access, or an earlier one?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 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

 

[Tom Toews]

I am using Office 2003. Word will not list any queries that are parameter
queries. Check and see if the queries you are missing require the user to
enter data before the query is run.

Tom

 

[Cindy M -WordMVP-]

Hi Tom,

I am using Office 2003. Word will not list any queries that are parameter
queries.

Correct, using the default connection method. It will work using DDE,
though (that's the only way to use them, as it starts up the Access
interface). You'll find information on how to change the connection method
in the Word 2002 section of my website's mail merge FAQ.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 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

 

[Cindy M -WordMVP-]

Hi K.S.Andersen,

Both programmes are version XP2002

Have you seen Tom's response to you? Are these "problem"
queries parameter queries, or just plain select queries?

Go to my website and look in the Word 2002 section of the
mail merge FAQ. You'll find information there about how to
change the way Word links data in for mail merge. Try DDE
or ODBC (instead of OLE DB, which Word 2002 is using by
default).

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Sep 30 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