Microsoft KB Archive/197913

= OL98: How to Import Works 4.5 Address Book into Outlook Contacts =

Article ID: 197913

Article Last Modified on 8/9/2004

-

APPLIES TO


 * Microsoft Outlook 98 Standard Edition
 * Microsoft Works 4.5 Standard Edition

-



This article was previously published under Q197913



SUMMARY
Microsoft Outlook does not provide a converter to directly import the Microsoft Works 4.5 Address Book.



MORE INFORMATION
Although Works gives you an option to export the information in CSV format, when you export a file in this format, it does not include the Field Information.

In order to import your Microsoft Works 4.5 Address Book into Outlook Contacts, use the dBASE IV format.

Export the Works Address Book

 * 1) In Works, open the Address Book, and on the File menu, click Save As.
 * 2) In the Save File As Type box, click to select dBase IV.
 * 3) Type a name for the file and click Save.

Note the location where the file is saved. The file will be saved with a dbf extension. Close Works.

Import the Address Book
In order to import the Address Book file into Outlook, first install the field mapping patch, and then import the file.

You can download the patch from the following Microsoft Web site:

http://office.microsoft.com/downloads/9798/field98.aspx

To import the Address Book file, follow these steps:  On the File menu, click Import And Export. Click to select "Import from another program or file," and then click Next. Click to select dBase, and then click Next. Browse to locate the file that you saved earlier. Click to select the file, and then click OK. Click Next. Click to select the Contacts folder where you want to import the Address book.  Click Map Custom Fields. Drag the field names from the left window to the corresponding field name on the right. Use the following table as a guide. Works Field     Outlook Field --     LAST_NAME        Last Name MIDDLE_NAM      Middle Name FIRST_NAME      First Name POSITION        Job Title 

For the Address Fields, you have to decide whether you want the data to import and show as personal addresses, business addresses, or other addresses (because Outlook has three categories of addresses, and Works does not). For each of the Address fields in Works, choose the appropriate field in Outlook.

<pre class="fixed_text">     ADDRESS1        Business, Home or Other Street ADDRESS2       Business, Home or Other Street 2 CITY           Business, Home or Other City STATE_OR_P     Business, Home or Other State POSTAL_COD     Business, Home or Other Postal Code COUNTRY        Business, Home or Other Country Some fields in Works do not have a direct correlation in Outlook. The information in these fields will not be imported. If you want to use the information from these fields in your Outlook Contacts Forms, it is recommended that you map these fields to the Additional Fields "User 1, User 2, User 3, and User 4".

After you have the fields mapped as desired, click OK, and then click Finish to import the data into Outlook.

Additional query words: 98

Keywords: kbhowto kbdownload kbexport kbimport kbmigrate KB197913

-

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

© Microsoft Corporation. All rights reserved.