excel help?

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

  1. rick snagwell macrumors 68040

    rick snagwell

    Joined:
    Feb 12, 2011
    Location:
    oceanside, ca
    #1
    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

    Joined:
    Jun 26, 2012
    #2
    Highlight column D and copy its contents.

    [​IMG]

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

    [​IMG]

    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