Results 1 to 2 of 2
  1. #1

    Member Since
    Feb 02, 2010
    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.

  2. #2

    Member Since
    Feb 02, 2010
    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

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Exporting email contacts from SENT items?
    By Mosh in forum macOS - Operating System
    Replies: 3
    Last Post: 05-30-2013, 12:37 AM
  2. Exporting Contacts
    By nfortag in forum iOS and Apps
    Replies: 1
    Last Post: 08-17-2011, 09:03 PM
  3. Exporting Entourage contacts
    By wwoolvert in forum Switcher Hangout
    Replies: 1
    Last Post: 09-09-2010, 12:41 PM
  4. Mail- Exporting all Email addresses to Contacts
    By rightclick in forum macOS - Apps and Games
    Replies: 0
    Last Post: 08-14-2010, 01:59 PM
  5. Exporting facebook contacts
    By LelandJLK in forum macOS - Apps and Games
    Replies: 3
    Last Post: 03-30-2010, 06:02 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts