Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-27-2020, 04:07 AM
vender vender is offline inserting a page break after each 9th page? or skip print on the 10th page ? Windows 10 inserting a page break after each 9th page? or skip print on the 10th page ? Office 2010
Novice
inserting a page break after each 9th page? or skip print on the 10th page ?
 
Join Date: May 2020
Posts: 1
vender is on a distinguished road
Default inserting a page break after each 9th page? or skip print on the 10th page ?

Hi,

I received a document made with mail merge , that has some contracts that end up on 9 pages each and i need to print them on both sides, so if i do that the the 5th page on the back gets the first page of the second contract. The document has 1.800 some pages, so doing a page break manually every 10th page will take to much time



So basically i want to find a way to print the entire document but to have the 5th page of the back side blank and the 10th page to start to print on a new page and page 11 on the back ..and so on...
Reply With Quote
  #2  
Old 05-27-2020, 05:01 AM
Charles Kenyon Charles Kenyon is offline inserting a page break after each 9th page? or skip print on the 10th page ? Windows 10 inserting a page break after each 9th page? or skip print on the 10th page ? Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 6,938
Charles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to beholdCharles Kenyon is a splendid one to behold
Default

This document likely has an ordinary "next-page" section break at the end of the merge. Are there any section breaks in the document other than the one between merge records?

If this is the only instance of section breaks, here is a macro that changes all next-page section breaks to odd-page section breaks.

Code:
Sub ChangeSectionNextPageToOddPage()
 'Macro created by Stefan Blom, MVP, 12 January 2020
' How do I replace Next Page section breaks with Odd Page section - Microsoft Community

 '
    Dim s As Section
    '
    For Each s In ActiveDocument.Sections
    If s.PageSetup.SectionStart = wdSectionNewPage Then
        s.PageSetup.Setup.SectionStart = wdSectionOddPage
    End If
    Next s
    Set s = Nothing
  End Sub
Reply With Quote
  #3  
Old 05-27-2020, 05:18 AM
macropod's Avatar
macropod macropod is offline inserting a page break after each 9th page? or skip print on the 10th page ? Windows 7 64bit inserting a page break after each 9th page? or skip print on the 10th page ? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,497
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

Quote:
Originally Posted by vender View Post
I received a document made with mail merge , that has some contracts that end up on 9 pages each and i need to print them on both sides, so if i do that the the 5th page on the back gets the first page of the second contract. The document has 1.800 some pages, so doing a page break manually every 10th page will take to much time
The simplest solution would be to insert the following field code into the mailmerge main document before the merge is executed:
{=MOD({PAGE},2) \# "'{QUOTE 12}';;"}

Note: The field brace pairs (i.e. '{ }') for the above example are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac or, if you’re using a laptop, you might need to use Ctrl-Fn-F9); you can't simply type them or copy & paste them from this message. Nor is it practical to add them via any of the standard Word dialogues. The spaces represented in the field constructions are all required.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Page Break is adding Blank Page when Break occurs JoannL54 Word 3 07-01-2016 05:58 AM
inserting a page break after each 9th page? or skip print on the 10th page ? How to add page numbering after next page break with landscape and portrait Jashley1 Word 2 11-25-2014 10:36 PM
inserting a page break after each 9th page? or skip print on the 10th page ? Removing space before blank page / page break greasel Word 5 10-17-2014 07:04 PM
inserting a page break after each 9th page? or skip print on the 10th page ? First section will not 'insert' blank page even though sectn 2 is 'odd' page break Pat_Hodgson Word 6 12-01-2013 04:22 PM
inserting a page break after each 9th page? or skip print on the 10th page ? Navigation and TOC show blkank space when inserting page break Tomtheappraiser Word 1 03-05-2012 04:04 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 01:50 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft