Access and mailmerge in Word

[Popnorth]

I am designing a ADB for the local cemetery I manage. I am having to use it while trying to perfect it as there were only paper records before.
I have tried to normalize it as much as possible, so have a table for the County in my owner's adddresses. I need to write to some of the Owners and ran a query to sort them out. However, using mailmerge in Word, I have found that the programme is going to print out the County ID, rather than the actual County as that is the field which is in the Table/Qry. I'm sure that there is a way to prevent this, but I can't see how at the moment.
Can anyone help?

[alansidman]

Do you have two tables? One with the addresses and that contains the County ID and one with the County ID and the County Name? If this is how your DB is set up, then in a query join these two tables on the County ID. In your grid add the County Name. Do not display the County ID. Using your mailmerge wizard in Word, link it to the Query you have just created. This should give you the County Description and not the County ID.

[Popnorth]

Do you have two tables? One with the addresses and that contains the County ID and one with the County ID and the County Name? If this is how your DB is set up, then in a query join these two tables on the County ID. In your grid add the County Name. Do not display the County ID. Using your mailmerge wizard in Word, link it to the Query you have just created. This should give you the County Description and not the County ID.

Thank you, I'll do that!