Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / August 2005

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
goofylady33 - 30 Aug 2005 16:20 GMT
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?
Doug Robbins - 30 Aug 2005 20:20 GMT
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

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

> Trying to print a mail merge letter.  I want to print page 1 of each
> letter
[quoted text clipped - 4 lines]
> merge to the second tray.  It isn't differentiating the letters in the
> document.  Thoughts?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.