Mail Merge in Word

[Guest]

I have a table that keeps addresses and one of the field is Nation_Code which
keeps the country codes. I have a validation table that converts nation codes
into country names. On the Access form it shows county names while the field
has nation code.

My problem is, I try to mail merge for letter but when I add nation_code
field it shows a number that represents country. What I want is to put a
country name instead of nation code. Is there a solution for this like we do
in access forms?

Thank you.

 

[Joseph Meehan]

I have a table that keeps addresses and one of the field is
Nation_Code which keeps the country codes. I have a validation table
that converts nation codes into country names. On the Access form it
shows county names while the field has nation code.

My problem is, I try to mail merge for letter but when I add
nation_code field it shows a number that represents country. What I
want is to put a country name instead of nation code. Is there a
solution for this like we do in access forms?

Thank you.

How about using a query as the record source and have it display the
nation name.

 

[Guest]

Hi

It's quite simple. You can run the merge from a query. Ensure that all the
details you want are shown in the query. Ensure also that table containing
the country codes is shown and the relationship in correct and just bring
that field into the query. If you want to include Nation_Code you can select
visible=No (uncheck) and don't export it to the merge.

HTH