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 / January 2005

Tip: Looking for answers? Try searching our database.

Problem Importing Contacts from Excel

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
HuLop - 20 Jan 2005 19:49 GMT
I do the following: File, Import and Export, Import from another program or
file, choose Microsoft Excel, click Next, Browse to select File to import,
check Allow duplicates to be created, click Next, and the Select destination
folder:  screen comes up.  Problem is, this screen is blank!  There are no
destination folders listed, i.e. Contacts is not displayed.  Therefore I
cannot continue with the import.  Why is this screen blank?
Milly Staples [MVP - Outlook] - 23 Jan 2005 01:09 GMT
We don't know as you have not provided the version of Outlook, how these
contacts were created, whether you have custom fields, whether you mapped
your excel contacts to the correct field in Outlook, etc.

Signature

Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact.  Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.

After furious head-scratching, HuLop asked this group:

| I do the following: File, Import and Export, Import from another
| program or file, choose Microsoft Excel, click Next, Browse to select
[quoted text clipped - 3 lines]
| Contacts is not displayed.  Therefore I cannot continue with the
| import.  Why is this screen blank?
HuLop - 24 Jan 2005 19:19 GMT
Running Outlook 2003.  Contacts came from another application (Palm Desktop
to be precise) in the form of a CSV file.  I manually went into the CSV file
and deleted a few contacts, cleaned up the address information, etc. But
basically it's a simple CSV file with Last Name, First Name, Email, Phone,
Address, City, State, and Zip.  The first line of the CSV file contains the
header labels, the rest is the data.  Tried importing it as both a CSV file
and also as a regular Excel spreadsheet, but I have the same problem either
way.

> We don't know as you have not provided the version of Outlook, how these
> contacts were created, whether you have custom fields, whether you mapped
> your excel contacts to the correct field in Outlook, etc.
Milly Staples [MVP - Outlook] - 29 Jan 2005 18:50 GMT
Try this - create a few contacts in Outlook, then export them to excel as a
.csv.  Compare that spreadsheet to the one Palm created and massage the Palm
one to match Outlooks.  Then try it agian.

Signature

Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact.  Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.

After furious head-scratching, HuLop asked this group:

| Running Outlook 2003.  Contacts came from another application (Palm
| Desktop to be precise) in the form of a CSV file.  I manually went
[quoted text clipped - 15 lines]
|| the (insert latest virus name here) virus, all mail sent to my
|| personal account will be deleted without reading.

Rate this thread:






 
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.