Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Multivalued fields
I'm using Word 2007 Mail Merge with Access 2007 data source (DDE). One of the fields merged is a multivalued lookup field. The data displayed in the merge are the code values for the lookup field and not the display values. How can you easily merge the display valueS for a multivalued lookup field? Thanks |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Multivalued fields
Word can only use a single, flat file as a data source. Accordingly, you
should construct a query in Access that displays all of the information that you require in the mail merge. Actually, I assume however that want you probably want to create is a mail merge that amounts to a one to many type. That is actually best done in Access using a Report. However, take a look at: http://cornell.veplan.net/article.aspx?&a=3815 or fellow MVP, macropod's tutorial on Catalogue/Directory Mailmerges at: http://www.wopr.com/cgi-bin/w3t/show...?Number=731107 -- 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 "Merge user" Merge wrote in message ... I'm using Word 2007 Mail Merge with Access 2007 data source (DDE). One of the fields merged is a multivalued lookup field. The data displayed in the merge are the code values for the lookup field and not the display values. How can you easily merge the display valueS for a multivalued lookup field? Thanks |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 2007 Mail Merge Labels skips fields using update fields | Mailmerge | |||
2007 Merge Fields (database) lock fields after selection VBA | Microsoft Word Help | |||
Auto fill Form Fields from previous Variable fields? | Microsoft Word Help | |||
MS Word form fields versus mail merge fields | Mailmerge | |||
posting data from text input fields to fields later in document | Microsoft Word Help |