Using Access Database w/ Linked Table Info for Mail Merge

[SarahMW]

I want to use a table that includes information from another table (in a
lookup column) for a mail merge. When I go to execute the mail merge,
instead of giving the data from the merged field as text, it imports the
numerical value of that field. How can I get the merged field to export the
text instead of its value?

 

[Jeff Boyce]

Sarah

If you take the data that's actually stored in a table column with a
"lookup" datatype, you get the ID number, even though you see the looked-up
value. This is a common problem with using the "lookup" datatype (see the
tablesdbdesign newsgroup for more info).

Rather than working in tables, you need to be working in forms for display.

To get the "looked-up" value, you'll need to create a query and join the
main table and the lookup table on that field, then use the lookup table to
provide the looked-up value.

Regards

Jeff Boyce
<Office/Access MVP>