Importing Contacts from Excel

  • Thread starter Thread starter Ross Hardter
  • Start date Start date
R

Ross Hardter

I'm sure it's because I'm just missing something that is very obvious, but I
haven't been able to import an Excel file into Outlook correctly. I
followed the steps exactly as described in Outlook Help, but instead of
creating a contact record for each row in the small Excel test file I'm
using, placing each field into its appropriate place, it is creating a
Separate Record (with a blank contact name) for each field. Note that the
only way Import and Export would accept my fields was for me to create a
field name in Excel for each column, including both the actual field name
and all the cells in which data had been entered for that field. This is
probably where I am going wrong. I am using Excel and Outlook 2002.
 
The easiest way I have found to import information into Outlook from an
Excel document is to first do an Export of the contacts folder out of
Outlook to a .CSV file. This will give you an Excel document that already
has all of the Contact header fields created and all you have to do is add
your data with one contact on each row and then import that file back into
Outlook. I hope this is helpful.

Robert Findlay
Partner Technical Lead -- Outlook/Office Setup
Microsoft Technical Support for Platforms and Business Applications


--------------------
 
Back
Top