To see how to use Word's Catalogue/Directory Mailmerge facility (the terminology depends on the Word version) to produce an output with grouped records using 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

Alternatively, you may want to try the Many to One utility on the MergeTools Add-in that you can download from the following page of Doug Robbins' Windows Live SkyDrive: Microsoft OneDrive - Access files anywhere. Create docs with free Office Online.

PS: Please don't simply add posts seeking help with new issues to other peoples' solved threads. I've split this one off into a new thread of its own.

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