Copying 1500 email addresses from excel into outlook express

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Hi guys,

I've got a column of 1500 email addresses in an excel spreadsheet
and I need to put these into outlook, so that I can group them
and send an email to each person, it is feedback for a music
competition they all entered and I need to get them out ASAP,
and there's a lot of other work I need to get done.

Someone mentioned a .csv file, but I don't know how to import that
into outlook... not sure how to create it yet either, I'll need
to read up on the help files.

But if anyone has any idea of how I should go about this, it would
be greatly appreciated.... if you need any more info, please reply
or send me an email.

Thanks in advance.

Michael.
 
You might get more help if you decide on outlook or outlook express. Also,
xl version should be told.
 
Mike

First have the names and email addresses in Excel in two columns.

I set up also a third column with the names duplicated so when you Import to
Outlook you have a name for the Contact and a Display Name instead of the
email address in the To: box.

File>Save As>File Type CSV(comma delimited)(*.csv)

Now open Outlook and File>Import>Export>Import from another file>Comma
Separated Values(Windows)>Next>File to Import(you can browse to your saved
*.csv file). Next you will be asked where to import them to. I bring mine to
"Contacts".

Follow the instructions and you will get a Map. Drag your names and addresses
to the appropriate spots on the Map

1. Name of Contact
2. Email address1
3. Display Name(if you have one by making the duplicate column mentioned
earlier). If not, the email address wil be displayed in the To: box.

Continue with the OK's until Outlook pulls all from the *.csv file(should take
only a few seconds).

Now they are in the Contacts folder, you can group them as you wish.

Gord Dibben XL2002
 
OMG, I did exactly what you said and it worked! I have spent hours online in microsoft online looking for how to do what you in a short note. Thank-you Gord Dibben
 
Snow

Thanks for the feedback. Always good to know what works or doesn't work.

Gord
 
Back
Top