Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-03-2017, 04:35 PM
JennEx JennEx is offline Trailing Paragraph? forcing the creation of a blank page at the end of the document Windows XP Trailing Paragraph? forcing the creation of a blank page at the end of the document Office 2013
Competent Performer
Trailing Paragraph? forcing the creation of a blank page at the end of the document
 
Join Date: May 2010
Posts: 162
JennEx is on a distinguished road
Default Trailing Paragraph? forcing the creation of a blank page at the end of the document

My apologies if this isn't the most relevant forum to post this question.



I have a mail merge document designed to present information on two distinct records per page.

When I have two records, or an number of records divisible by two, I always get a trailing empty page.

When I view my document with formatting marks visible, I see my record tabel has a paragraph marker before and after it. I suspect this is the problrm, that the trailing paragraph is carrying over to a new page.

If I am on the right track, how do I remove that trailing paragraph? I trust to leading one will ensure that a space is left between the two records presented on the page.

If there is something more sinister, please point it out and advise how I can repair it.

Thank you in advance!

Reply With Quote
  #2  
Old 07-03-2017, 05:13 PM
JennEx JennEx is offline Trailing Paragraph? forcing the creation of a blank page at the end of the document Windows XP Trailing Paragraph? forcing the creation of a blank page at the end of the document Office 2013
Competent Performer
Trailing Paragraph? forcing the creation of a blank page at the end of the document
 
Join Date: May 2010
Posts: 162
JennEx is on a distinguished road
Default

I've noticed I have this field at the end of my table before the paragraph marker.

Reply With Quote
  #3  
Old 07-03-2017, 08:20 PM
gmayor's Avatar
gmayor gmayor is offline Trailing Paragraph? forcing the creation of a blank page at the end of the document Windows 10 Trailing Paragraph? forcing the creation of a blank page at the end of the document Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

How are you ensuring that you get two records per page? Looking at your screenshot it appears that the page has a header and footer. That would be awkward with two documents per page.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #4  
Old 07-04-2017, 12:07 PM
JennEx JennEx is offline Trailing Paragraph? forcing the creation of a blank page at the end of the document Windows XP Trailing Paragraph? forcing the creation of a blank page at the end of the document Office 2013
Competent Performer
Trailing Paragraph? forcing the creation of a blank page at the end of the document
 
Join Date: May 2010
Posts: 162
JennEx is on a distinguished road
Default

Hi GMayor ... I am not very knowledgeable to answer that question with any confidence. All I can say I have been using this for years (just only now getting around to try to tackle this annoyance. Requires a step of manual editing I was hoping to avoid) and the result have been consistent.

I think perhaps because the table is a set height that only two records using this table would fit. Understand it's two records per page ... each record filling the table. Two tables per page. If it's three, I get one page of two records, a second page of 1. If it's four records, I get two pages of two and a third empty page (except for header/footer) etc etc.

Luck perhaps?
Reply With Quote
  #5  
Old 07-04-2017, 08:52 PM
gmayor's Avatar
gmayor gmayor is offline Trailing Paragraph? forcing the creation of a blank page at the end of the document Windows 10 Trailing Paragraph? forcing the creation of a blank page at the end of the document Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

If you can supply the merge document and some dummy data (send it to supportATgmayor.com) I will see what the problem is. If you elect to do that put your form username in the subject of the message or it will be discarded.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #6  
Old 07-04-2017, 10:48 PM
macropod's Avatar
macropod macropod is offline Trailing Paragraph? forcing the creation of a blank page at the end of the document Windows 7 64bit Trailing Paragraph? forcing the creation of a blank page at the end of the document Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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

