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,MERGERECskips 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,MERGESEQalways 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:
- Place your cursor where the sequential number should appear (e.g., after Serial Number: ).
- Press Ctrl + F9 (or Cmd + F9 on macOS) to create special field code braces:
{ } - Inside the braces, type:
{ MERGESEQ } - 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):
Formats{ MERGESEQ \# "0000" }1as0001and42as0042. - Prefixed Serial Codes:
Formats the number as{ MERGESEQ \# "'INV-2026-'0000" }INV-2026-0001. - Formatted with Commas:
Ensures large merge batches (e.g., 10,000+ items) display thousand-separators cleanly.{ MERGESEQ \# "#,##0" }
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:
- Navigate to the Mailings tab on the Ribbon.
- Click Preview Results.
- Use the Next Record arrow to advance through recipients. Notice that while
MERGESEQstarts at 1 and increments by 1 on every record,MERGERECdisplays the exact source row index. - Click Finish & Merge and select Edit Individual Documents to produce the final, sequentially numbered output file ready for distribution.