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 exportedcontact list that contains multiple-part address fields so it can besuccessfully imported into Microsoft Outlook 98.
When exporting data from other information management programs, you maynotice that the home or business address field is broken up into multipleparts. If you look at the field names in the header you may notice thefollowing:
ADDR1 ADDR2 ADDR3
Each field may contain a part of the street address. One field may containthe apartment number, while the next field may contain the street address.If you import the file into Outlook in this format it will create separateentries for each component of the address.
You can use Excel to consolidate the data from the separateaddress fields into one importable field. This process will create anaddress that imports correctly into Outlook.
Save Your Data in the Correct Format
Your information management software must allow you to export contactinformation in one of the following formats:
dBase or database file (.dbf) Comma Separated Value (.csv) Tab-Separated Value (.txt)
After you have exported the data into one these formats you can open it inExcel. When you open the data file in Excel you will be able to look at theheader of the data file.
Open the File in Excel and Edit the Data File Header
In Excel, on the File menu, click Open.
In the Files Of Type list, click All Files (*.*).
Locate and note the field names that contain the address information. For example:
ADDR1 ADDR2 ADDR3
Click to select a column (the location is not critical). On the Insert menu, click Columns to insert a new column. Click in the top cell of the new column and type a name that corresponds to a valid Outlook Field name. For example:
"Business Street", "Home Street", "Other Street"
Don't include the quotation marks.
For information about field names for importing into Outlook, please see the following article in the Microsoft Knowledge Base:
185361OL98: Internal Fields Used by Outlook Folders
In the new column, click to select the cell beneath the new field name. Type the following formula using the cell addresses noted in step 3
where Cell Address is the address of the cell you want to combine, for example:
The cell will now contain the combined address.
Click to select the new cell. Go to the last row of data and in the new cell column, hold down SHIFT and click in the last cell of the column. On the Edit menu, point to Fill, and click Down. This will copy the formula to the rest of the cells with the correct cell references.
For more information about copying formulas in Excel, on the Help menu click Contents and Index, type copy and double-click formulas.
For more information on field mapping for Outlook, please see the following article in the Microsoft Knowledge Base:
182728OL98: Field Mapping for Importing Not Available
On the File menu, click Save As, in the Save As Type list, click to select "Text (Tab delimited)(*txt)" or "CSV (OS/2 or MS-DOS) (*.csv)." Type a name for the file, and then click Save.
Check the header names to make sure they correspond to the correct Outlookfield name. Make any corrections needed and save the file as a text file(CSV) so it can be imported into Outlook.
For information on importing text files into Outlook, please see thefollowing article in the Microsoft Knowledge Base:
179556OL98: How to Import and Export Text Data With Outlook