+ Reply to Thread
Results 1 to 4 of 4

2-Sided Mail Merge with a blank 2nd page

  1. #1
    Forum Contributor
    Join Date
    10-30-2014
    Location
    England
    MS-Off Ver
    2007 / 365
    Posts
    279

    2-Sided Mail Merge with a blank 2nd page

    Sorry to create two threads on Mail Merge, but they are unrelated issues, so I hope that's okay.

    I have a 2 page Mail Merge doc that is set to print as 2-sided. The second page only has only has a single merge field on it and occasionally there are records in the data that have no value in that field. This causes an issue when printing as it seems Word must see the page as blank during the merge for these records and it then causes the first page to be printed on the wrong side of the paper.

    As the current solution I have just put a . on the second page with a 1pt font size, so it isn't visibly printed but it seems be enough for Word to recognise that there is content on the page and to print it as 2-sided.

    Is that the best solution though, or is there a better/easier way to ensure Word always prints all records as 2-sided regardless of if the merge field is populated or blank?

  2. #2
    Registered User
    Join Date
    04-05-2023
    Location
    Alskas, USA
    MS-Off Ver
    Office 16
    Posts
    6

    Re: 2-Sided Mail Merge with a blank 2nd page

    Your current solution of inserting a small character on the second page with a 1pt font size to ensure that Word recognizes there is content on the page is a creative workaround. However, there is a better way to ensure that Word always prints all records as 2-sided, regardless of whether the merge field is populated or blank.

    One solution is to use section breaks to separate the two pages into different sections. Then, set the section break on the first page to start on an odd-numbered page, and set the section break on the second page to start on an even-numbered page. This will ensure that the first page always prints on the front of a sheet of paper, and the second page always prints on the back.

    Here's how you can do it:

    1-Place your cursor at the end of the first page.
    2-Go to the Page Layout tab and click on the Breaks button.
    3-Under Section Breaks, select "Next Page" under "Section Breaks."
    4-Place your cursor on the second page.
    5-Go to the Page Layout tab and click on the Breaks button.
    6-Under Section Breaks, select "Continuous" under "Section Breaks."
    7-Click on the Page Setup dialog box launcher at the bottom right corner of the Page Setup group.
    8-Under the Layout tab, select "Different odd and even" under "Headers and footers."
    9-Click OK.

    Now, your document should have two sections, with the first section containing the first page and the second section containing the second page. The first section will always start on an odd-numbered page, and the second section will always start on an even-numbered page, ensuring that both pages print on the correct side of the paper, regardless of whether the merge field is populated or blank.

  3. #3
    Registered User
    Join Date
    04-30-2023
    Location
    Pakistan
    MS-Off Ver
    2019
    Posts
    1

    Re: 2-Sided Mail Merge with a blank 2nd page

    Quote Originally Posted by Luciamartyn View Post
    Your current solution of inserting a small character on the second page with a 1pt font size to ensure that Word recognizes there is content on the page is a creative workaround. However, there is a better way to ensure that Word always prints all records as 2-sided, regardless of whether the merge field is populated or blank.

    One solution is to use section breaks to separate the two pages into different sections. Then, set the section break on the first page to start on an odd-numbered page, and set the section break on the second page to start on an even-numbered page. This will ensure that the first page always prints on the front of a sheet of paper, and the second page always prints on the back.

    Here's how you can do it:

    1-Place your cursor at the end of the first page.
    2-Go to the Page Layout tab and click on the Breaks button.
    3-Under Section Breaks, select "Next Page" under "Section Breaks."
    4-Place your cursor on the second page.
    5-Go to the Page Layout tab and click on the Breaks button.
    6-Under Section Breaks, select "Continuous" under "Section Breaks."
    7-Click on the Page Setup dialog box launcher at the bottom right corner of the Page Setup group.
    8-Under the Layout tab, select "Different odd and even" under "Headers and footers."
    9-Click OK.

    Now, your document should have two sections, with the first section containing the first page and the second section containing the second page. The first section will always start on an odd-numbered page, and the second section will always start on an even-numbered page, ensuring that both pages print on the correct side of the paper, regardless of whether the merge field is populated or blank.
    Thank you for sharing this solution. Using section breaks to separate the two pages into different sections is a great way to ensure that both pages always print on the correct side of the paper, regardless of the content in the merge field. This is a more reliable solution than inserting a small character on the second page, as it eliminates the need for a workaround and ensures that the document is formatted correctly. I appreciate your contribution!

  4. #4
    Forum Contributor
    Join Date
    10-30-2014
    Location
    England
    MS-Off Ver
    2007 / 365
    Posts
    279

    Re: 2-Sided Mail Merge with a blank 2nd page

    Quote Originally Posted by Luciamartyn View Post
    ...
    Thanks for the reply. I will implement this when I can. Certainly seems preferable to my workaround.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Mail Merge: New Page when data changes
    By gshort in forum Word Formatting & General
    Replies: 13
    Last Post: 05-09-2018, 07:30 AM
  2. Mail Merge : All-in-1 Page with Complex Scenario
    By donkeybusiness in forum Word Formatting & General
    Replies: 4
    Last Post: 01-30-2013, 03:06 AM
  3. [SOLVED] MS Word Mail Merge, 3 records per page?
    By H.E. Pennypacker in forum Word Formatting & General
    Replies: 1
    Last Post: 12-31-2012, 10:34 PM
  4. Mail Merge - Mutiple records per page
    By mivanows in forum Excel General
    Replies: 0
    Last Post: 08-27-2012, 02:53 PM
  5. Mail Merge Multiple Records on 1 page
    By NealEHerman in forum Word Formatting & General
    Replies: 5
    Last Post: 08-26-2012, 04:08 AM
  6. Mail Merge from Excel ( More than once record per page)
    By allenglishboy in forum Excel General
    Replies: 0
    Last Post: 07-17-2012, 06:05 AM
  7. Mail Merge page numbers issue on 1st page only
    By Internoob2 in forum Word Formatting & General
    Replies: 1
    Last Post: 09-22-2011, 10:35 AM

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