Solved

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

Posted on 2011-02-16
2
944 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
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Introduction Authors who set out to write any sort of lengthy piece for online submission—be it a long question or comment on a technical form, an article, or a substantial blog entry—often find it useful to work up a draft in an editor other t…
This is written from a 'VBA for MS Word' perspective, but I am sure it applies to most other MS Office components where VBA is used.  One thing that really bugs me is slow code, ESPECIALLY when it's mine!  In programming there are so many ways to…
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.

706 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now