Did you actually execute the merge to a new document? If you a separate
document created for each record, execute the merge to a new document and
then run the following macro on that document:
Sub splitter()
' splitter Macro
' Macro created by Doug Robbins to save each letter created by a mailmerge
' as a separate file, retaining the header and footer information.
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
Set Target = Documents.Add
Target.Range = Letter
Target.Sections(2).PageSetup.SectionStart = wdSectionContinuous
Target.SaveAs FileName:="Letter" & i
Target.Close
Next i
End Sub
For other methods, see the "Individual Merge Letters" item on fellow MVP
Graham Mayor's website at:
http://www.gmayor.com/individual_merge_letters.htm
--
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
"Nancy 2glow" Nancy
wrote in message
...
The separate documents I created using Mail Merge are opening with the
Excel
data source. How do I stop this from happening?