Mail Merge - multiple Access tables as data source

[Julia DB]

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.

 

[Doug Robbins - Word MVP]

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.

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