Excel: Creating Labels in Word for Windows Using Excel Data

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.

For step by step instructions on using the MAILLABL template, see pages 658-659 in the "Microsoft Word for Windows User's Guide," 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

   xlbiff.cnv and excel and data and merge

REFERENCES

"Microsoft Word for Windows User's Guide," version 2.0, pages 658-665