how can I make Address Book print labels how I want, or export to Word?

I have found a number of serious problems with Address Book, which unless I can overcome them mean it is entirely useless for me. Almost all are to do with creating mailing labels or envelopes:

1.I can't find any way of defining a sheet format for labels different from those on the pre-defined list. My labels are in 2 columns of 8, on a sheet 12” long by 8” wide, margins 0.5mm top and bottom, and ½” left and right. The labels themselves are 3½” x1½”. Address Book can't do it. It is odd that this is so restrictive, whereas with envelopes one has total flexibility.

2.Although I can define which address I want to print on each label or envelope, I can't find a way of defining which field should be used for the first (name) line. It always consists of the First and Last names as recorded on each card. This is not what I want. For different mailings, I want to use different first lines, as in many cases each card is the address of a family group, the First and Last names simply recording the names of the parents e.g., John and Mary Smith. But for my Christmas mailing I want to print 'The Smith Family', whereas for my charity mailshots I want to print 'Mrs Mary Smith', as she is the charity supporter, not her husband or children.

3.The address layout seems to be fixed, with each element on a separate line. This is not how I want to print, as in some cases it makes for too many lines, particularly on labels. I want to put the zip/post-code on the same line as the county or state, separated by about ½”. But I can't see how to dictate the layout at all. On labels there is a further problem, in that I can't define a vertical and/or horizontal off-set for the text.

4.The Country does not print at all on labels, making the application quite useless for foreign mailings, and I can't find a way of overcoming this. Over half our mailing addresses are affected by this.

5. And another problem really puts the final cherry on the icing of this cake: There is no way I can find of exporting the data from the address book in a format, e.g. a csv file, that I can bring into a word processor where I could do these mailings how I want them. Not only does the box fail to do what I need, it is also locked.

I don't understand why, having set up Address Book on the database principle that one should have have to record each contact only once no matter how many ways one needs to use the data, it seems it has then been implemented in a way that prevents it being used in one of the most obvious ways, to print addresses in a format of the user's choice.

The Applecare adviser tells me the problems I have can't be overcome. Is that right, or is she, and I missing something? Please help.

20" iMAC 2.4GHz, Mac OS X (10.5.6)

Posted on Nov 9, 2009 6:37 AM

Reply
12 replies

Nov 9, 2009 6:57 AM in response to kenhosking

The problem isn't Address Book; it's that you're trying to make it do things it was never intended to do. It's a contact manager, meaning that every person has an individual contact card, and you can't just pick and choose a particular field to print for your specific purpose at any given time.

Since Address Book can't do the things you seem to think are necessary, you can use PearLabelizer, which will allow you to edit the text fields of labels, among other things.

Nov 9, 2009 10:09 AM in response to kenhosking

This article offers some suggestions on printing labels, including custom label sizes, from Address Book.

If you want to export a CSV take a look at Gwenhiver's Address Book Exporter.

Avery offer a free program for printing labels from (amongst others) Address Book.

In AB's label printing dialog box you should be able to select, on the Layout tab, custom label sizes, and on the Label tab, whether or not to include the country, with the ption to exclude the "home" country.

User uploaded fileAK

Dec 9, 2009 9:30 AM in response to Austin Kinsella1

I have some similar issues with Address Book (no easy/fast way to enter multiple people at the same company/address, kludgy way of getting both Name and Company to print on address labels). For me, the answer ends up being a combination of Apple's Numbers and Avery's Design Pro for Mac. You can try Numbers, part of the iWorks bundle, for 30 days for free, and the Avery program is a free download. Apparently they're both limited in what they can do, but plenty powerful for what I need. Once the cell headers are properly named in Numbers, you can simply drag info from Address Book, then edit or add as needed. It is ridiculously easy to add multiple people at the same address, and also very easy to mail merge this info into Avery's label program, by exporting the Numbers data as CSV. I found plenty of control for deciding which fields print where on the labels.
HTH,
Dan

Dec 14, 2009 8:57 AM in response to kenhosking

I entirely agree with kenhosking; Address Book is maddening in its lack of printing features. If Apple is going to let us print the contents of Address Book at all, then they could make it a lot more useful. It's Christmas card time again and the fact that Address Book is useless for this purpose is really frustrating. My needs are simple; an alternative title field that one could populate with customized text, such as Mr & Mrs John Smith, or Mr John & Mrs Mabel Smith, or John Smith & Mabel Jones, or whatever. When printing, the label would print the alternative title field if not empty, or the regular title field if the alternative is empty. This trivial extra function would make Address Book so much more useful and I proposed it to Apple a year ago. Result? The usual stoney silence. Do these guys ever listen to users? So, back to hand writing scores of envelopes again...

Dec 14, 2009 10:57 AM in response to Brian Smale

Brian Smale wrote:
I entirely agree with kenhosking; Address Book is maddening in its lack of printing features. If Apple is going to let us print the contents of Address Book at all, then they could make it a lot more useful. It's Christmas card time again and the fact that Address Book is useless for this purpose is really frustrating. My needs are simple; an alternative title field that one could populate with customized text, such as Mr & Mrs John Smith, or Mr John & Mrs Mabel Smith, or John Smith & Mabel Jones, or whatever. When printing, the label would print the alternative title field if not empty, or the regular title field if the alternative is empty. This trivial extra function would make Address Book so much more useful and I proposed it to Apple a year ago. Result? The usual stoney silence. Do these guys ever listen to users? So, back to hand writing scores of envelopes again...


Address Book is supposed to be able to do this via the "Spouse" field, but it's extremely buggy and given that the feature has in fact been removed from the version of Address Book in Snow Leopard, I wouldn't get your hopes up for a fix.

Dec 14, 2009 3:36 PM in response to m0thr4

Replying to m0thr4, I am aware of Apple's failed attempt to use the spouse field; the result was mostly garbage and it seems to have deserved its demise. Why doesn't Apple stop trying to be smart and realize that no programmed solution will ever satisfy everyone? I think my approach of having a field that the user can customize to his/her liking is far simpler to implement and is more or less guaranteed to please everyone.

Dec 15, 2009 3:44 AM in response to noondaywitch

noondaywitch wrote:
"It's Christmas card time again and the fact that Address Book is useless for this purpose is really frustrating."

While I sympathise with the functionality of Address Book, I'm old-fashioned enough to write my cards and envelopes by hand (shock! horror!) and get quite p ***-off to receive bulk-printed stuff.

Just a thought, peeps.


It'd be all too easy to follow that up with a cheapshot making reference to how many Christmas cards you have to send, but I'll rise above that and explain that some of us might want to use this for business contacts and have 300+ cards to address.

It is a shame that the printing feature from Address Book is so close, yet so far from performing this simple task. It is a shame that Pages can run mail merge, but only for one record per page (which is useless for label printing). It is also a shame that MS Word for Mac does proper labels but doesn't recognise Address Book as a datasource.

These things are all a shame because with Apple's software, you rather expect things to "just work", as per their advertising, and when very simple things don't "just work", it difficult not to feel cheated.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

how can I make Address Book print labels how I want, or export to Word?

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