Cannot use queries from MS-Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mogens - 21 Nov 2005 20:34 GMT

When I try to "Select a different list" in the Mail merge wizard, and
then locate the MS-Access database I would like to use, I only see the
TABLES in this database, not the QUERIES. Could someone please tell how
to be able to use Queries as basis for a mail merge in MS-Word?
(I'm using Access 2002 and Word 2002)

Mogens

Reply to this Message

Doug Robbins - Word MVP - 21 Nov 2005 21:40 GMT

From the Tools menu in Word, select Options and then go to the General tab
and check the box for "Confirm conversions at open" Then, when you attach
the data source to the mail merge main document, you will be presented with
a dialog box that asks for the way in which the connection should be made.
Use the DDE option.

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

> When I try to "Select a different list" in the Mail merge wizard, and then
> locate the MS-Access database I would like to use, I only see the TABLES
[quoted text clipped - 3 lines]
>
> Mogens

Reply to this Message

mogens - 22 Nov 2005 03:11 GMT

> From the Tools menu in Word, select Options and then go to the General tab
> and check the box for "Confirm conversions at open" Then, when you attach
> the data source to the mail merge main document, you will be presented with
> a dialog box that asks for the way in which the connection should be made.
> Use the DDE option.

Thanks a million! This really was one of those that I would never have
found out myself.

Reply to this Message