Mac Forums

Mac Forums (http://www.mac-forums.com/forums/)
-   OS X - Apps and Games (http://www.mac-forums.com/forums/os-x-apps-games/)
-   -   Exporting e-mail contacts (http://www.mac-forums.com/forums/os-x-apps-games/190741-exporting-e-mail-contacts.html)

cranwinks 02-11-2010 12:56 PM

Exporting e-mail contacts
 
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.

cranwinks 02-17-2010 04:28 PM

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


All times are GMT -4. The time now is 06:35 AM.

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