Hi KMS: I have had the same problem and although I don't know the version of
your Outlook, I'm thinking that I can give you a hint that might work. So if
this doesn't meet your needs then maybe you can give a bit more infomation
and some one else can help you. Here's how I did it! - (Im starting at the
beginning)
1. Open the Excel file that you want to bring (import) into the OutLook
Contact file. Select the range of cells, “which Means to highlight all the
cells in Excel that have information in them that you want to import into
your outlook fileâ€. Do include cells that are header cells (like the titles
of the columns) because outlook figures that you have headers and if you
don’t you will not have the top row imported.
2. Click the Name box at the left end of the "formula bar" (formula bar = A
bar at the top left of the Excel window.) {Or select Insert/Name/Define and
type a name for the range.}
(The Name Box drops down and don’t worry where the name will go, it ends up
in the box… you just type the name (with no spaces) like, clients).
3. Then don’t forget to Press ENTER
4. Save the spreadsheet and close the file - Else you'll get another error -
, then go to OutLook, click on your contact folder, and add a new folder
called Clients list. Click on the folder so it’s selected This is where you
were missing something in your steps that you took.
5. Then go up to the menu bar and select “File\Import and Export.
6. A dialog box opens and you follow instructions.
a. Select the file that you have the client’s names and information when
asked. Also click on “don’t import duplicate namesâ€
b. Your destination folder is already selected cause you did that in #4 above.
7. First time - In the “Import a file†dialog box put a check into the
square next to the name of the file. When you do, the box changes into a
“mapping†of the categories that you have in your Excel file.
8. So you have to drag over from the left to the right area each cell title
so the transfer can be made. You must open each area on the right map like
HOME or BUSINESS to fill in each field like home phone or zip etc.
9. When you have mapped out the fields, then "Finish" by click
OK and Finish and the transfer should work. So now you know. . . (I hope )
