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 / April 2007

Tip: Looking for answers? Try searching our database.

Duple Printing

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Kevin Bilbee - 27 Apr 2007 00:25 GMT
We have a merge document that used to start each new record on an odd
numbered page. We have recently upgraded from office 2000 to office 2007.
Some documents may spill over to a third page or even a fourth page during
the merge.

Is ther a way with Office 2007 to start each new record on an odd numbered
page so duplex printing works correctly.

Kevin Bilbee
Doug Robbins - Word MVP - 27 Apr 2007 08:46 GMT
Execute the mail merge to a new document and then use the
following macro to send that document to the printer:

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

That will cause each document to be sent to the printer as a separate print
job so that the duplexing should work correctly.
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

> We have a merge document that used to start each new record on an odd
> numbered page. We have recently upgraded from office 2000 to office 2007.
[quoted text clipped - 5 lines]
>
> Kevin Bilbee
Kevin Bilbee - 27 Apr 2007 18:28 GMT
Thank you for this suggestion. Our department running the merge has delete
their recent data run and fixed the document manually this week. When they
get new data they are going to save the merged document for me to play with.

Kevin Bilbee

> Execute the mail merge to a new document and then use the
> following macro to send that document to the printer:
[quoted text clipped - 18 lines]
>>
>> Kevin Bilbee

Rate this thread:






 
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.