Importing contacts from Excel export (2007 / 2003)

Topic

New Reply

I have just left my previous job and before I went I exported my contacts (from Outlook 2003) to an excel sheet.
I am now trying to import the contacts to my new version (2007) and all the information comes in correctly with the exception of the email address. I can see it in the excel sheet, in the column labeled “EmailAddress” but it doesn’t show up in any display view in contacts. If I open the address book query all it lists are the business fax numbers for contacts.

I have tried re-exporting the contacts from OL2007 to excel and checking the column headers. Where there was a manually entered contact with an email address, that shows up in the “EmailAddress” column as expected. I cut and pasted from the old excel sheet to this new one and tried re-importing but still no email addresses!

Any thoughts? I had to surrender the old laptop when I left so might not be able to get a .pst copy from it. Please tell me I don’t have to manually enter all 1100 addresses!

HELP.

Reply | Quote

Replies

Answering my own post here.

It’s a case of mapping the fields – even though there’s identical fields called email1, email 2 etc, they don’t automatically map on import – how dumb!!

Once I set up the mapping all is well – boy am I relieved!

Reply | Quote