Microsoft KB Archive/96324

{| = Excel: Creating Labels in Word for Windows Using Excel Data =
 * width="100%"|

Last reviewed: October 7, 1997

Article ID: Q96324 2.x 3.x 4.00 4.00a WINDOWS kbinterop The information in this article applies to:


 * Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a
 * Microsoft Word for Windows, versions 2.0, 2.0a

SUMMARY
In Microsoft Word versions 2.0 and 2.0a for Windows, you can use the MAILLABL.DOT template file to produce mailing labels with address data from a Microsoft Word document or a Microsoft Excel document.

MORE INFORMATION
To use the MAILLABL template with Microsoft Excel data, the version of Microsoft Word for Windows you are using must be able to read the Microsoft Excel binary interchange file format (BIFF).

Microsoft Word for Windows versions 2.0 and 2.0a can read files directly from Microsoft Excel versions 3.0 and earlier; however, if you are using Microsoft Excel version 4.0, you will need to do one of the following:

  Obtain an updated Microsoft Excel converter to use with versions 2.0 and 2.0a of Word for Windows. To obtain this updated converter, contact Microsoft Product Support Services at (425) 462-9673. -or-   Save the Microsoft Excel for Windows file in Microsoft Excel 3.0 format or in CSV format. -or-  Copy and Paste the information from Microsoft Excel into a Microsoft Word for Windows document. The data will be pasted as a table and can be used as the main document with the MAILLABL template.

Microsoft Word versions 2.0a-CD and 2.0b for Windows come with a converter for Microsoft Excel version 4.0 files. Therefore, these two versions can directly read a Microsoft Excel version 4.0 file. For step by step instructions on using the MAILLABL template, see pages 658-659 in the &quot;Microsoft Word for Windows User's Guide,&quot; version 2.0.

For more information about the MAILLABL template, query on the following words in the Microsoft Knowledge Base:

maillabl.dot and instructions and suppress For more information on using Microsoft Excel data in a Word for Windows print merge document, query on the following words in the Microsoft Knowledge Base: xlbiff.cnv and excel and data and merge