exporting apple mail addresses to excel

Discussion in 'Mac Apps and Mac App Store' started by rob.matthews, Sep 15, 2009.

Most Liked Posts
  1. rob.matthews, Sep 15, 2009

    rob.matthews macrumors newbie

    Joined:
    Sep 15, 2009
    #1
    I use apple mail. I just got an email forwarded to me from my boss. The initial message was sent to thousands of other email addresses and I need to somehow (hopefully efficiently) place each address into its own cell in an excel sheet. What's the best way to go about doing this?

    So far I've tried simply copying and pasting but they all go into a single cell. They also have all of these "real names" associated with the addresses that I don't want to include. The list is formatted like this within apple mail.

    "Firstname Lastname" <firstlast@fake.com>

    Thanks!
     
    share
    + Quote Reply
  2. GGJstudios, Sep 15, 2009

    GGJstudios macrumors Westmere

    GGJstudios

    Joined:
    May 16, 2008
    #2
    You should edit your post and remove email addresses. You're violating the privacy of those people.
    You can explain the same thing without displaying real email addresses by doing something like this:
    "Firstname Lastname" <firstlast@fake.com>
    ​
    Copy and paste the list into Word and clean them up there first.
     
    share
    + Quote Reply
  3. devburke, Sep 15, 2009

    devburke Guest

    Joined:
    Oct 16, 2008
    #3
    I don’t know about Excel, but if you have Numbers available to you, you can just drag the contacts into there, and it will make a nice spreadsheet of them. You can then exclude the columns with data like Names and stuff. If you don’t have numbers, maybe highlighting all your contacts and exporting as a vCard, then converting to .csv with something like [URL="http://labs.brotherli.ch/vcfconvert/“]this[/URL] would work.
     
    share
    + Quote Reply
(You must log in or sign up to post here.)

Share This Page