I had been laboriously loading addresses into an Xcel spreadsheet data base I had created myself I was going to sort them alphabetically, then load them into a Word label document. Your last computer seminar was most informative in re address labels. If you can’t understand and utilize this tip to print your labels, get out your best pen and write them out instead. Watch the video as many times as you need to and you will NEVER be frustrated with printing labels again!! The tip centers around creating a word processing document where you can store, edit and print your labels quickly and easily. You will thank me every November when you need to print out your mailing labels. In this week’s tip, I take all of the mystery and hysteria out of creating and printing mailing labels. Since printing mailing labels is only a once per year activity for many of you, learning how to do it again every single year requires too much time and frustration. Too many computer users have no idea what a database is, how to use it, and how to merge it with another program to create labels. AND, I’ve included a template for you at the end of the article (below the video). 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’.You can learn and start using this tip TODAY to make Christmas card or group mailings a breeze.

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 print address labels from pages