In Excel how do you add the zip code in where the person's name is

"Sue Mosher [MVP-Outlook]" wrote:

There is a Map Custom Fields button on the screen that appears after you select the destination folder.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"phd" wrote in message news
I receive the same error message and have tried everything "old geezer" says.
Further I don't see where I can choose to custom map the fields while using
the import data wizard.

"MasqueradeKaraoke" wrote:

I have tried all of these steps, and I am receiving an error from the ODBC
Excel Driver: Too many fields defined.

Any help with this is appreciated.

"kms" wrote:

What you suggested worked on my computer at the office where I'm using Office
2000 but it didn't work at home when I use Office 2003.

"Old Geezer" wrote:

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 )


"kms" wrote:

When using the Import Wizard and importing from Excel no folders appear in
the Destination Folder so I cannot select a folder and continue. How do I
select the destination folder when there are none listed