Mail Merge, don't see all Access queries

[Allan]

When doing a mail merge in Word 2002, I choose an Access
2002 database as the data source. Instead of showing all
queries and tables, it shows, in one window
entitled "Select Table," only half my queries plus all my
tables.
I need to choose, as a data source, a query that is
currently not being shown in Word's "Select Table"
window. Any suggestions?

 

[brw]

This happen to me and I finally figured out that all my
querys that I had CONDITIONS set for would not show up
when merging to Word.

Someone suggested doing a "Make-Table" query and base your
Document off of that table. It worked great for me.

brw

 

[Cindy M -WordMVP-]

Hi Allan,

When doing a mail merge in Word 2002, I choose an Access
2002 database as the data source. Instead of showing all
queries and tables, it shows, in one window
entitled "Select Table," only half my queries plus all my
tables.

As "brw" says, there are some types of queries that mail
merge cannot link to, directly. A "Make table" query is one
possibility, but does require you to perform an extra step.

Another approach that often works is to create a plain
Select query on top of the "special query" (union queries
and those with agglomertative functions such as SUM fall
into this category), as that will be picked up.

Sometimes, it also helps to go back to the old DDE
connection. More details on how you can to that 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