Skip navigation

How can I export only email addresses from my address book?

4997 Views 10 Replies Latest reply: Mar 16, 2014 3:28 PM by Michael Holm1 RSS
ItchNscratch Level 1 Level 1 (10 points)
Currently Being Moderated
Sep 20, 2011 11:50 AM

I need to export email addresses from a large group I have in Address book.

When I export it as a vcard it takes ALL the information (name, phone number, address, etc).

I need an email list only from this group.

iMac 1.8 GHzPowerPC G5, Mac OS X (10.4.10), 2 GB Ram, 64mbGeforceFX5200
  • rmgman Level 3 Level 3 (520 points)

    Well, one thing you could do is this, though it still takes some work:

     

    1) In Mail create a new message.

     

    2) add the group to the To: field (if you have it as a "true" group set up in your Address Book, you can just drag the whole Group there.)

     

    3. Save the email as a Draft.

     

    4. From Mail, drag the message to your desktop which will give you a .eml file.

     

    5. Open the .eml with TextEdit (or any word processing app). You'll get a bunch of other text and gobbledegook, but you will find the list of email addresses somewhere near the beginning of the file and just copy and paste them out of there.

  • Csound1 Level 7 Level 7 (32,255 points)

    From the App Store download Address Book Extractor and use it to export to a .csv file, import the .csv into Excel/Numbers/Open Office etc, delete all columns except for names and email addresses, voila, an email address list.

     

    Address Book extractor is $1.99

  • Csound1 Level 7 Level 7 (32,255 points)

    ItchNscratch wrote:

     

    I think I got it - but it is not very elegant.

    First, I save the group as a vcard to my desktop.

    Then I use this converter to save it as a cvs file.

     

    Now I open the cvs file in Excel.

    When I open it up it gives me options on how to treat the data. Since I see that the info in the cvs file is separated by colons, i do not select any of the presets, but instead use "other" and type in a colon (:).

     

    When the excel file opens, all of the e-mail addresses are in the same column, so I just copied and

    pasted that column to a new page, sorted the column in ascending

    alphabetic order (this moves all of the blank rows to the bottom),

    scanned through the list and deleted the few names that preceded the

    e-mail addresses (e.g. First Last <FirstLast@email.com>), then removed

    duplicates.

     

    I can now save this excel file back as a .cvs file or text or whatever I need.

     

    Thanks to Tony Lindsay for helping me on this - and my wife for suggesting the Excel angle.

    This method also works, I hadn't come across this converter before but it seems good, $1.99 is cheap and the extractor may be easier to use, but it's a close thing...Thanks

  • electronicpeter Calculating status...

    You dont need any additional software!

     

    - mark all contacts in your address book

    - export to a vCard

    - open a terminal window

    - go to folder with vCard (for example cd Desktop)

    - make sure, file is visible

     

      ls vCards.cvf

     

    - the type the following command:

     

       grep EMAIL vCards.vcf  | sed s/EMAIL.*://g | sort -u > a.txt

     

    - now you have a new file a.txt with all emails and nothing else

  • zpeyton Calculating status...

    Clever!

  • helloandyhihi Calculating status...

    I came across an easier solution: Paste one line into Terminal:

     

    defaults write com.apple.mail AddressesIncludeNameOnPasteboard -bool false
    

     

    After you do this, re-launch Apple mail. Then copy e-mail addresses from the To/BCC fields. When you paste you'll get the just e-mail addresses without the full names (which is perfect for pasting into other websites and applications).

     

    MacBook Pro (15-inch Late 2011), Mac OS X (10.7.3)
  • Michael Holm1 Calculating status...

    Thanks! 

    (for the Terminal thing)

     

       grep EMAIL vCards.vcf  | sed s/EMAIL.*://g | sort -u > a.txt

     

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.