Doug,
Thank you for your reply.
I have set up the merge to a query - in order to select the recipients - the
query shows the course name (i.e. the second column of the look up table)
rather than the course code (the first column of the look up table).
The frustrating thing is, I am sure I have done a mailmerge like this in the
past and it worked fine. I suspect it is something to do with the field
format in the mail merge itself, but can not remember how to change it.
Perhaps I need to rebuild the look up table?
Regards
Amanda
"Doug Robbins - Word MVP" wrote:
Use an Access select query as the datasource and design that query show that
it shows the fields that you require in the mailmerge.
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
"Amanda H" Amanda wrote in message
...
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.