Mail Merge Field Value

[debbiep]

I am working on a mail merge. My fields in question are lookup
fields,
When I do the mail merge, the number shows instead of the actual
name.
My lookup is coming from a query. Can anyone tell me how to make the
merge return the actual name instead of the number?
Thank you in advance!

 

[Albert D. Kallal]

I am working on a mail merge. My fields in question are lookup
fields,
When I do the mail merge, the number shows instead of the actual
name.
My lookup is coming from a query. Can anyone tell me how to make the
merge return the actual name instead of the number?
Thank you in advance!

Simply fire up the query builder, and dropping your main table.

Now for each additional look up field that from another table, simply drop
in the other table. You then simply draw a connection lines (join) from the
main table to the child table, and then drag/drop in the description text or
data feel that you need from this other table.

you can continue the above process for as many additional tables as you
need, so you have six different look up to, from six different tables,
simply drop in those six additional tables and the query builder, dry your
join lines, and you're done.

The only thing you have to do if you have more than one look up table is
need to double click on the join line, and choose a left join, otherwise the
above will not work (when you have more then one lookup table).

 

[Douglas J. Steele]

You've discovered just one of the many reasons why most of us abhor lookup
fields (see http://www.mvps.org/access/lookupfields.htm at "The Access Web"
for some more of the reasons).

You'll have to create a query that joins your table to the various tables to
which the lookup fields are linked, and merge the query, not the table.