excel help?

Discussion in 'Windows, Linux & Others on the Mac' started by rick snagwell, Jun 30, 2013.

  1. rick snagwell macrumors 68040

    rick snagwell

    Feb 12, 2011
    oceanside, 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!
  2. Stooby Mcdoobie, Jun 30, 2013
    Last edited: Jun 30, 2013

    Stooby Mcdoobie macrumors 6502a

    Stooby Mcdoobie

    Jun 26, 2012
    Highlight column D and copy its contents.


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


    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.

Share This Page