• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 231
  • 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?
0
Hubman
Asked:
Hubman
  • 2
1 Solution
 
activematxCommented:
Save the excel file as .csv

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

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

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