View Single Post
  #2   Report Post  
Peter Jamieson
 
Posts: n/a
Default

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.