Thread
:
Merge field - Look up table problem
View Single Post
#
2
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
Posts: 8,832
Merge field - Look up table problem
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.
Reply With Quote
Doug Robbins - Word MVP
View Public Profile
Find all posts by Doug Robbins - Word MVP