A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook - Using Contacts
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Tags: , , , , ,

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





 
 
Thread Tools Display Modes
  #1  
Old February 22nd 07, 09:05 PM posted to microsoft.public.outlook.contacts
rllngriver
external usenet poster
 
Posts: 13
Default How do you import contacts from an excel file into Outlook 2007?

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?
Ads
  #2  
Old February 22nd 07, 11:06 PM posted to microsoft.public.outlook.contacts
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,315
Default How do you import contacts from an excel file into Outlook 2007?

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.

--
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

"rllngriver" wrote in message ...
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?

  #3  
Old February 23rd 07, 01:27 PM posted to microsoft.public.outlook.contacts
rllngriver
external usenet poster
 
Posts: 13
Default How do you import contacts from an excel file into Outlook 200


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?
"Sue Mosher [MVP-Outlook]" wrote:

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.

--
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

"rllngriver" wrote in message ...
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?


  #4  
Old February 23rd 07, 02:57 PM posted to microsoft.public.outlook.contacts
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,315
Default How do you import contacts from an excel file into Outlook 200

No, it's a mapping of columns to fields. Do it once and it affects all rows in the source data.

--
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

"rllngriver" wrote in message ...

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?
"Sue Mosher [MVP-Outlook]" wrote:

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.



"rllngriver" wrote in message ...
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?


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I setup an excel file to import into outlook contacts redletters2 Outlook - Using Contacts 1 August 31st 06 12:52 PM
Import excel file to Outlook Contacts Hamster Outlook - Using Contacts 1 August 19th 06 10:04 AM
How do I import an excel file into Outlook Calendar? Friarrico Outlook - Calandaring 1 June 21st 06 05:05 PM
import excel file into outlook contacts crossroads Outlook - Using Contacts 1 May 9th 06 10:27 PM
excel file type missing from import a file window in outlook xanadufl Outlook - Using Contacts 9 February 28th 06 09:55 AM


All times are GMT +1. The time now is 04:47 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2008 Outlook Banter, part of the NewsgroupBanter project.
The comments are property of their posters.
Loans - Refinance - Credit Cards - Mortgage - Xbox Mod Chip