[Amanda H]

I have created a mail merge to an Access database query which included a
field from a look up table. The look up table is set to display the long
name e.g. description of course, in the 2nd column in the look up table
rather than the 1st column the 'course code'. This works in Access in the
personal details table and in the 'select' query to select the recipients.
However, in the mail merge document the merge field dispays the course code
(the first column of the look up table) rather than the course name (the
second column of the look up table).

How can I change or formatt the merge field to display the course name
rather than the course code?

Any help would be gratfuly received.