+ Reply to Thread
Results 1 to 3 of 3

Include a separator page (blank) after a specified amount of prints

Hybrid View

Papa28x4 Include a separator page... 06-25-2012, 09:37 AM
macropod Re: Include a separator page... 06-25-2012, 06:31 PM
Papa28x4 Re: Include a separator page... 07-01-2012, 08:27 AM
  1. #1
    Registered User
    Join Date
    05-28-2012
    Location
    Lagos
    MS-Off Ver
    Excel 2007
    Posts
    7

    Cool Include a separator page (blank) after a specified amount of prints

    I have document in word that was merged to an excel spreadsheet that over 5000 rows which I intend to print.

    Option 1: When printing I would like to print out a blank page after every 50 pages.

    Option 2: Print out a blank page when the value of a particular merged field changes.

    Any help would be appreciated, thanks

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,835

    Re: Include a separator page (blank) after a specified amount of prints

    I would do this by coding the mailmerge main document to create the blank page every 50 pages. You could do this by adding the following field coding to the bottom of your exsting mailmerge main document's content:
    {IF{=MOD({MERGESEQ},50)}= 0 {QUOTE 12}}

    Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 (Cmd-F9 on a Mac) - you can't simply type them or copy & paste them from this message.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Registered User
    Join Date
    05-28-2012
    Location
    Lagos
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Include a separator page (blank) after a specified amount of prints

    Thank u so much, I'll try it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1