Email addresses not "visible" after import into MS Echange / Outlook 2003 Contacts list

Posted on 2007-10-12
Last Modified: 2010-03-06
I have Windows SBS 2003 running Exhange 2003 SP2 with Outlook 2003 clients on Windows XP. I'm trying to create an address book with over 1000 contacts, to share with my co-workers. I added one contact manually via Outlook, and then exported the data to an Excel file to have a look at the file structure. I replicated that structure in an Access database, populated it with all the address info, and then imported it back again via Outlook.

All the information show up nicely on the contacts cards (in all of the views), except the email address-related stuff. As far as I can tell, these should be:

- EmailAddress
- EmailType
- EmailDisplayName

Any ideas why this doesn't work? Much obliged...
Question by:cfcees
    LVL 1

    Expert Comment

    Have you tried eliminating the Access step and using Excel only for the process?  Outlook will natively import from Excel as well.  Just a thought.

    Author Comment

    Thx Modern Age. I used Access to do some data cleaning, like searching and replacing within certain columns only. I also find it more usefull when sorting.

    I have already found the answer, though. For some strange reason, Outlook maps all of the fields "automagically" EXCEPT the mail-related ones. When I used the import wizard again, this time checking and manually adding the mail-mapping, everything worked fine.

    LVL 1

    Expert Comment

    by:ModernAge'd think it would be smart enough to know what an email address is...lmao.

    Author Comment

    Hello Venabili,
    As you can see from my comment on ModernAge's initial response, I answered the question myself.
    LVL 20

    Expert Comment

    And that is what the recommendation says: Save the question in the database and return the points to the Asker
    LVL 1

    Accepted Solution

    PAQed with points refunded (125)

    EE Admin

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    Suggested Solutions

    Easy CSR creation in Exchange 2007,2010 and 2013
    ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
    The video tutorial explains the basics of the Exchange server Database Availability groups. The components of this video include: 1. Automatic Failover 2. Failover Clustering 3. Active Manager
    This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now