how to print address labels from excel 2013

To do this, on the Mail Merge Manager window under #6 Complete Merge, select 'Merge to New Document'.Ī new document will appear with all the labels filled in. The last step is to actually run the merge to create a file with all your labels that you can print. After you press the 'Fill in the items to complete your document' button, your document should look like this. First add the image to the first label.Īnd the propagate it out to the other labels. If you wanted to add an image, do the same thing. Your labels should now have all the changes. Press the 'Fill in the items to complete your document' button to do this. Next, you need to propagate the change on this label to all the other labels. Change the font/alignment/etc to whatever you want it to look like. Now to format the labels, work on the first label in the upper left corner of the page. You should now have a bunch of labels that look something like this: Click OK when you have all the info in the label that you want. Now just insert the fields from the spreadsheet along with whatever other text you want. The Mail Merge Manager should look something like this: You'll now have the data from the spreadsheet available to your label. You will then be prompted to pick which sheet and which cells, just take the default. You may get a warning like below, just click OK. For me, it will be names_and_numbers.xlsx. Under #2, click 'Get List' and select 'Open Data Source' and then pick your excel file. Pick the label type that you're going to use. Under #1, select Labels from the Create New dropdown choice. We just need to work through the steps on it. Next, start word and open the Mail Merge Manager.Ī small window (called the Mail Merge Manager) will pop up. I've named this file names_and_numbers.xlsx. First, you should have an excel spreadsheet with the names and whatever other data you want to use.

How to print address labels from excel 2013