Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-15-2018, 02:27 AM
Yarikh Yarikh is offline Page breaks in a list created with mail merge Windows 10 Page breaks in a list created with mail merge Office 2016
Novice
Page breaks in a list created with mail merge
 
Join Date: Jan 2018
Posts: 6
Yarikh is on a distinguished road
Question Page breaks in a list created with mail merge

Hello,
I need to create an archival inventory from an excel sheet. I have great amount of data such as dossier titles, dossier description, annotations, chronological referencies and so on.
I used mail merge without problems to obtain, from excel table, a report similar to the following:

ID
Title


Content
Annotations
Chronological extremes
Collocation
Classification

I successfully used rules to obtain the format I needed, but I still can't manage how to control page breaks. I created a report in which records are in sequence (not one for page) and separated by a line.
It happens that some record is cut beetween two pages so thet, for instance, only the ID is on the bottom of a page, while the rest of the fields are at the top ot the following one.
I need to optimize number of record per page, but I don't want to "cut" records in different pages.

I tried to format paragraph with "keep with previous" or "keep paragraph on the same page"... but I didn't obtained what I needed.

Is there any rule in mail merge I need to use?

Here are an abstract of the excel with the data, the template I created and the word file with results.

Thanks a lot!
Attached Files
File Type: xlsx Cartel1.xlsx (13.7 KB, 12 views)
File Type: docx ID.docx (12.8 KB, 11 views)
File Type: docx 1.docx (16.5 KB, 12 views)
Reply With Quote
  #2  
Old 01-15-2018, 02:19 PM
macropod's Avatar
macropod macropod is offline Page breaks in a list created with mail merge Windows 7 64bit Page breaks in a list created with mail merge 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

You could put all the content into a table cell, with the 'allow row to break across pages' option unchecked. See attached.
Attached Files
File Type: docx ID.docx (13.6 KB, 46 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 01-16-2018, 02:18 AM
Yarikh Yarikh is offline Page breaks in a list created with mail merge Windows 10 Page breaks in a list created with mail merge Office 2016
Novice
Page breaks in a list created with mail merge
 
Join Date: Jan 2018
Posts: 6
Yarikh is on a distinguished road
Default

So simple, yet so brilliant!
Thanks a lot!

Only one more question: if I need to create a file with hundreds or even thousands of records, could the tables make the file (already large) impossible to manage?
Reply With Quote
  #4  
Old 01-16-2018, 02:34 AM
macropod's Avatar
macropod macropod is offline Page breaks in a list created with mail merge Windows 7 64bit Page breaks in a list created with mail merge 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

Word is not particularly adept at handling lots of tables, or tables with very large cell counts; performance is liable to suffer in such cases. A file with "hundreds or even thousands of records" inserted into tables could do that. If the performance is unacceptable, you may find it advisable to split the output file into separate documents.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 01-16-2018, 02:39 AM
Yarikh Yarikh is offline Page breaks in a list created with mail merge Windows 10 Page breaks in a list created with mail merge Office 2016
Novice
Page breaks in a list created with mail merge
 
Join Date: Jan 2018
Posts: 6
Yarikh is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Word is not particularly adept at handling lots of tables, or tables with very large cell counts; performance is liable to suffer in such cases. A file with "hundreds or even thousands of records" inserted into tables could do that. If the performance is unacceptable, you may find it advisable to split the output file into separate documents.
Again, thanks.
I'll do so.
I'll merge together the different .pdf files once I create them.
Reply With Quote
  #6  
Old 01-16-2018, 02:42 AM
macropod's Avatar
macropod macropod is offline Page breaks in a list created with mail merge Windows 7 64bit Page breaks in a list created with mail merge 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

If all you're doing is generating PDFs, then it really doesn't matter that Word performs slowly with a huge table, since the PDF won't be affected by that.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
break pages, mail merge, paragraph formatting

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Page breaks in a list created with mail merge Avoid continous breaks turn into page breaks sponge Word 3 09-14-2017 12:11 PM
Page breaks in a list created with mail merge Detecting Page Breaks in Mail Merge Directory TimK9VB Mail Merge 6 11-20-2012 01:52 PM
Page breaks in a list created with mail merge Mail merge to print each record as it is created PNGento Mail Merge 1 01-26-2012 02:00 PM
Deleted Section Breaks Changes Page Breaks Brantnshellie Word 0 02-01-2009 09:22 PM
Paragraph Breaks In Mail Merge Fields SamuelT Mail Merge 0 09-25-2008 06:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:27 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