Solved

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

Posted on 2012-12-20
1
312 Views
Last Modified: 2012-12-27
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
0
Comment
Question by:jslaymon
1 Comment
 
LVL 18

Accepted Solution

by:
Jerry Miller earned 500 total points
ID: 38711297
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.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What does UTC stand for?  “Coordinated Universal Time” – Think of this as the true time on Planet Earth that never changes with the exception of minor leap seconds here and there to account for the changes in the planet's rotation.   What does th…
Find out what you should include to make the best professional email signature for your organization.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
CodeTwo Sync for iCloud (http://www.codetwo.com/sync-for-icloud?sts=6554) automatically synchronizes your Outlook 2016, 2013, 2010 or 2007 folders with iCloud folders available via iCloud Control Panel. This lets you automatically sync them with…

820 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