How do I get multiple Excel rows merged into Word document when ..

[sebmailmerge]

Trying to create letters using Word's Mail Merge and Excell Spreadsheet as
data source. When multiple spreadsheet rows pertain to the same individual,
I need all of the rows associated with same individual (name column) to be
placed in one document only. In other words, How do I get multiple Excell
rows merged into one Word Document as oppposed to one row per document.
Basically I need rows that pertain to one individual merged onto one
document. When the name column changes, the new row should be palced on a
different document.

 

[Peter Jamieson]

Word isn't designed to do this. Some approaches are described at

http://homepage.swissonline.ch/cindymeister/

Look for Mail Merge FAQ, Special Merges, Multiple items per condition.

The DATABASE field approach mentioned there is unlikely to be useful in this
case.

Peter Jamieson

 

[frandalc]

You can do this pretty well using a macro that handles merge events in
the mail merge template. I have a mail merge that has a word table in
each letter that may contain more than one row. I just handle the
MailMergeAfterRecordMerge event, and check my datasource for additional
rows that may need to be inserted into the table. It's in VBA so it's a
little clunky, but it works.

I gave up on MailMergeBeforeRecordMerge Cancel option as it always
seems to cancel the entire merge.

_Randal