Multivalued fields

[Merge user]

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

 

[Doug Robbins - Word MVP]

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/showthreaded.pl?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