contacts import doesn't populate the e-mail address field

jslaymon
jslaymon used Ask the Experts™
on
I have a file of contacts that is saved in Excel 2003. When I import them into Outlook 2010 all columns populate the respective fields except for the e-mail addresses. I moved the column that contains the addresses to a new location in the file in hopes it was a one to one import (first column to first field but that didn't work). Any ideas?....thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
In Outlook, you have to map the fields to the ones in the spreadsheet.

http://office.microsoft.com/en-us/excel-help/share-contact-data-between-excel-and-outlook-HP005198479.aspx

Look about half way down in the Import section regarding map custom fields.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial