Mail Merge - multiple Access tables as data source

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Julia DB - 08 Apr 2008 16:12 GMT

Is there a way to use fields from more than one table in a Word mail merge? I
have a table that shows information from related tables (such as names from a
Contacts table), but when I merge into a Word document, it brings in the
related table's record id, rather than the displayed information. For
example, it brings in the ContactID, rather than the contact's Fullname.

Reply to this Message

Doug Robbins - Word MVP - 08 Apr 2008 19:44 GMT

Create a select query in Access that links the tables together by the
relevant fields and displays the required data. Then use that query as the
data source.

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

> Is there a way to use fields from more than one table in a Word mail
> merge? I
[quoted text clipped - 3 lines]
> related table's record id, rather than the displayed information. For
> example, it brings in the ContactID, rather than the contact's Fullname.

Reply to this Message