WD: How to Merge Envelopes and Labels If Records in One Column

Last reviewed: February 3, 1998
Article ID: Q140343
The information in this article applies to:
  • Microsoft Word for Windows, versions 6.0, 6.0a, 6.0c
  • Microsoft Word for the Macintosh, versions 6.0, 6.0.1, 6.0.1a
  • Microsoft Word for Windows NT, version 6.0
  • Microsoft Word for Windows 95, versions 7.0, 7.0a
  • Microsoft Word 97 for Windows
  • Microsoft Word 98 Macintosh Edition

SUMMARY

Ordinarily, Word cannot merge with data when all the information is in one column, as in the following example:

   John Doe
   123 Main Street
   Anytown, US  12345

   Jane Smith
   Microsoft
   456 Elm Street
   Sometown, US  67890

Word needs the information to be laid out in a table or in tab- delimited format. Normally, to perform a mail merge, you would have to first convert the text to a table to use as a data document. To convert the text, you need to have the same number of fields in each record. This becomes increasingly more difficult to accomplish with a large number of records.

This article provides simpler methods for use with envelopes and labels.

Note that these methods are useful only when you have an existing document that is laid out in one column and you don't need to merge the information in the future. Using a data document that is laid out in a table provides many more options for merging data, such as the ability to use one data document for merging to different types of documents.

For information on converting address information into the table or tab-delimited format that Word needs, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q140344
   TITLE     : WD: How to Convert Data in One Column to a Table for Merging

MORE INFORMATION

Method 1: For Both Envelopes and Labels

  1. Open the data document and make sure there is no information in the document other than the records and that the records are in the first format shown in the "Summary" section of this article.

  2. At the beginning of the records, add a line that says "MergeRecords" (without the quotation marks).

  3. Press ENTER twice so that there is a blank line between "MergeRecords" and the first record, for example:

    MergeRecords

    John Doe 123 Main Street Anytown, US 12345

    Jane Smith Microsoft 456 Elm Street Sometown, US 67890

  4. On the Edit menu, click Replace.

    a. Place the insertion point in the Find What box. Click Special and choose Paragraph Mark.

    b. Repeat the previous step so that "^p^p" (without the quotation marks) appears in the Find What box.

    c. In the Replace With box, type an asterisk (*).

    d. Click Replace All.

    e. Click OK.

    f. Click Close.

    Your document should now look like the following:

    MergeRecords*John Doe 123 Main Street Anytown, US 12345*Jane Smith Microsoft 456 Elm Street Sometown, US 67890

  5. On the File menu, click Save As. Give the file a new name. Click OK.

  6. On the File menu, click New to create a new, blank document. Click OK.

  7. On the Tools menu, click Mail Merge.

  8. In the Mail Merge Helper dialog box, click Create. Click either Envelopes or Mailing Labels.

  9. Click Active Window.

  10. Click Get Data. Select Open Data Source.

  11. Select the data document that you saved in step 5. Click Open.

  12. In the Field Delimiter box, select (none).

  13. In the Record Delimiter box, select asterisk (*). Click OK.

  14. Click Set Up Main Document.

    If you are setting up Labels, make the appropriate selections in the Label Options dialog box that appears. Click OK.

  15. Click Insert Merge Field. Only one field, MergeRecords, is available. Select this field. It appears in the Sample Label box.

  16. Click OK.

  17. Click Merge.

  18. In the Merge To box, choose New Document or Printer. Click Merge.

The document should merge successfully.

Method 2: For Envelopes Only

In this method, you do not actually perform any merging. Instead, you reformat the document so that each address is on an envelope-sized page by itself.

  1. On the File menu, click Save As. Give the file a new name. Click OK.

  2. Open the data document and make sure there is no information in the document other than the records and that the records are in the first format shown in the Summary section of this article.

  3. On the Edit menu, click Replace.

    a. Place the insertion point in the Find What box. Click the Special button and choose Paragraph Mark.

    b. Repeat the previous step so that "^p^p" (without the quotation marks) appears in the Find What box.

    c. Move the insertion point into the Replace With box. Click Special and choose Manual Page Break.

    d. Click Replace All.

    e. Click OK.

    f. Click Close.

  4. On the File menu, click Page Setup.

  5. Click the Paper Size tab.

  6. In the Paper Size list, select Envelope # 10.

  7. In the Orientation area, select Landscape.

  8. Click the Margins tab.

  9. Change the Margins to the following measurements:

        Top:   2.5
        Bottom: .5
        Left:  4.0
        Right:  .5
    
    

  10. Click OK. Each record is now on its own envelope.

  11. Click Print.

The envelopes should print successfully.


Additional query words: mmh merging print merge howto label
Keywords : kbenvelope kbmerge macword ntword winword word6 word7 word8 word95 word97 wordnt macword98
Version : WINDOWS:6.0,6.0a,6.0c,7.0,7.0a,97; MACINTOSH:6.0,6.0.1,98
Platform : MACINTOSH Win95 WINDOWS winnt
Issue type : kbhowto


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 3, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.