- #How to do a mail merge in word 2010 for labels how to#
- #How to do a mail merge in word 2010 for labels zip#
#How to do a mail merge in word 2010 for labels how to#
If that’s the case, check out our existing tutorials on how to combine text cells in Excel and how to make a page landscape in Word. Now that you know how to print labels from Excel, you may be eager to get even more out of your Office applications. How to Combine Text Cells in Excel and Make a Page Landscape in Word Remember to save the document in case you need to reprint any of them. With all of your addresses imported, you can finally print your labels and send off your mail. Tick “All” in the “Merge to New Document” window and press “OK”.Open the “Mailings” tab again and click on “Finish & Merge”, then “Edit Individual Documents…”. If it does, open the “Mailings” tab again and press the green “Update labels” buttonĪddressBlock will now appear in all of your labels.Check whether “AddressBlock” appears in your first label.Otherwise, you may need to modify your fields again.
![how to do a mail merge in word 2010 for labels how to do a mail merge in word 2010 for labels](https://www.officearticles.com/img/content/word/mmlbls1.jpg)
Check the preview in the “Insert Address Block” window and check the preview.In our case, for example, “Property Name” and “Operator Name” take the place of first and last name. If they don’t line up exactly, that’s fine. In the “Required for Address Block” section, match the fields to your column names.Press “Match Fields…” in the “Insert Address Block” window.To see the labels, click the TABLE TOOLS LAYOUT tab, and click View Gridlines. Word adds blank labels to a new document. Well just use the same labels from the first movie, and click OK. You start by selecting your label options. Open the “Mailings” tab in your Word ribbon and click “Address Block” Click the MAILINGS tab, and click Start Mail Merge, and Labels.Select your sheet name, tick “First row of data contains column headers” and press “OK”.Browse to your mailing list file, select it, and press “Open”.Press “Mailings > Select Recipients > Use an Existing List…”.Select your label options and press “OK”.The mail merge feature will allow you to easily create labels and import data to them from a spreadsheet application. Open the “Mailings” tab of the Word ribbon and select “Start Mail Merge > Labels…”. Once everything has been prepared with the correct column headers, you can save your work and continue to the next step to create labels from Excel. If you’re using your labels for a mailing list, you may want to include heading labels like first name, last name, and title.
#How to do a mail merge in word 2010 for labels zip#
This will help you to match your fields to the correct columns later on.įor example, in ours we’ll be using the fields property name, operator name, address, city, state, zip code, and country. The important thing to remember is that you must create a column header noting the information that will go in each heading.
![how to do a mail merge in word 2010 for labels how to do a mail merge in word 2010 for labels](https://support.content.office.net/en-us/media/4682406c-3eb8-497c-812a-c256b0596350.png)
If you don’t have one, you can create one now. Before you can create labels from Excel, you’ll need your existing mailing list in the application. Although this page is primarily concerned with label merges, there is no essential difference between the different types of.