Mail Merge is merging onto separate pages & not printing all records

[Tindomerel]

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?

[Tindomerel]

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.

[macropod]

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.

[Tindomerel]

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

[macropod]

Originally Posted by Tindomerel

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.