Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / Contacts / February 2007

Tip: Looking for answers? Try searching our database.

How do you import contacts from an excel file into Outlook 2007?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
rllngriver - 22 Feb 2007 21:05 GMT
It is totally different than Outlook 2003. I dont understand what to do when
the map fields box comes up. Why do you have to drag and drop. Why can't it
just import the contact information?
Sue Mosher [MVP-Outlook] - 22 Feb 2007 23:06 GMT
Because Outlook doesn't know which column in your Excel worksheet contains the data corresponding to a specific Outlook field until you tell it by setting up the map.

Signature

Sue Mosher, Outlook MVP
  Author of Configuring Microsoft Outlook 2003
    http://www.turtleflock.com/olconfig/index.htm
  and Microsoft Outlook Programming - Jumpstart for
    Administrators, Power Users, and Developers
    http://www.outlookcode.com/jumpstart.aspx
 

> It is totally different than Outlook 2003. I dont understand what to do when
> the map fields box comes up. Why do you have to drag and drop. Why can't it
> just import the contact information?
rllngriver - 23 Feb 2007 13:27 GMT
Does this have to be set up for each name on your list? I looks like it. No
matter how many items to drag and drop, there is an arrow than you have to
click and next goes on forever. Do you have a link to help with this?

> Because Outlook doesn't know which column in your Excel worksheet contains the data corresponding to a specific Outlook field until you tell it by setting up the map.
>
> > It is totally different than Outlook 2003. I dont understand what to do when
> > the map fields box comes up. Why do you have to drag and drop. Why can't it
> > just import the contact information?
Sue Mosher [MVP-Outlook] - 23 Feb 2007 14:57 GMT
No, it's a mapping of columns to fields. Do it once and it affects all rows in the source data.

Signature

Sue Mosher, Outlook MVP
  Author of Configuring Microsoft Outlook 2003
    http://www.turtleflock.com/olconfig/index.htm
  and Microsoft Outlook Programming - Jumpstart for
    Administrators, Power Users, and Developers
    http://www.outlookcode.com/jumpstart.aspx
 

>
> Does this have to be set up for each name on your list? I looks like it. No
> matter how many items to drag and drop, there is an arrow than you have to
> click and next goes on forever. Do you have a link to help with this?
>
>> Because Outlook doesn't know which column in your Excel worksheet contains the data corresponding to a specific Outlook field until you tell it by setting up the map.

>>    
>> > It is totally different than Outlook 2003. I dont understand what to do when
>> > the map fields box comes up. Why do you have to drag and drop. Why can't it
>> > just import the contact information?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.