OL98: Text After First Comma Lost Exporting to Text File (180808)


The information in this article applies to:

  • Microsoft Outlook 98
This article was previously published under Q180808

SYMPTOMS

If you export Contact information to a tab, or comma-delimited text file, some of your information may not export. Contact information that is not on the General page of the Contact form may not export properly if you include a comma in the field information. For example, typing names in the Contact "Children" field and separating each name with a comma exports only the first name. All names after the comma are lost when exporting.

RESOLUTION

If you enter multiple names in the "Children" field for example, use a single space between each name in the field.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Open one of your contacts.
  2. In the Categories box, type one, two, three.
  3. Click the All Fields tab.
  4. In the Select from list, click to select All Contact fields.
  5. In the Value column of the Children field, type John, Mary, Joe.
  6. Click Save And Close to close the contact form.
  7. On the File menu, click Import and Export.
  8. In the "Choose an action to perform" list, click "Export to a file" and click Next.
  9. In the "Create a file of type" list, click to select one of the Tab Separated Values or Comma Separated Values choices and click Next.
  10. In the "Select folder to export from" click to select the Contacts folder and click Next.
  11. In "Save exported file as", type c:\test.txt and click Next and then Finish.
Once the export finishes, open the file, c:\test.txt, in Notepad. Under your contact, the categories (one, two, and three) all appear, but the only name for the contact is the first name (John); Mary and Joe did not export.
Modification Type:MajorLast Reviewed:1/11/2000
Keywords:kbprb KB180808
©2002 Microsoft Corporation. All rights reserved.