Results 1 to 3 of 3
Thread: Word 2007 mail merge
2010-02-10, 16:02 #1
I am doing a mail merge with Word 2007, the data source is an Excel file. I need to save all the letters as individual Word files. By default it seems to put all the letters as separate pages in one file. Is there a way to tell it to separate each letter into its own file? I see that I can tell it to just merge the current record, but that method seems tedious.
Also,is there a way to have the titles of the saved Word files be the name of the person the letter is going to, which is found in the Name column in the Excel file?
2010-02-10, 20:10 #2
- Join Date
- May 2002
- Canberra, Australian Capital Territory, Australia
- Thanked 439 Times in 362 Posts
You can't change Word's mailmerge output behaviour, though the Adobe Acrobat Add-in gives you the ability to save each letter as a separate file (I think they're just numbered files, though).
There are also macro-based solutions for splitting the Word file into separate documents. See, for example: http://www.gmayor.com/individual_merge_letters.htmCheers,
[MS MVP - Word]
2010-02-11, 16:57 #3
OK thanks, macropod. I'll take a look at that.