Microsoft KB Archive/174704

= OL97: How to Import a Word Mail Merge Data Source File =

Article ID: 174704

Article Last Modified on 1/20/2007

-

APPLIES TO


 * Microsoft Outlook 97 Standard Edition
 * Microsoft Word 97 Standard Edition

-



This article was previously published under Q174704





SUMMARY
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.



MORE INFORMATION
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 into the 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

-

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

© Microsoft Corporation. All rights reserved.