Solved

Word 2007 - Mail Merge - Duplex - Force 1st page

Posted on 2011-02-16
2
977 Views
Last Modified: 2012-05-11
I have a mail merge document that will be printed in duplex after the merge.  Most of the time, each merge record will product 4 pages (front/back, front/back).  Sometimes, it may push to 5 pages, which would cause the printout to be front/back, front/back, front.  How can I make sure that page 1 of the document will always print on the front and not the back of the record before it?
0
Comment
Question by:David Kroll
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 76

Accepted Solution

by:
GrahamSkan earned 500 total points
ID: 34910343
Do you create a result document or do you print directly.

If the former, you might try printing directly. I don't know and can't test it (no duplex facility), but there is a possibility that each record will be treated as a separate print job which would always start on page one.

Otherwise you could run this macro on the result document before printing. It will turn the next-page section breaks that separate each record's output into odd page section breaks.

Sub ChangeSectionBreaks()
    Dim sec As Section
    For Each sec In ActiveDocument.Sections
        sec.PageSetup.SectionStart = wdSectionOddPage
    Next sec
End Sub

Open in new window

0
 
LVL 11

Author Closing Comment

by:David Kroll
ID: 34910899
While your code didn't do exactly what I needed, it led me in the right direction of checking section breaks using odd/even pages.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I'm writing to share my clumsy experience in using this elegant tool so you can avoid every stupid mistake I made. (I leave it to the authorities to decide if this deserves a place in the Knowledge archives.)  Now that I am on the other side of my l…
A few years ago I was very much a beginner at VBA, and that very much remains the case today.  I'll do my best to explain things as I go in the hope that other beginners can follow.  If you just want to check out a tool that creates a Select Case fu…
This video teaches the viewer how to align pictures around text while keeping the text properly aligned in the document.
This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses. Navigate to the “Start Mail Merge” button in the Mailings tab: Follow the step-by-step process until asked to find the address doc…

695 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question