Mailmerge data displays improperly

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mikey - 18 Mar 2007 15:31 GMT

I have a simple Access DB that has similar fields, each of which uses a
lookup table to select the specific data. Each of the related tables has
only two fields: the Key (autonumber) and the list of items. When I
mailmerge the master table into Word to print certificates, the key number
from each field prints instead of the associated data item. How do I get the
specific data items to print rather than its associated ID (Key) number?

Reply to this Message

Doug Robbins - Word MVP - 19 Mar 2007 22:21 GMT

You probably need to create a query in Access to display the data that you
want included in the merge and 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

>I have a simple Access DB that has similar fields, each of which uses a
> lookup table to select the specific data. Each of the related tables has
[quoted text clipped - 3 lines]
> the
> specific data items to print rather than its associated ID (Key) number?

Reply to this Message