how to print address labels from excel 2011

Click the Create New button to select Labels from the list.Ģ. In the Mail Merge Manager window click on Select Document Type to expand the selection. In this case we will be printing labels, but you can also print form letters, envelopes, and catalog.ġ. Click Mail Merge Manager from the list.įirst thing we need to do is select the document type that you will be printing. Create a blank document in Word 2011 and click Tools.Ģ. How to Print Labels in Word 2011 with Mail Merge Manager Open Mail Merge Manager in Word 2011ġ. Try to keep data fields like Address, City, State, and Zip Code in separate columns (see example below). Software/Hardware used: Excel 2011 and Word 2011 running on Mac OS X.īefore proceeding the first thing you need to do is ensure that you have a properly formatted Excel spreadsheet to use as the data source for your labels. If you have any comments or questions please use the comments form at the end of the guide. For those of your coming from Office for Windows you will notice that there a lot of differences between Mail Merge in Windows and Mac, but I’ve detailed each of the steps below to guide through the entire process.

In the steps below I will show you how to print labels from a list using Word 2011. Are you trying to print a set of labels from an address list stored in Excel, FileMaker, or your Apple Contact list? If so you are going to love this guide.

How to print address labels from excel 2011