Article ID: 185418 - View products that this article applies to.
This article was previously published under Q185418
This article has been archived. It is offered "as is" and will no longer be updated.
After importing to or exporting from a foreign file format into Microsoft Outlook 98, you may find that some items are missing. Initial attempts to perform this operation may be successful, but the results may be inconsistent on later attempts.
This condition exists because the binary mapping file for the file type contains incomplete information about the fields to be imported and exported.
Remove the current mapping file for the data type and method for which you are trying to import or export. Export a sample file in order to create a new mapping file containing all the necessary fields to allow a complete import to Outlook.
Mapping files for the various Outlook items are located in the Windows folder. A list of the mapping file extensions for each Outlook item follows:
Outlook creates the mapping file for each file type on the first import or export attempt. The fields defined at this time are stored in the mapping file. Outlook uses this file as a filter for each subsequent operation.
For example, assume you have a Microsoft Excel file that contains only the fields, First Name, Middle Name, and Last Name. If you import this information into Outlook Contacts, the resulting .adr file maps only this information. Subsequent Excel file imports containing additional fields such as, Business Address, Categories, and Fax Numbers, may not filter properly through the .adr file, resulting in missing data.
The same situation applies to Comma Separated (csv) and Tab Delimited (tsv) text files. Outlook creates a separate .adr file for each file type at the time of the first import or export.
How to Optimize Outlook Field MappingThese steps use Outlook Contacts and the .adr as the example. To create mapping files that will successfully map all imported fields into Outlook, follow these steps:
Again, for clarity, the Outlook Contacts folder is used in the examples above. The same method would be used when importing information from the other Outlook folders. The method applies for other file types as mentioned above; a separate mapping file will be created for each file type.
For more information on field mapping in Outlook, please see the following article(s) in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/180315/EN-US/ )OL98: Importing from Microsoft Excel Requires Named Range
182728For more information on Outlook internal fields, please see the following article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/182728/EN-US/ )OL98: Field Mapping for Importing Not Available
(http://support.microsoft.com/kb/185361/EN-US/ )OL98: Internal Fields Used by Outlook Folders
Article ID: 185418 - Last Review: October 8, 2013 - Revision: 1.0