Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

how to print address labels?

I have addresses in an excel spreadsheet (pre mac days) or some in my address book- I want to print labels for Christmas cards to avoid the hand writing-- Anyone know how to do either (convert from excel or address book contacts into printing labels?

MacBook, Mac OS X (10.6.7), iphoto '09

Posted on Nov 29, 2011 5:43 PM

Reply
Question marked as Best reply

Posted on Nov 30, 2011 12:31 AM

Look in the Print dialog box of Address Book it has templates for a wide variety of labels in: Layout/Label.


You can import data from tab delimited text files, which you can export from Excel.


See Importing contacts from other applications in Address Book Help.


Peter

12 replies

Nov 30, 2011 11:10 AM in response to Jerrold Green1

Unfortunately that's not practical, since these mailings are unique each time they are done. They could happen every few months, or once or twice a year depending on the projects I'm working on (I'm an architect).


I did find an Avery template at iworkcommunity.com. I use the 5160 which I found here: http://www.iworkcommunity.com/content/avery-labels-address-book-merge

but if you do a search of Avery Labels you can find most of the others you need. This works for what I'm trying to do as I had to type in all the addresses fresh each time anyway.


Merging with address book doesn't work well as it repeats one contact for all the labels on each page, so you get a page of labels for John Doe, a page of labels for Janet Scofield, a page of labels for Mom, etc. Not very useful for mailings.

Nov 30, 2011 12:42 PM in response to osterlure

Unfortunately, you are limiting yourself by not becoming more familiar with the tools. You don't want all the the address in your main account's AddressBook, but you don't want them separate either. Having a separate account is no big deal, easy to get in and out of. Then again, I don't believe that putting rarely used names in your main account's AddressBook is a big deal either, so you have lots of options. In the case of using your main account, create a Group for your Personal contacts and drag all those contects into it prior to adding the special ones. Then create a Group for your special contacts and use it when doing the labels. When not makinig labels, keep the Personal Group selected and all displays and searches will ignore any names in the Special Group.


Used properly, AddressBook will make labels for mailing just as you desire. You apparently were using the mode for printing return address labels.


Jerry

Nov 30, 2011 1:47 PM in response to Jerrold Green1

Jerry:


Yes - I see I misunderstood how you were printing the labels, and I had forgotten that when you print directly from the address book you can print a wide variety of label forms. That certainly works well for regular mailings (in fact I used that last year for the family holiday mailing), however it still isn't ideal for my situation. I have no need for 50-100 temporary addresses in my address book (syncing back and forth to various other iOS devices as well) for people that I'm only mailing once and will then have to turn around and delete. It my situation is actually less effort to type the addresses directly into a word processor as you do not need to jump between fields, you can save the file with the other project files, and be done with it. In any case, having the Avery template for Pages works adequately for now. It would be nice if Pages had a label printing system similar to the AddressBook (which is similar to what Word has), but it's not a major issue...


Thanks for your help.


- McCArch

Nov 30, 2011 2:25 PM in response to WarrenfromPotomac

Warren: looking at other threads out there it doesn't appear that you can print the spouse/partner/friend field. One poster suggested using Avery DesignPro for Mac, which merges with your AddressBook, and allows you to select which fields to include. The only caveat is that it doesn't show it working with Lion (os 10.7). You can download it here:


http://www.avery.com/avery/en_us/Templates-%26-Software/Avery-DesignPro-for-Mac. htm?N=0&refchannel=c042fd03ab30a110VgnVCM1000002118140aRCRD


Hope this helps.


-McCArch

Dec 1, 2011 9:30 AM in response to osterlure

Avery Design Pro works very well on Lion. I use it to create custom labels for all kinds of stuff and it prints beautifully on my HP 6500.


As a sidenote, let me add that while Pages and Word are great word processors, labels are a more specialized application. I prefer to use tools that work best at a particular job, like Design Pro for labels, and PrintShop for business cards, CD cases, and greeting cards. I think suites like Office suffer from feature bloat taking the Swiss Army knife approach.

how to print address labels?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.