office 2016 mail merge labels from excel

Note that for labels, you may want to center your text on the label to make sure that a slight shift in the printer doesn’t make your labels unusable. To add a “tab” within a label, press “crtl+tab.”Ĭlick “Update Labels” to make this merge layout copy into each label. You can also use formatting such as different fonts, font styling, spacing, size, etc. Note, I did add spaces between first and last name, and state and zip, and a comma and a space between city and state.

This is now what my first label looks like: For example, if you wanted to have a “company name” appear for those addresses where it was applicable, but not have an extra space where it isn’t, Word will format it correctly. Note: While editing the document, pushing “Enter” will not insert a new line unless data is populated. You will either get a pop-up window or a drop-down menu listing the headers for each column in your spreadsheet.Ĭlick the fields you want to insert them into the document. You can experiment using different tools, but for now we will just do a basic mail merge that will work for most any purpose. You will now have many more options under the “Mailings” menu. Navigate to the Excel document with your data Once you have made your selection, click “ok.”Ĭlick “Mailings” then “Start Mail Merge” then “Use Existing List” To change the template, click “Options”Įach major vendor is listed under “Label Vendors” and all of their product numbers are listed.

The last template you used will show up under “Label” (In this case Avery #5385). This will be on the product packaging.Ĭlick on “Mailings” then “Labels,” and a pop-up window will appear. If you are creating labels or cards, you will need to know what template to use. If you are creating letters, compose the letter and then skip the following section. For our example, we’ll use names and addresses.įor the Word document, you will need to know what you need to create. To begin, you will need an Excel spreadsheet with the data you want to insert into the Word document. Mail Merge is a powerful tool using Microsoft Word and Excel to generate labels or rolodex cards from a template, customized letters and more.

Office 2016 mail merge labels from excel