Microsoft KB Archive/161295

= OL97: Cannot Import or Export User-defined Contact Fields =

Article ID: 161295

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Outlook 97 Standard Edition

-



This article was previously published under Q161295



SYMPTOMS
In Microsoft Outlook 97, you cannot import or export user-defined fields for Contacts from or into other file formats using the standard File menu Import and Export procedures.

NOTE: This is true of user-defined fields in all Outlook items, not just Contacts.



CAUSE
User-defined fields do not appear in the Map Custom Fields dialog box.



Importing User-defined Fields
You can import data into four general Outlook fields called User Field 1, User Field 2, User Field 3, and User Field 4. These fields are available in a Contact record on the All Fields tab under Miscellaneous fields.

For information on programmatically importing user-defined fields, please see the following article in the Microsoft Knowledge Base:

170320 OL97: How to Programmatically Import Outlook Items from Access

Exporting User-defined Fields
To export user-defined fields from your Contacts, define a Table view of the Contacts containing the user-defined fields. Then copy the contacts from Outlook and paste them into Microsoft Excel where you can save them in a variety of formats.



MORE INFORMATION
To define a Table view of your Contacts folder containing the user-defined fields you want to export, follow these steps:
 * 1) On the View menu, click Define Views.
 * 2) In the Define Views for Contacts dialog box, select one of the tabular views, such as Phone List, and then click Copy.
 * 3) In the Copy View dialog box, type a name for your new view and click OK.
 * 4) In the View Summary dialog box, and click Fields.
 * 5) In the Show Fields dialog box, select the field source from the "Select available fields from" list. This may be either "User-defined fields in folder" or a form containing the user-defined fields.
 * 6) Select the user-defined fields from the "Available fields" box and click Add to move the fields to the "Show these fields in this order" box.
 * 7) You may position the fields in the list by selecting them and clicking the Move Up and Move Down buttons.
 * 8) When you are finished, click OK.
 * 9) Click OK in the View Summary dialog box.
 * 10) In the Views for Contacts dialog box, click Apply View.

The new column should now display the User-defined field.

To complete the processes:
 * 1) Select the set of Contacts you want to export and on the Edit menu, click Copy.
 * 2) Open Microsoft Excel and paste the contacts into a new Sheet.
 * 3) Save the Contact records in any of a number of formats available in Microsoft Excel.

Keywords: kbprb KB161295

-

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

© Microsoft Corporation. All rights reserved.