Importing from excel in to Outlook03 - only one contact appears?

Question

I have an excel sheet with about 40 contacts, I follow all instructions on how to import from Outlook 03 but when I do, I only get one contact to be imported. Why is this and how do I fix it?

Answer 1

In Outlook, create a folder to receive the imports.
-sel a folder to highlight (example, contacts), cl File, cl New Folder, follow prompts.
-In Excel, select and name the range of fields to be imported.
(To do this, select your headings and data only, cl in “name of cell” box (upper left), give this range of data a name, then click “enter.”

-cl the folder you created
-cl File
-cl Import/Export
-cl from another program or file
-cl in this case, cl Excel
-cl Browse, go to the file from which you want to import (name full path) – STOP a minute -
[you will see a dialog box advising you it will import the range you named]

-click Map Custom Fields
[you will see your fields on the left, Outlook’s on the right]

-cl the + signs on Outlook’s list to display additional fields

-Now, cl-drag your fields from the left, to the matching named field on the right.
[for example, if your field is named Fname, and Outlook has Firstname, click-drag Fname over to Firstname and drop it]
-cl o.k.
-The records will read in.

Answer 2

When you are importing, did you ensure that you werent duplicating any duplicates? Make sure that you also have the file comma delimited. This file format helps out and makes sure that you are importing each row of information.