Outlook 2007

Posted on 2011-04-22
Last Modified: 2012-05-11
Trying to import a list of email addresses from an excel 2003 file in to Outlook 2007 but i just get blank contacts. The excel file has only email addresses in A1 - A100
How do I make this work?
Question by:Hubman
    LVL 9

    Accepted Solution

    Save the excel file as .csv

    Then do the import into outlook.
    LVL 1

    Author Comment

    Got it
    LVL 23

    Expert Comment

    by:Brian Gee
    File > Import and Export > Import from another program or file > Next > Microsoft Excel > Next > Browse button > locate and select file > OK > Next > select Contacts folder as the destination folder > Map Custom Fields.

    This one is where you need to click the Map Custom Fields button to ensure that all the mapping are occurring correctly. Select the field from the Excel document and drag that field into the right-side to the E-mail Address field (you'll need to expand E-mail to see the E-mail Address field). Once you do that, you'll have mapping that when you press OK (to exit the mapping) and then Finish, the fields will be mapped from the Excel columns into the proper areas in Outlook's Contacts.

    Do the above mappings for any other fields that require it, like First Name, Last Name, Phone Number, etc.
    LVL 23

    Expert Comment

    by:Brian Gee
    Too slow... -___-

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Set up iPhone and iPad email signatures to always send in high-quality HTML with this step-by step guide.
    "Migrate" an SMTP relay receive connector to a new server using info from an old server.
    To show how to create a transport rule in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Mail Flow >> Rules tab.:  To cr…
    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 …

    759 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

    9 Experts available now in Live!

    Get 1:1 Help Now