Mail merge using Access query problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

NB - 12 Jun 2006 20:11 GMT

I have set up a mail merge document, and have connected it to an Access
query. I have no problem finding the query through the Mail Merge tool, and
no problem placing the Merge fields onto the document.

When I look at the recipient list in the Mail merge tool it shows no records
- looking like my Access query is empty. However it is not empty, and in
Access the query is working fine.

What am I doing wrong, and how do I fix it?
Thanks!
NB

Reply to this Message

Doug Robbins - Word MVP - 13 Jun 2006 04:45 GMT

In Word, from the Tools menu, select Options and then go to the General tab
and check the box against "Confirm conversions at open". Then, when you
attach the mailmerge data source to the main document, select DDE as the
method by which the connection should be made.

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

>I have set up a mail merge document, and have connected it to an Access
> query. I have no problem finding the query through the Mail Merge tool,
[quoted text clipped - 9 lines]
> Thanks!
> NB

Reply to this Message

NB - 13 Jun 2006 16:52 GMT

It worked - You are a genius!!

Thanks!
NB

> In Word, from the Tools menu, select Options and then go to the General tab
> and check the box against "Confirm conversions at open". Then, when you
[quoted text clipped - 13 lines]
> > Thanks!
> > NB

Reply to this Message

Rate this thread: