how to make address labels from contacts on mac

Select a field on the left and drag it over to place it on the right. Uncheck any items you don’t want to be included, such as the header row on your spreadsheet. Next, click on the edge of the text box and select Import Data from the menu on the left.īrowse to find your spreadsheet file on your computer. Otherwise, your text will be shrunk to fit. When you find a design you’d like to use, click Select this Design.įirst, resize the text box to be big enough to hold your addresses.

Use the menu on the left to view design categories. To start a new project, type your Avery product number and hit Enter on your keyboard. Open the free Avery Design & Print Online software at /print. Step 1: Go to Avery Design & Print Online If you don’t have a spreadsheet of your contact names and addresses yet, you can get started with our pre-formatted files for Microsoft Excel or other database programs. This is a must-have for mass mailings you’re sending to multiple recipients. Here’s how to use the mail merge feature to turn your address list into labels in minutes. If needed, preview the labels (Preview Results → ABC)Īt this stage you might want to save the Merge Document for future useįinally, create a document with labels by clicking on the symbol for ‘Merge Document’ under ‘Complete Merge’.A quick and easy way to create personalized address labels is with Avery Design & Print. Optionally, select a suitable Contacts group (Filter Recipients → Options) Open the Mail Merge Manager from Word’s Tools menu.Ĭhoose the relevant label type (Select Document Type → Create New → Labels…)Ĭonnect the Merge Document to Contacts by choosing ‘Get list → Apple Address Book’Ĭlick under ‘Select Recipients List’ on the symbol for ‘Add or remove place holders for labels’ to create the label template ( not under ‘Insert Placeholders’!) Here is how it works:Ĭreate a New Blank Document from Word’s File menu (let’s call it the ‘Merge Document’). Unlike previous versions of Word, Word 2011’s Mail Merge Manager can import data directly from Apple Contacts. If this is a problem MS Word 2011 might come to your rescue. Apple Contacts (previously: Address Book) can print labels, but it does not allow you to edit the labels. Current versions of Pages lack a feature to print labels.

How to make address labels from contacts on mac