New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

Start a Discussion

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
OS X - Apps and Games Discussion of applications and games available for Mac OS X.

Exporting e-mail contacts

Post Reply New Thread Subscribe

Thread Tools

Member Since: Feb 02, 2010
Posts: 5
cranwinks is on a distinguished road

cranwinks is offline
Is there a way to export names and e-mail addresses from Address Book that can be opened by or imported into excel or a tab-delineated file? I exported vCards but couldn't seem to work with them in any of my other programs.
QUOTE Thanks

Member Since: Feb 02, 2010
Posts: 5
cranwinks is on a distinguished road

cranwinks is offline
Okay, I figured it out myself. First, open your address book, go to the directory you want to export from. Select all the people from the Name window, copy, and past into an excel column. Now, for the e-mail addresses for those people, open a new mail message, and paste all those names into the body of the e-mail message. That should give you all the e-mail addresses. Select all and copy that file, paste it into a Word document (or equivalent), and do a search and replace to eliminate the comma space and replace with paragraph, to give you one long column of e-mail addresses. Then copy that, open the spreadsheet, and paste the e-mail addresses into the column next to the names. It should all come out even at the bottom. Good luck! — cranwinks
QUOTE Thanks

Post Reply New Thread Subscribe

« Having problems with Transmission! | Adium Window "skin"? "cover"? »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread Starter
Last Post
Mail is missing messages 2surgeons OS X - Operating System 0 02-04-2010 06:23 PM
Mail and Contacts Problem Connaught OS X - Operating System 0 02-12-2009 01:54 PM
Exporting Thunderbird messages to Mail glenninnz OS X - Apps and Games 2 11-14-2006 11:28 PM
Import/export Contacts For 'mail' Donagh OS X - Apps and Games 3 01-09-2006 12:10 PM
Mail Folder "exclusively locked" by user klippe OS X - Apps and Games 3 09-06-2005 07:20 PM

All times are GMT -4. The time now is 07:30 PM.

Powered by vBulletin
Copyright ©2000 - 2015, Jelsoft Enterprises Ltd.

Welcome to

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!

(4 digit year)

Already a member?