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 / August 2006

Tip: Looking for answers? Try searching our database.

Problems importing Excel to Outlook Contacts

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jim - 07 Aug 2006 23:10 GMT
Trying to import names and addresses from Excel 2003 file to Outlook Contacts
does not work correctly.  Prepared Excel file with exact Field Names used in
Outlook and followed HELP directions. Tried both matching field names and
mapping.  But all it does is crunch and goes 'not responding'.  List is just
simple names address list with 185 line entries.  I even shortened list to
five names with same result.

New Outlook user - Windows XP machine with 512 memory.  
Long time MS Office Professional user.
Always used Outlook Express, before.
New boss wants contacts stored in 'Contacts'.

Please help....... Jim
Judy Gleeson (MVP Outlook) - 08 Aug 2006 03:13 GMT
Do you have Outlook 2003 and Excel 2003?

Have you named the range in Excel, shut Excel and then gone to Outlook to
import using the Import wizard?

> Trying to import names and addresses from Excel 2003 file to Outlook
> Contacts
[quoted text clipped - 12 lines]
>
> Please help....... Jim
Jim - 08 Aug 2006 04:47 GMT
Both Excel and Outlook are 2003 from same CD.  I already had field names on
Line 1 of the file, but when I tried to use the import wizard it failed and
talked about ranges.  I researched setting range information.  Seen range
info on MS Outlook Help and went back to set range names using (choose range,
Insert-Name-Create).  File now gets into wizard but mapping doesn't seem to
work right.  Trying to map Name, Address, City, State, etc as directed to
Contacts.  But it tries to identify each cell one at a time to the Contacts
side.  I was assuming once I mapped Name to Name, Address to Address, etc. it
would just suck all the data in and match it up. I must have missed something
somewhere but I just don't see it.   THANKS for your help.      

> Do you have Outlook 2003 and Excel 2003?
>
[quoted text clipped - 17 lines]
> >
> > Please help....... Jim
Judy Gleeson (MVP Outlook) - 08 Aug 2006 07:09 GMT
Name the range in Excel - highlight the part you want to export and then
type a name in the window, top left.
Close Excel.

Open Outlook and now try the Import wizard.

> Both Excel and Outlook are 2003 from same CD.  I already had field names
> on
[quoted text clipped - 38 lines]
>> >
>> > Please help....... Jim
 
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



©2009 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.