Inport Excel Data into OutLook 2002

  • Thread starter Thread starter Martin
  • Start date Start date
M

Martin

Hi,
I have a data base that contains names, address and
email, on an Excel form. Is it possible to import this
data base to OutLook 2002?
Thanks.
Martin
 
Hi,
I have a data base that contains names, address and
email, on an Excel form. Is it possible to import this
data base to OutLook 2002?
Thanks.
Martin
Click to expand...

Save the Excel file as a comma delimited file and use the
import function in Outlook. If you need more detailed
instruction just post back

gls858
 
Martin

The basics........Your layout may differ, but adjust to suit.

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 Excel MVP
 
-----Original Message-----

Save the Excel file as a comma delimited file and use the
import function in Outlook. If you need more detailed
instruction just post back

gls858
Thank you.

.
Click to expand...
 
-----Original Message-----
Martin

The basics........Your layout may differ, but adjust to suit.

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.
Click to expand...

Thank you.
 
Back
Top