Query from access does not show up in list for mail merge

[RB]

Trying to perform mail merge in word. When I select my database source
(access), the query I want to use is not listed as an option to choose from.

 

[Doug Robbins - Word MVP]

From the Tools menu in Word, select Options and then go to the General tab
and check the box against the "Confirm conversions at open" item. Then when
you attach the datasource, you will be presented with a dialog box in which
you can select the way in which the connection to the data source is made.
Selecting the DDE option may overcome your problem.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[TedMi]

The query will not show up if it is hidden. You must unhide it in Access
before you set it up as the datasource in Word. Once set up, you can then
hide it again and it will work.