Access View is not available in Word mail merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Defaul home page - 24 Dec 2004 21:59 GMT

I created an Access table with a couple of views. The merge worked fine. I
later added a new view in Access. In Word I then changed the data source but
the new view does not appear.

Reply to this Message

Doug Robbins - Word MVP - 24 Dec 2004 23:31 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 data source to the mailmerge main document, you will be given
a number of different options for the method in which the connection should
be made. The DDE option should give you access to your query.

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> I created an Access table with a couple of views. The merge worked fine. I
> later added a new view in Access. In Word I then changed the data source but
> the new view does not appear.

Reply to this Message