#1
|
|||
|
|||
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! |
#2
|
||||
|
||||
You could put all the content into a table cell, with the 'allow row to break across pages' option unchecked. See attached.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
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? |
#4
|
||||
|
||||
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] |
#5
|
|||
|
|||
Quote:
I'll do so. I'll merge together the different .pdf files once I create them. |
#6
|
||||
|
||||
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] |
Tags |
break pages, mail merge, paragraph formatting |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Avoid continous breaks turn into page breaks | sponge | Word | 3 | 09-14-2017 12:11 PM |
Detecting Page Breaks in Mail Merge Directory | TimK9VB | Mail Merge | 6 | 11-20-2012 01:52 PM |
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 |