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

rick snagwell

macrumors 68040
Original poster
Feb 12, 2011
3,749
102
alta loma, ca
so we need to grab all the emails in 'd' column and make them into a email list in mac mail client.

does anyone know an good way to complete this task?

thanks for any feedback!
 
Highlight column D and copy its contents.

gNfEVEH.png


Open up Mail -> new message -> paste (cmd-v).

H9456Hk.png


This will work for one time use. To create a mailing/distribution list for later use, you will have to create a new group in Contacts/Address Book and bring the addresses over one at a time - or use Automator to create a script that does it for you.

Another option would be to save a blank email (after you paste the addresses in the To/Cc/Bcc field) as a draft and use that as a template each time you need to send out an email to these people. Tedious, but OS X's native mail client isn't very good.
 
Last edited:
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.