Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-12-2020, 08:02 AM
catflap's Avatar
catflap catflap is offline Set number of pages in a merged doc Windows 7 64bit Set number of pages in a merged doc Office 2013
Advanced Beginner
Set number of pages in a merged doc
 
Join Date: Aug 2015
Location: UK
Posts: 72
catflap is on a distinguished road
Default Set number of pages in a merged doc

Hi

I have a doc with lots of merge info, some of which pushes it onto 2 pages for some records but not for others.



Is there a simple way of setting up the doc so it's always 2 pages long? - even if the data would fit on 1 page? (ie the 2nd page is blank)

I could put some conditional lines to pad things out, but it would be quite tricky due to the complexity of it (I have inherited this from someone else), so I wondered if there was a simple way at all?

Thanks
Reply With Quote
  #2  
Old 05-12-2020, 08:14 AM
Charles Kenyon Charles Kenyon is offline Set number of pages in a merged doc Windows 10 Set number of pages in a merged doc Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,081
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Yes, you could put in a manual page break where you want to start the second page. This is going to look not that great and you could potentially end up with three pages rather than two.


A better method would be to change one or more of the following:
  1. Line spacing - space between lines within a paragraph
  2. Paragraph spacing - space between paragraphs
  3. Font size
  4. Narrow your paragraph indents to give the appearance of wider margins.
All of the above can likely be done by modifying a couple of styles.
Reply With Quote
  #3  
Old 05-12-2020, 08:41 AM
catflap's Avatar
catflap catflap is offline Set number of pages in a merged doc Windows 7 64bit Set number of pages in a merged doc Office 2013
Advanced Beginner
Set number of pages in a merged doc
 
Join Date: Aug 2015
Location: UK
Posts: 72
catflap is on a distinguished road
Default

Hi


Manual page break would just add an extra page every time unless I made it conditional as you say, so I don't want to do that.


I also can't change the layout because the client wants it untouched, so need some way of fixing the number of pages.


Is it possible to place an object on page 2, like an empty text box, which would force 2 pages but not be visible when printed? - I tried it with a text box but it didn't seem to work, it still went to 1 page sometimes.


Cheers
Reply With Quote
  #4  
Old 05-12-2020, 09:03 AM
Charles Kenyon Charles Kenyon is offline Set number of pages in a merged doc Windows 10 Set number of pages in a merged doc Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,081
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

A text box or object can only be on one page.
You could insert a manual page break (Ctrl+Enter) and then insert a large blank borderless textbox (at least half a page) on the new second page, then delete the page break.

Be careful of your "Keep with next" and "Keep lines together" paragraph formatting or you could end up with an orphan signature block or the like at the top of your second page.


[Edit: See Paul Edstein's post following for a much more elegant idea.]

Last edited by Charles Kenyon; 05-12-2020 at 04:35 PM.
Reply With Quote
  #5  
Old 05-12-2020, 03:54 PM
macropod's Avatar
macropod macropod is offline Set number of pages in a merged doc Windows 7 64bit Set number of pages in a merged doc Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

At the end of your mailmerge main document, insert a field coded as:
{IF{SECTIONPAGES}= 1 {QUOTE 12}}
This will result in every processed record containing the second page.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #6  
Old 05-12-2020, 03:54 PM
Guessed's Avatar
Guessed Guessed is offline Set number of pages in a merged doc Windows 10 Set number of pages in a merged doc Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Odd page section break between each Record?
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #7  
Old 05-28-2020, 03:21 AM
catflap's Avatar
catflap catflap is offline Set number of pages in a merged doc Windows 7 64bit Set number of pages in a merged doc Office 2013
Advanced Beginner
Set number of pages in a merged doc
 
Join Date: Aug 2015
Location: UK
Posts: 72
catflap is on a distinguished road
Default

Hi guys


Sorry for the delay in reply.


In the end I just bit the bullet and went through all the merge info and added a break where it was needed.


I just saw Macropod's suggestion which looks promising, but I've done it the hard way now so wont try it out this time, but will the next time this sort of problem comes up.


Thanks to all who posted suggestions - this forum has always been extremely helpful to me.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Set number of pages in a merged doc Number Pages - not total pages, but actual pages. Kiminator321 Word 8 04-29-2020 03:07 PM
Set number of pages in a merged doc Word 2016: Stop merged cells from breaking across pages FiveFingers Word Tables 2 08-16-2016 06:27 AM
Set number of pages in a merged doc Adding sequential Number in a document that already has merged fields inserted Highlander01 Mail Merge 3 01-19-2016 12:33 PM
How to view individual pages after completing a merged catalog CSD Publisher 0 11-29-2014 10:45 PM
Set number of pages in a merged doc Is there a limit to the number of labels that can be merged inOffice 2010 djsn Mail Merge 3 06-22-2012 05:52 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:51 AM.


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