Print merged letters on different media

[KRAGW]

I've created a mutiple-page letter that I need to merge with data from an
Excel file. I want the first page of the letter to print on letterhead and
subsequent pages to print on second sheet stock.

Once I merge the documents, I don't know how to make this happen. I can ask
in the Print Setup dialog box that the first page be different and it's stock
pulled from a different drawer in the printer, but that only works for the
first letter in the merged document.

I'd rather not have to separate the first page, merge it, then print the
rest of the letter and manually collate them. Any suggestions?

 

[Graham Mayor]

Merge to a new document then use the following macro to send each letter to
the printer as a separate job.

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

http://www.gmayor.com/installing_macro.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>