printing mail merge with 4 pages per reciepient

[nancy]

I have succefully created a mail merge document, however word recognizes this
as one file for printing. I need to print this massive file and have this
stapled and collated on every fouth page. Othewise 4,490 pages print out and
someone has to manually separate and staple these. I must be missing
something??

 

[macropod]

Hi nancy,

When you do a mailmerge with Word, all the merged records go into one file - there is no way to change this. There are various ways
to split the output into a separate file for each record (see, for example, the code below from fellow MVP Doug Robbins, which will
alow the printer to staple each letter (if it supports that)), but you're still going to have the same number of pages to print
overall.

Sub SplitMergeLetterToPrinter()

' splitter Macro
' Macro created 16-08-98 by Doug Robbins to print each letter created by a
' mailmerge as a separate file.
'
Letters = ActiveDocument.Sections.Count
counter = 1
While counter < Letters
ActiveDocument.PrintOut Background:=False, Range:=wdPrintFromTo, _
From:="s" & format(counter), To:="s" & format(counter)
counter = counter + 1
Wend
End Sub

In case you've never used a macro before, see:
http://www.gmayor.com/installing_macro.htm