Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

rob.matthews

macrumors newbie
Original poster
Sep 15, 2009
1
0
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!
 
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.
 
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.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.