Incorrect formatting of numbers can cause errors in the merge. I’ve been a paid/organic social media/creative director, a digital marketing manager, an email marketing specialist, a web producer, private consultant. Format Numerical Data Correctly: Be sure that things like street numbers and zip codes are properly formatted for the way they should appear once the mail merge is complete.Also, make sure the headers you choose match the merge field names, which will also make it less likely errors will occur. To make it easy for Excel to differentiate between data and labels, use bold text, cell borders, and cell shading that are unique to the header row. I go to Mailings, Start Mail Merge, select the labels, select the recipients, via Outlook Contacts, set up the add the Address Block to the document and then I should be able to 'Update Labels' and all of the 'Labels' on the page. A header row is a row containing labels that identify the data in the cells beneath it. I am trying to create a list of mailing labels via Mail Merge in Word 2016. Create a Header Row: Create a header row for the sheet you intend to use for the mail merge.

Also, make sure the sheets are clearly named, as you have to select the one you intend to use without being able to view it. If it's spread across multiple sheets, combine the sheets or perform multiple mail merges. Put All Data on a Single Sheet: The mailing list data you intend to use for the mail merge must be on one sheet.

Microsoft office 2016 mail merge labels