Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I get multiple Excel rows merged into Word document when ..
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros - Keyboard Commands | Microsoft Word Help | |||
Locking Two Words Together to Make a Proper Compound Noun in Word | Microsoft Word Help | |||
Wordperfect Office 2000 conversion to Word 2003 | New Users | |||
Converted document from WordPerfect. New footnotes are not being. | Microsoft Word Help | |||
word xp crashes after macros are recorded | Microsoft Word Help |