Mail Merge In Word

[Tiff]

Hello

Does anyone know if there is a way when creating a letter merger in
word to have each letter be a new document. I have an excep
spreadsheet of 120 records and I want each letter I merge with to be
its own new document, not 120 pages in one document.

Any help would be SO appreciated.

Thanks, Tifany

 

[Daiya Mitchell]

I don't think so, but you could use this macro by MVP Doug Robbins to split
the merged document after the fact. It saves each section into its own file.

However, it just names the files Letter1, Letter2, etc. You could easily
change the "letter" part but it would be tricky to get the name to
correspond to the person or anything.

Might want to test it on a file with just a few sections first.

Sub splitter2()

' splitter2 Macro

' Macro created by Doug Robbins to save each letter created by a mailmerge
' as a separate file.

Dim i As Long, Source As Document, Target As Document, Letter As Range
Set Source = ActiveDocument
For i = 1 To Source.Sections.Count
Set Letter = Source.Sections(i).Range
Letter.End = Letter.End - 1
Set Target = Documents.Add
Target.Range = Letter
Target.SaveAs FileName:="Letter" & i
Target.Close
Next i

End Sub