Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / April 2005

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
sebmailmerge - 19 Apr 2005 22:51 GMT
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 - 20 Apr 2005 08:32 GMT
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

> Trying to create letters using Word's Mail Merge and Excell Spreadsheet as
> data source.   When multiple spreadsheet rows pertain to the same
[quoted text clipped - 7 lines]
> a
> different document.
frandalc@swbell.net - 20 Apr 2005 15:47 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.