[DarrelGiesbrecht]

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".

[Doug Robbins - Word MVP]

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



--
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

"DarrelGiesbrecht" wrote in
message ...
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".