I still find it hilarious I had performed this activity for over two years without issue until last week. I found that if I saved the Excel spreadsheet into a previous version, not as a 2010 resolved the issue, utilizing On the task pane, under the heading Step 1 of 6, click Next: Starting document. From the Tools menu, point to Letters and Mailings, and then select Mail Merge from the submenu. The exported from an Act! Database Excel spreadsheet was causing the issue. The Mail Merge toolbar is added above the open document. I am not a programmer, I am an administrative assistant and messing around with code isn't easy.Īnyways, thanks for the help and suggestion.Īlso, I found out how to fix the issue. I was using ADDRESS BLOCK not individual fields, yet Iĭid do that two days before I posted it. See the steps to mail merge from an Excel. There is not page or paragraph breaks, when I finally figured out how to reveal the code. If you use Microsoft Office 2016 with a Mac computer, you can easily import addresses or other data from an Excel spreadsheet or from your Apple Contacts and place them onto Avery labels, name badges, name tags or other products to edit and print using Microsoft Word for Mac. I searched this topic before and found this same solution from you. (that was stated in my original posts that I tried the individual mail merge fields to no avail). Paul, that is not the format that I am using, I am using the wizard's ADDRESS BLOCK.

Office 2016 mail merge labels