I have a word document that is a merge document with an excel document as the source. Several rows partain to the same user and have to be listed together in the detail section of the merge document. Has anyone does this?



I think I have to create a directory merge and then somehow use an set and if statement to hide the top part of the merge document while the user remains the same between each row. However, this is not working for me. Does this sound right and if so, how do I create the set and if statements? Typing them in by hand does not seem to work.

Thanks!

See Graham Mayor's article and (free) add-in:
http://www.gmayor.com/ManyToOne.htm

Hi dkalsow,

You can use Word's Catalogue/Directory Mailmerge facility for this (the terminology depends on the Word version). To see how to do so with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial, in the 'Sticky' thread at the top of this forum:
Microsoft Word Catalogue/Directory Mailmerge Tutorial
The tutorial covers everything from list creation to the insertion & calculation of values in multi-record tables in letters. Do read the tutorial before trying to use the mailmerge document included with it.


For a recent, worked example, see the attachment to post #13 at: https://www.msofficeforums.com/mail-...nt-dollar.html

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]