View Single Post
  #1  
Old January 18th 06, 02:11 PM posted to microsoft.public.outlook
LSChaefer33
external usenet poster
 
Posts: 3
Default import contacts from excel

I have been unsuccessful at importing my contacts from excel. I have named
the range i want to import. I select the range (one column is 317 entries
long, I have about 7 fields across for name, etc)

I enter the name in the name box to the left of the function thing. I press
enter. I have done this numerous times. When I come back and highlight the
range, it does not show the name in the name box, it shows the cell #'s.
Should it retain that name? The names appear in the drop down list,. i can
reselect it. But it does not seem to retain it.

Then when I go into outlook to import., it shows every possible name, even
ones i mistyped and corrected when first entering the name in excel.

It shows all the names in a list. I click on one and it goes immediately to
mapping. I drag it over. I can not use next or previous to get the next
name. I hit OK and return to the list. I do this for each name. It lists
all the names, even those that are not in the worksheet anh longer (ie I
fixed a typo). I only do it for the names that I know are being used
currently in the worksheet.

then when i import, it takes a long time. sometimes hangs up. If I stick
it through, it makes 65,000 new BLANK entries in my contacts.

what am i doing wrong and is there a way to delete 65,000 entries without
holding teh delete button down for an hour?

when I name the ranges, I am careful to only highlight the 316 entries, not
the entire length of the infinitie worksheet..

Thanks for any help you can give.
Ads