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.
WORKAROUND
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:
- On the View menu, click Define Views.
- In the Define Views for Contacts dialog box, select one of the tabular views, such as Phone List, and then click Copy.
- In the Copy View dialog box, type a name for your new view and click OK.
- In the View Summary dialog box, and click Fields.
- 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.
- 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.
- You may position the fields in the list by selecting them and clicking the Move Up and Move Down buttons.
- When you are finished, click OK.
- Click OK in the View Summary dialog box.
- In the Views for Contacts dialog box, click Apply View.
The new column should now display the User-defined field.
To complete the processes:
- Select the set of Contacts you want to export and on the Edit menu, click Copy.
- Open Microsoft Excel and paste the contacts into a new Sheet.
- Save the Contact records in any of a number of formats available in Microsoft Excel.
Keywords: kbprb KB161295