• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 234
  • Last Modified:

Outlook 2007

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?
  • 2
1 Solution
Save the excel file as .csv

Then do the import into outlook.
HubmanAuthor Commented:
Got it
Brian GeeCommented:
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.
Brian GeeCommented:
Too slow... -___-
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now