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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RB - 16 Nov 2005 15:35 GMT

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.

Reply to this Message

Doug Robbins - Word MVP - 16 Nov 2005 19:08 GMT

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.

Signature

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

> 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.

Reply to this Message

TedMi - 19 Nov 2005 18:06 GMT

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.

Signature

Ted

Reply to this Message