Article ID: 189121 - View products that this article applies to.
This article was previously published under Q189121
This article has been archived. It is offered "as is" and will no longer be updated.
This article describes how to use Microsoft Excel to modify an exported contact list that contains multiple-part address fields so it can be successfully imported into Microsoft Outlook 98.
When exporting data from other information management programs, you may notice that the home or business address field is broken up into multiple parts. If you look at the field names in the header you may notice the following:
Each field may contain a part of the street address. One field may contain the apartment number, while the next field may contain the street address. If you import the file into Outlook in this format it will create separate entries for each component of the address.
ADDR1 ADDR2 ADDR3
You can use Excel to consolidate the data from the separate address fields into one importable field. This process will create an address that imports correctly into Outlook.
Save Your Data in the Correct FormatYour information management software must allow you to export contact information in one of the following formats:
After you have exported the data into one these formats you can open it in Excel. When you open the data file in Excel you will be able to look at the header of the data file.
dBase or database file (.dbf) Comma Separated Value (.csv) Tab-Separated Value (.txt)
Open the File in Excel and Edit the Data File Header
For information on importing text files into Outlook, please see the following article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/179556/EN-US/ )OL98: How to Import and Export Text Data With Outlook
Article ID: 189121 - Last Review: October 9, 2013 - Revision: 1.0
Contact us for more help