Solved

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

Posted on 2012-12-20
1
308 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

Give your grad a cloud of their own!

With up to 8TB of storage, give your favorite graduate their own personal cloud to centralize all their photos, videos and music in one safe place. They can save, sync and share all their stuff, and automatic photo backup helps free up space on their smartphone and tablet.

Question has a verified solution.

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

Outlook Free & Paid Tools
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

920 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

16 Experts available now in Live!

Get 1:1 Help Now