printing a mail merge file on different paper

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DarrelGiesbrecht - 26 Sep 2006 15:24 GMT

I have a three-page letter in MS Word to merge with 100 MS Excel records to
equal 100 personalized three-page letters. How do I set up the print job on a
printer (high end HP or Ricoh) so that after I have merged the letter and
created a 300 page file, every first page (of the 100 letter file) prints on
letterhead and every second and third page is on plain paper? So far, I have
discovered that the print drivers can recognize First Page, Last Page, cover
pages and such, but everything in between is considered to be the "same".

Reply to this Message

Doug Robbins - Word MVP - 26 Sep 2006 18:07 GMT

If you use the following macro to print the document, it will send each of
the 100 letters to the printer as a separate print job:

Dim i As Long
With ActiveDocument
For i = 1 To .Sections.Count
.PrintOut Range:=wdPrintFromTo, From:="s" & i, To:="s" & i
Next i
End With

Signature

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

>I have a three-page letter in MS Word to merge with 100 MS Excel records to
> equal 100 personalized three-page letters. How do I set up the print job
[quoted text clipped - 7 lines]
> cover
> pages and such, but everything in between is considered to be the "same".

Reply to this Message

Rate this thread: