Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Mar 2002
    Location
    San Jose, California, USA
    Posts
    82
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Importing contacts from Excel export (2007 / 2003)

    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.

  2. #2
    Star Lounger
    Join Date
    Mar 2002
    Location
    San Jose, California, USA
    Posts
    82
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Re: Importing contacts from Excel export (2007 / 2

    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!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •