Printing envelopes from Address Book

I'd like to print my holiday card envelopes directly from Address Book. However, I want to use a different field than the usual First Name, Last Name. In example, I'd like to not print "John Smith" but print another field that would be "Mr. and Mrs. Smith" or "The Smith Family." —without changing every existing record.

I've also tried exporting the vcard group file, but can't figure out how to get it in Word.

Any ideas on how I can accomplish this task?

Thanks!

G4, Mac OS X (10.4.3)

Posted on Dec 6, 2005 11:45 AM

Reply
Question marked as Top-ranking reply

Posted on Dec 7, 2005 2:55 PM

Hi,
I have literally spent weeks getting all of my contacts in order, only to find that Address Book is good for getting information in, but terrible for getting it back out. I too found that Address Book allows for no flexibility in determining which fields will be used in an address. It also does not properly "formerly" address contacts.

I also ran into the problem of contacts being addressed as first, last, and related names. I have found that if you create a separate group for the contacts for whom you are creating envelopes or labels, the envelope will print differently.

For example, first create a group (i.e. Holiday Cards) in AB and put your desired contacts in it. Highlight it. Select File, Print and then select the Label tab. Instead of selecting "All", select the group for which you want to print envelopes or labels. The prefix, first, last, and suffix will then print for those records. If you select "All", as you mentioned, the address will read first, last, and related names.

Another way that I addressed the issue is by using the Job Title and Department fields to store formal addresses for personal entries, since I did not need to track this information for personal contacts. For example, Mary Smith, a good friend, who is married to Bill (spouse), who is also a physician, with 3 kids (child, child, child) would have the "Job Title" of Dr. and Mrs. William Smith and Family, and the "Department" is Mary and Bill and Family (or list kids names).

If I use AB to print the envelope, with Mary in a Group, the envelope will print "Mary Smith". If I use AB and print All records, the envelope will print Mary Smith and Bill, child, child, and child.

Or, you can then use Automator to export the information from the selected group into a text file, (Job Title and Department are 2 fields that can be exported along with other basic fields such as name, address, phone, emails), import the text file into Excel, and create a mail merge envelope in Word using the data from Excel. (I did run into a little trouble with the actual address information importing properly into Excel due to a hard return between the street address and the city, requiring me to manually tweek the text file.) But this, despite the work, enabled me to address the family properly and completely.

The solution that someone else recommended to change the related relationship to other will work, but it will compromise your data.

Also, using AB envelopes uses both the prefix and the suffix, which is often inappropriate. It would be better if Business contacts or any records marked "Company" used the first, last and suffix, and non "Company" contacts used the prefix, first and last. And for that matter, related names should have prefixes and suffixes and the logic should be such that spouses names would be properly put together and childrens names omitted from a formal address.

I thought that Address Book would work for me, but now I'm in an even worse place than I was last year when I was managing all of these addresses in an Excel spreadsheet!

Good luck and happy holidays!


iMac Mac OS X (10.4.3)
10 replies
Question marked as Top-ranking reply

Dec 7, 2005 2:55 PM in response to forestlaurel

Hi,
I have literally spent weeks getting all of my contacts in order, only to find that Address Book is good for getting information in, but terrible for getting it back out. I too found that Address Book allows for no flexibility in determining which fields will be used in an address. It also does not properly "formerly" address contacts.

I also ran into the problem of contacts being addressed as first, last, and related names. I have found that if you create a separate group for the contacts for whom you are creating envelopes or labels, the envelope will print differently.

For example, first create a group (i.e. Holiday Cards) in AB and put your desired contacts in it. Highlight it. Select File, Print and then select the Label tab. Instead of selecting "All", select the group for which you want to print envelopes or labels. The prefix, first, last, and suffix will then print for those records. If you select "All", as you mentioned, the address will read first, last, and related names.

Another way that I addressed the issue is by using the Job Title and Department fields to store formal addresses for personal entries, since I did not need to track this information for personal contacts. For example, Mary Smith, a good friend, who is married to Bill (spouse), who is also a physician, with 3 kids (child, child, child) would have the "Job Title" of Dr. and Mrs. William Smith and Family, and the "Department" is Mary and Bill and Family (or list kids names).

If I use AB to print the envelope, with Mary in a Group, the envelope will print "Mary Smith". If I use AB and print All records, the envelope will print Mary Smith and Bill, child, child, and child.

Or, you can then use Automator to export the information from the selected group into a text file, (Job Title and Department are 2 fields that can be exported along with other basic fields such as name, address, phone, emails), import the text file into Excel, and create a mail merge envelope in Word using the data from Excel. (I did run into a little trouble with the actual address information importing properly into Excel due to a hard return between the street address and the city, requiring me to manually tweek the text file.) But this, despite the work, enabled me to address the family properly and completely.

The solution that someone else recommended to change the related relationship to other will work, but it will compromise your data.

Also, using AB envelopes uses both the prefix and the suffix, which is often inappropriate. It would be better if Business contacts or any records marked "Company" used the first, last and suffix, and non "Company" contacts used the prefix, first and last. And for that matter, related names should have prefixes and suffixes and the logic should be such that spouses names would be properly put together and childrens names omitted from a formal address.

I thought that Address Book would work for me, but now I'm in an even worse place than I was last year when I was managing all of these addresses in an Excel spreadsheet!

Good luck and happy holidays!


iMac Mac OS X (10.4.3)

Dec 7, 2005 7:30 AM in response to forestlaurel

Hi, I'm doing the Christmas cards as well. Like you, I did not want my envelopes (or labels) to read: "Mr.& Mrs. John Smith and Mary and Billy and Bobby..." I added a Prefix and Suffix field in the AB template. Then in the pull-down menu for related names, change everyone you have listed there to "other" (instead of "spouse" or "child" etc.) and they will not be listed on the envelope. Then you get "Mr. & Mrs. John Smith" and you can put "& Family" as a suffix if you like. I had to go thru all my entries, though. However, for new entries it was much easier because I'd changed the "related names" field in the template to "other."
For "The Smith Family" I would skip the Prefix, use "The" as the first name, "Smith" as the last name, and "Family" as the Suffix (then add their names in the "other" field so you know which Smiths they are).
judeblue

Dec 7, 2005 11:08 AM in response to judeblue

Oh, yeah... oh yeah... I'm doing the happy dance! Oh yeah... oh yeah!

Thanks to you both for giving me great solutions. And thanks for hanging out here in the forums lending your time and expertise. Santa will be very, very good to you this year.

And what a coincidence, judeblue, that we both know the Smiths!

;^) Happy Holidaze!

P.S. I didn't mark this problem as Solved as I believe Apple could add more customization to make this task easier in a future version.

G4 Mac OS X (10.4.3)

Dec 8, 2005 10:21 AM in response to forestlaurel

Greetings, Forestlaurel,

I agree with you that there's got to be a better way. Jumping thru hoops just to print a label or an envelope is not how time should be spent - but I'll stick with a good old-fashioned work-around anyday as long as it's on my Mac.
I'm going back to the forums to see if anyone's solved the return-address dilemma.
Sincerely,
judeblue

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.

Printing envelopes from Address Book

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