View Single Post
  #4   Report Post  
Doug Robbins
 
Posts: n/a
Default

Try this one:

Sub splitter()

' splitter 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


--
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
"Matty_b" wrote in message
...
I found your website when searching through google looking for the answer
and
tryed you macro but couldnt get it to work, can you give me a walk through
of
how to make this work, and also more information on what the outcome
should
be?

Thanks for you help