Benches macOS

4

mac mail import from excel email list

apple Verified

Imported from the Apple Support Forums via the Wayback Machine 🔗

Using leopard on new imac. Could someone please give me some advice for importing to mac mail. I purchased 2000 email leads which was emailed to me in excel format. I can open in numbers fine and looks great. My problem is I need to import these leads to mac mailß, with email, name, address, phone, etc. and haven't found a way to do this. Can anyone help. Thanks in advance. Gary

4 replies

Sign in or join Beachball Help to reply.

  1. 0

    Austin Kinsella1

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Save it as a .csv file then in Address Book use File/Import/Text File

    User uploaded fileAK

  2. 0

    mikemcde1

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Try importing them into the address book, this is where mail gets it's email addresses from. There is an option to import a text file. Just back up the address book before you import them since this could create a problem since it's dependent on file headers. i've never tried this before so I'm going out on a whim but the help files in the address book says that it supports importing of csv and tab deliminated files. I would not use the text file if it's been saved from numbers. Use the exact file that was sent to you by the company you purchased the contacts from. Good luck!

  3. 0

    FDWifeCFD

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    I tried doing this and saved it as a cvs and then txt...when I tried to import Mail said it was in the wrong format? Help! Oh..I am using Excel 08

  4. 0

    Austin Kinsella1

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Mail does not actually store addresses; this function is done by the separate Address Book application. did you try importing to Address book?

    User uploaded fileAK