Microsoft KB Archive/298748

= OL2001: Field Requirements to Import .CSV Data to Outlook 2001 =

Article ID: 298748

Article Last Modified on 8/2/2001

-

APPLIES TO


 * Microsoft Outlook 2001 for Mac

-



This article was previously published under Q298748



SUMMARY
When you import .csv data to Outlook 2001 for Mac, you may receive the following error message multiple times:

The field  is not recognized and will not be imported by Microsoft Outlook.

[Cancel] [Skip this Field]



MORE INFORMATION
This error message indicates that there are fields in the imported .csv file that do not match the internal fields that Outlook 2001 for Mac uses. The error message appears once for every field as they are encountered. If you click Skip this Field, it allows the import process to proceed and ignores any date in that field. If you click Cancel, the import process stops.

Outlook 2001 for Mac uses the fields listed in the following table to organize contact information. You may want to modify the .csv file in order to match the Outlook 2001 for Mac fields. This process is known as field mapping. You can open your .csv file in Microsoft Excel for the Macintosh and edit the header row to manually map any applicable fields.  Anniversary              E-mail 2 Type         Mobile Phone Assistant Phone         E-mail 3              Nickname Assistant's Name        E-mail 3 Type         Office Location Birthday                E-Mail Type           Other City Business City           File As               Other Country Business Country        First Name            Other Fax Business Fax            First Name Yomi       Other Phone Business Phone          Home City             Other Postal Code Business Phone 2        Home Country          Other State Business Postal Code    Home Fax              Other Street Business State          Home Phone            Pager Business Street         Home Phone 2          Primary Phone Callback                Home Postal Code      Private Car Phone               Home State            Profession Company                 Home Street           Radio Phone Company Main Phone      ISDN                  Spouse Company Yomi            Job Title             Suffix Department              Last Name             Telex Display Name            Last Name Yomi        Title E-Mail                  Manager's Name        TTY/TDD Phone E-mail 2                Middle Name           Web Page NOTE: The following fields exist for compatibility with Japanese naming conventions:

 First Name Yomi Last Name Yomi Company Yomi For example, if your .csv file has name fields designated as First, Middle and Last, you would rename them to First Name, Middle Name and Last Name in order to manually map the fields to match the Outlook 2001 for Mac internal fields.

Once you have edited your data to map the fields, resave the data, retaining the CSV format, and import the data into Outlook 2001 for Mac.

Additional Notes
The Help file for the French and German versions of Outlook 2001 for Mac is missing the following field information under Format Requirements for Importing a .csv File.

For the French Help file:


 * Type de messagerie 2
 * Type de messagerie 3

For the German Help file:
 * E-Mail-Typ 2
 * E-Mail-Typ 3

Additional query words: ol2001 apple macintosh fields missing

Keywords: kberrmsg kbinfo KB298748

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.