#1
|
|||
|
|||
Mail Merge is merging onto separate pages & not printing all records
I have Windows 10 with Office 2016. I am trying to create a directory with a list of names, addresses, etc. with a heading at the top and the data in two columns below it. The last field has to be in a text box. I have set up the main document and the data file is an Excel file. The merge seems to be fine but each record is on a new page. I tried adding the Next Field in front of the merge fields. Alternatively, I tried using the Mail Merge Wizard and indicating I wanted a directory. Since it was repeating the document heading on each record, I tried taking out the heading. Either way, each record is a separate page when I want them to follow one another in the column format without breaking for a new page.
Can anyone tell me how to get it to stop putting each record on a separate page? |
#2
|
|||
|
|||
Mail Merge not printing all records
I have Windows 10 and Office 2016. I am trying to do a mail merge into a Word document with a heading on the first page and all data in two columns beneath. I did the merge but found that all the records were not printing and they were all selected in the Excel data file. It is skipping records but there is only one Next Record field and it is at the top of the main document before the first field. This is meant to be a directory.
Any idea why? Thanks. Last edited by Tindomerel; 09-30-2017 at 08:02 PM. Reason: Read a post on this subject and it did not solve. |
#3
|
||||
|
||||
Your description suggests you're either using a Letter merge instead of a Directory merge or that your mailmerge main document contains a page break or Section break.
In a Directory merge, you should not be using NextRecord fields; they will be the cause of skipped records.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#4
|
|||
|
|||
Reply to Mail Merge is merging onto separate pages and not printing all records
As I said, and I have repeated the experiment, I have selected Directory. The Excel merge document had two sheets; when I removed the blank sheet and renamed the sheet containing the data "Sheet1," and reselected, I noticed it now seems to be picking up all the records which is one problem solved. However, it is still printing on separate pages and the main document has "Next Field" inserted at the top which I did not do. The program seems to be putting it in.
I have attached a jpeg of a screen capture of the main document. I am not able to send you the document because it contains sensitive information. Perhaps there is something in the way the main document is formatted that is causing the problem. I want to have the header on the first page but below to have the data in two columns on all the rest of the pages. Thanks. JK |
#5
|
||||
|
||||
Quote:
As for the printing on separate pages, that may be due to the amount of data you're trying to output - the page seems pretty full. Other than that, your first record's 'continuous' Section break is liable to be converted to a 'next page' Section break. It's not apparent to me why you have a Section break there at all.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
mail merge help, mail merge problem, mail merge rule |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Many records to One Mail Merge Document | CONFUSEDOPSMANAGER | Mail Merge | 1 | 05-08-2017 02:56 PM |
How do I mail merge records into table columns with more than one merge field? | tech123 | Mail Merge | 1 | 04-26-2017 07:13 PM |
Mail merging reports with different numbers of records on each page | chrisbarnettuk | Mail Merge | 1 | 11-11-2015 01:14 PM |
Mail merge--skipping records | 623bookends | Mail Merge | 2 | 01-12-2014 06:02 AM |
Mail Merge - Many Records for Each Addressee | awalker1970 | Mail Merge | 1 | 12-31-2010 11:52 AM |