Print merged letters on different media

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KRAGW - 28 Jul 2008 15:10 GMT

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?

Reply to this Message

Graham Mayor - 28 Jul 2008 15:20 GMT

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

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> 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
[quoted text clipped - 8 lines]
> 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?

Reply to this Message