Contacts from an xls file with Name & Number

  • Thread starter Thread starter Adam
  • Start date Start date
A

Adam

Dear All,

I have a spreadsheet which contacts, in column A, a
contact name and then in column B a contact number for
them.

Is there a way I can import these into Outlook (2002 SP-
2) each as a contact?

Many Thanks,

Adam
 
Yes. You need to define the range name of your contacts
first in Excel (include the column heading names). Then
go into Outlook. Select the Contacts folder. Then
choose File, Import/Export. Choose Import from another
program or file and click Next. Scroll down and choose
Microsoft Excel. Click next. Browse for the Excel file
name. The important step in this wizard is when you get
to the Map Custom Fields step. You have to tell Outlook
which fields in your spreadsheet match the fields in
contacts. For example, if your first heading is called
Name in excel, then click and drag that over the name
field in the contacts window. Do this for each column -
example the phone number in Excel should drag to the
Business phone number in Contacts. Click finish when
you're done and they should import.
 
Back
Top