Sequentially Numbering Merged Records from Any Starting Number

Last reviewed: July 30, 1997
Article ID: Q83341
The information in this article applies to:
  • Microsoft Word for Windows, versions 1.0, 1.1, 1.1a, 2.0, 2.0a, 2.0a-CD, 2.0b, 2.0c, 6.0, 6.0a, 6.0c

SUMMARY

In Microsoft Word for Windows, you can sequentially number merged documents. For example, if you are merging invoices, you can insert the invoice number on each merged record, and have Word increment the invoice number by one for each merged record.

MORE INFORMATION

To set the starting number for the sequential numbering, insert a SUM field. For example, to merge invoices that are numbered beginning with 100, insert the following field where you want the invoice number to appear:

   {=SUM(99,{MERGEREC})}

Note: To insert the field braces, press CTRL+F9.

The MERGEREC field returns the number of the record being merged. When the number of the first record, 1, is added to 99, the field returns a value of 100. In this example, 99 is the RESULT of the desired invoice number, 100, minus 1. Change 99 to the desired invoice number minus 1 to begin your invoice numbering at a different number. For example, to start numbering at 200, change 99 to 199.

For more information on fields, search for "Field Types and Instructions" using the Help menu in Word for Windows version 2.0.

Reference(s):

"Microsoft Word for Windows User's Guide," version 2.0, pages 309, 646, 650, 652

"Microsoft Word for Windows User's Reference," version 1.x, pages 96, 102, 107


KBCategory: kbusage
KBSubcategory: kbfield kbmerge
Additional query words: calculate numeric unique number mail merge
mailmerge winword numerical sequence 1.0 1.0 1.1 1.10 1.0a 1.0a 2.0 2.0a
winword2 2.0a mail label winword


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: July 30, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.