Mail Merge into separate documents

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joshua - 18 Mar 2004 18:51 GMT

I am trying to merge documents together and have the
output be individual documents, rather than one document
with each merge on a separate page. Is this possible? I
need to save each new file as a file.adm so it can be run
in ADAMS simulation software, so each merge needs to be a
new file. Thanks!

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 19 Mar 2004 03:59 GMT

Sub splitter()

' splitter Macro

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

Dim Letters As Integer, Counter As Integer
Letters = ActiveDocument.Sections.Count
Selection.HomeKey Unit:=wdStory
Counter = 1
While Counter < Letters
DocName = "Myletter" & LTrim$(Str$(Counter))
ActiveDocument.Sections.First.Range.Cut
Documents.Add
Selection.Paste
ActiveDocument.Sections(2).PageSetup.SectionStart = wdSectionContinuous
ActiveDocument.SaveAs FileName:=DocName, FileFormat:= _
wdFormatDocument, LockComments:=False, Password:="",
AddToRecentFiles:= _
True, WritePassword:="", ReadOnlyRecommended:=False,
EmbedTrueTypeFonts:= _
False, SaveNativePictureFormat:=False, SaveFormsData:=False, _
SaveAsAOCELetter:=False
ActiveWindow.Close
Counter = Counter + 1
Wend

End Sub

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

>I am trying to merge documents together and have the
> output be individual documents, rather than one document
> with each merge on a separate page. Is this possible? I
> need to save each new file as a file.adm so it can be run
> in ADAMS simulation software, so each merge needs to be a
> new file. Thanks!

Reply to this Message