Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 09-30-2017, 06:25 PM
Tindomerel Tindomerel is offline Windows 10 Office 2016
Novice
 
Join Date: Sep 2017
Posts: 3
Tindomerel is on a distinguished road
Default 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?
Reply With Quote
  #2  
Old 09-30-2017, 07:56 PM
Tindomerel Tindomerel is offline Windows 10 Office 2016
Novice
 
Join Date: Sep 2017
Posts: 3
Tindomerel is on a distinguished road
Default 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.
Reply With Quote
  #3  
Old 09-30-2017, 11:53 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 16,660
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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
[MS MVP - Word]
Reply With Quote
  #4  
Old 10-01-2017, 02:31 PM
Tindomerel Tindomerel is offline Windows 10 Office 2016
Novice
 
Join Date: Sep 2017
Posts: 3
Tindomerel is on a distinguished road
Default 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
Attached Images
File Type: jpg SAI Merge Main Document.jpg (276.2 KB, 4 views)
Reply With Quote
  #5  
Old 10-01-2017, 03:30 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 16,660
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Quote:
Originally Posted by Tindomerel View Post
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.
The only time Word will insert a «Next Record» field of its own accord is for a label merge when you click on the 'Update labels' button and there are labels to update. You should delete that field.

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
[MS MVP - Word]
Reply With Quote
Reply

Tags
mail merge help, mail merge problem, mail merge rule

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 03:58 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft