merge from lookup field

[Guest]

I am working in a table where a field is linked to a
lookup table - for example, a list of cities. I then want
to merge the data from the complete table into a letter.
In the letter, rather than showing me the name of the city
from the lookup list it shows me the ID number - how can I
change that?

Thanks

 

[Wayne Morgan]

Create a query that contains both of the tables. Link the tables on the ID
field or whatever the common field is. In the query select the fields you
want to see. For the City, use the City field from the lookup table, not the
ID field. In the mail merge, use the query as a data source, not the table.