How to Number Merged Documents Sequentially in Microsoft Word Using MERGESEQ and MERGEREC Fields

When producing large-scale mailings, personalized event tickets, invoice statements, membership certificates, or registration badges using Mail Merge in Microsoft Word, numbering each output document sequentially is a fundamental requirement. However, relying on row numbers from an underlying Excel spreadsheet often creates gaps in serial numbering whenever recipients are filtered, sorted, or conditionally skipped during the merge process. To ensure unbroken, continuous sequence numbers while retaining visibility into source database row positions, Microsoft Word provides the MERGESEQ and MERGEREC dynamic field codes.

Understanding the Difference: MERGESEQ vs MERGEREC

Word differentiates between source data row positions and the final generated output sequence:

  • { MERGEREC } (Merge Record Number): Represents the physical record number (row position) of the recipient in the underlying data source (e.g., Row 45 in an Excel spreadsheet). If you filter your list to exclude certain rows, MERGEREC skips those numbers (e.g., printing 1, 2, 5, 8, 14…).
  • { MERGESEQ } (Merge Sequence Number): Represents the sequential order number of the successfully merged document in the current active merge batch. Regardless of which rows were skipped or filtered out, MERGESEQ always numbers output documents consecutively: 1, 2, 3, 4, 5…

Common Use Cases for MERGESEQ and MERGEREC

Depending on your document\u2019s purpose, you will choose one or both fields:

  • Sequential Invoicing and Tickets: Use { MERGESEQ } to generate unbroken sequential serial numbers (e.g., Ticket #001, Ticket #002, Ticket #003) so that missing spreadsheet rows do not create missing serial numbers.
  • Audit and Cross-Referencing: Use { MERGEREC } in a footer or internal tracking block to allow administrators to trace the printed letter back to the exact row in the master data spreadsheet.

Inserting MERGESEQ and MERGEREC Using Keyboard Shortcuts

While standard database columns are inserted using the Insert Merge Field button on the Ribbon, internal merge control fields like MERGESEQ are best placed using field code shortcuts:

  1. Place your cursor where the sequential number should appear (e.g., after Serial Number: ).
  2. Press Ctrl + F9 (or Cmd + F9 on macOS) to create special field code braces:
    { }
  3. Inside the braces, type:
    { MERGESEQ }
  4. Press F9 to evaluate and update the field.

To insert the source record row number in the document footer for audit tracking:

{ MERGEREC }

Press Alt + F9 to toggle between the rendered numbers and the underlying field code text across the entire document.

Formatting Serial Numbers with Numeric Picture Switches

By default, MERGESEQ prints raw unpadded numbers (1, 2, 3…). For professional tickets, invoices, and certificates, you typically require leading zeros or prefix strings:

  • Fixed-Width Padded Numbers (e.g., 0001, 0002):
    { MERGESEQ \# "0000" }
    Formats 1 as 0001 and 42 as 0042.
  • Prefixed Serial Codes:
    { MERGESEQ \# "'INV-2026-'0000" }
    Formats the number as INV-2026-0001.
  • Formatted with Commas:
    { MERGESEQ \# "#,##0" }
    Ensures large merge batches (e.g., 10,000+ items) display thousand-separators cleanly.

Combining MERGESEQ with Conditional IF Rules

You can nest MERGESEQ inside an IF field to apply distinct formatting or disclaimers based on batch size:

{ IF { MERGESEQ } <= 100 "Early Bird Priority Pass: #{ MERGESEQ \# "000" }" "Standard Pass: #{ MERGESEQ \# "000" }" }

When evaluated during the merge pass, the first 100 printed records receive the “Early Bird” prefix, while subsequent records receive “Standard Pass”, all while maintaining continuous numbering.

Previewing and Finalizing the Numbered Merge

To verify that sequential numbering increments accurately across records:

  1. Navigate to the Mailings tab on the Ribbon.
  2. Click Preview Results.
  3. Use the Next Record arrow to advance through recipients. Notice that while MERGESEQ starts at 1 and increments by 1 on every record, MERGEREC displays the exact source row index.
  4. Click Finish & Merge and select Edit Individual Documents to produce the final, sequentially numbered output file ready for distribution.

Get the best tech tips delivered straight to your inbox.

Join thousands of readers mastering Apple, Google, Microsoft, and Linux.