Problem Importing Contacts from Excel

[Guest]

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

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]

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

 

[Guest]

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.

 

[Milly Staples [MVP - Outlook]]

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.

--
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
| 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.
|
| "Milly Staples [MVP - Outlook]" wrote:
|
|| 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]
||
|| 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.