Hi Victor,

Question remains "how" to change the field
properties in the query to populate the word field with the data and not the
id information.

You need to redesign the query in Access. Look at the table that provides both
the ID and the related text information. DRAG the field with the text
information down into the query grid. Save and close the query.

In Word, open the mail merge document. Check the list of fields to see if the
field you just dragged into the query appears. If it does not, then you need to
repeat the steps to link the document to the data source. Now you can insert
this field into the main merge document (and delete the ID field).

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)