Quote:
Originally Posted by JennEx View Post
I think perhaps because the table is a set height that only two records using this table would fit. Understand it's two records per page ... each record filling the table. Two tables per page. If it's three, I get one page of two records, a second page of 1. If it's four records, I get two pages of two and a third empty page (except for header/footer) etc etc.
The effect may well be due to the fact a Word document must have at least one paragraph break following a table. If your two tables are filling the page, the trailing paragraph break would be forced to the next page. What process (if any) are you using to correct this manually?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 07-05-2017, 03:55 PM
JennEx JennEx is offline Trailing Paragraph? forcing the creation of a blank page at the end of the document Windows XP Trailing Paragraph? forcing the creation of a blank page at the end of the document Office 2013
Competent Performer
Trailing Paragraph? forcing the creation of a blank page at the end of the document
 
Join Date: May 2010
Posts: 162
JennEx is on a distinguished road
Default

Hi Paul. That is what I assumed was happening but was hoping their was a way to prevent/avoid it.

Once the mail merge document has been created, I go to the top line of thebody of the blank page and press delete. This removes the blank page.

Graham, thank you so much for your generous offer to assist. I appreciate having two pros on the case and I don't want to disrespect anyone's thoughts or suggestions. Hopefully collectively a resolution can be found and shared with the community.
Reply With Quote
  #8  
Old 07-05-2017, 03:56 PM
macropod's Avatar
macropod macropod is offline Trailing Paragraph? forcing the creation of a blank page at the end of the document Windows 7 64bit Trailing Paragraph? forcing the creation of a blank page at the end of the document Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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

Hi Jenn,

Can you attach a copy of the mailmerge main document to a post?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #9  
Old 07-05-2017, 04:17 PM
JennEx JennEx is offline Trailing Paragraph? forcing the creation of a blank page at the end of the document Windows XP Trailing Paragraph? forcing the creation of a blank page at the end of the document Office 2013
Competent Performer
Trailing Paragraph? forcing the creation of a blank page at the end of the document
 
Join Date: May 2010
Posts: 162
JennEx is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Hi Jenn,

Can you attach a copy of the mailmerge main document to a post?
You may find it quite familiar .... in fact so familiar I presented this issue earlier but I never finished pursuing the solution. https://www.msofficeforums.com/mail-...opulating.html

So, an apology is in order for basically duplicating a post. But, the solution there, like here, evades me.
Attached Files
File Type: docx DR15v1.docx (33.4 KB, 7 views)
Reply With Quote
  #10  
Old 07-05-2017, 09:26 PM
gmayor's Avatar
gmayor gmayor is offline Trailing Paragraph? forcing the creation of a blank page at the end of the document Windows 10 Trailing Paragraph? forcing the creation of a blank page at the end of the document Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

The problem is the conditional field that inserts a page break after the table. It is not required if you format the first two rows of the table as 'keep with next'.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #11  
Old 07-06-2017, 04:03 PM
JennEx JennEx is offline Trailing Paragraph? forcing the creation of a blank page at the end of the document Windows XP Trailing Paragraph? forcing the creation of a blank page at the end of the document Office 2013
Competent Performer
Trailing Paragraph? forcing the creation of a blank page at the end of the document
 
Join Date: May 2010
Posts: 162
JennEx is on a distinguished road
Default

Hi Graham, thank you for providing me the solution. Things appear to be working wonderfully now.

I very much appreciate your openness to share your skill.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Trailing Paragraph? forcing the creation of a blank page at the end of the document insert blank page in document Patryk Word VBA 1 01-22-2016 03:11 AM
Trailing Paragraph? forcing the creation of a blank page at the end of the document Delete bookmark and paragraph which is blank dsjk9190 Word VBA 2 01-22-2015 01:15 AM
Trailing Paragraph? forcing the creation of a blank page at the end of the document Dynamic page creation? nightkn8 Word 1 07-02-2014 05:38 AM
Deleting a blank page at end of document word perfect Word 5 07-11-2013 06:40 AM
How to Insert a Clear, Blank page without Lines and Numbers in a Pleading Document Dirigo Word 5 09-30-2011 08:08 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:30 PM.


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