Microsoft KB Archive/174704

From BetaArchive Wiki

Article ID: 174704

Article Last Modified on 1/20/2007


  • Microsoft Outlook 97 Standard Edition
  • Microsoft Word 97 Standard Edition

This article was previously published under Q174704


You can build Contacts for Microsoft Outlook 97 from a file of names and addresses used in Microsoft Word 97 as a mail merge data source file. This article describes how to accomplish this task.


If the Word data source file is in the form of a comma-delimited text file, it is ready for direct importing into Outlook. See the "Steps to Import a Comma Delimited File to Outlook" section later in this article.

If the data source file is in the form of a Word table, you must first convert it to a comma-delimited text file.

NOTE: There must be no embedded commas in the data.

Steps to Convert a Word Table to Comma-Delimited Text

  1. In Word, on the File menu, click Open.
  2. Select the mail merge data source file, and then click Open.
  3. On the Table menu, click Select Table.
  4. On the Table menu, click Convert Table to Text.
  5. Click Commas, and then click OK.
  6. On the File menu, click Save As.
  7. In the Save As Type list, select Text Only with Line Breaks, type a name for the file, and then change the file extension from .txt to .csv, for example, "text.csv" including the quotation marks.
  8. Click Save, and then close Word.

Steps to Import a Comma Delimited File to Outlook

  1. On the Outlook File menu click Import and Export.
  2. Select Import from Schedule Plus or another program or file and then click Next.
  3. Select Comma Separated Values (Windows) and then click Next.
  4. Type or browse to the name of the comma delimited file and then click Next.
  5. Select the Contacts folder to receive the imported records and then click Next.
  6. Select Import <file name> into the <folder name> folder, and then click Map Custom Fields.
  7. Map the fields by dragging the fields from the data source file to the appropriate Contact record fields. Note that those Contact record fields with a plus sign must be expanded to display field detail.
  8. After all fields have been mapped, Click OK and then click Finish.

Additional query words: wd97 off97

Keywords: kbexport kbhowto kbimport kbmigrate KB174704