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.

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

SAI Merge Main Document.jpg (276.2 KB, 18 views)