Print mailmerge with pg 1 to tray 1 and pg 2 to tray 2. Ideas?

G

goofylady33

Trying to print a mail merge letter. I want to print page 1 of each letter
to one paper tray and page 2 of the letter to a different tray. When I do it
now, it prints the first page of the merge to one tray, then the rest of the
merge to the second tray. It isn't differentiating the letters in the
document. Thoughts?
 
D

Doug Robbins

Execute the merge to a new document and then run the following macro on that
document and it will send each letter 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top