Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Separating Mail Merge output into different files
Hey Guys.
I need some help. I am creating these letters using mail merge from an excel spreadsheet. The problem is that I need to create 100 2-page letters and the output is one huge word document. How do I perform this mail merge and automatically break it apart into separate files? It is a nightmare to do manually. (And I worried about updates to the template.) Also is there anyway to automatically rename the new files as well using the name field from the Merge. "Letter for NAME.doc " Thanks for your help on this! Regards, -Michael |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Separating Mail Merge output into different files
See the "Individual Merge Letters" item on fellow MVP Graham Mayor's website
at: http://www.gmayor.com/individual_merge_letters.htm If you are using Word XP or later, the "Add-in to Merge Letters to Separate Files" that I have written and that can be downloaded from that site will allow you to create each letter as a separate file with a filename taken from a field in the data source with a minimum of fuss. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Michael" wrote in message ... Hey Guys. I need some help. I am creating these letters using mail merge from an excel spreadsheet. The problem is that I need to create 100 2-page letters and the output is one huge word document. How do I perform this mail merge and automatically break it apart into separate files? It is a nightmare to do manually. (And I worried about updates to the template.) Also is there anyway to automatically rename the new files as well using the name field from the Merge. "Letter for NAME.doc " Thanks for your help on this! Regards, -Michael |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort a Mail Merge from two different files | Mailmerge | |||
Can't get Word 2003 to keep data file with mail merge main documen | Mailmerge | |||
Mail Merge to files with filenames from database | Mailmerge | |||
Saving mail merge documents to different files | Mailmerge | |||
Attaching different Excel files to emailed mail merge using merge. | Mailmerge |