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.

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

"sebmailmerge" wrote in message
news
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.

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