Ask Your Question

How to print serial numbers (auto-incrementing values) on text documents? [closed]

asked 2015-09-22 07:37:24 +0200

Mountain gravatar image

updated 2015-09-24 22:50:08 +0200

I want to print 500 copies of a document and I want to serial number each individual printed page.

The document itself will not be edited. I need an automatic way to change each printed copy. The serial numbers will still start with number 1000 and end with 1499 in this example. The serial number needs to be printed in the header.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-01 14:08:19.487319

1 Answer

Sort by » oldest newest most voted

answered 2015-09-22 11:54:34 +0200

pierre-yves samyn gravatar image


You can use the Mail Merge technique:

  • Create a spreadsheet including the numbers from 1000 to 1499:
    • File New Spreadsheet
    • Type e.g. SN in A1 (field title)
    • Click in the Name Box (left of formula bar), type A2:A501 Enter to select the range
    • Edit Fill Series: Start Value 1000, End Value 1499, Ok
  • Define this spreadsheet as source of mailing in your writer document: Edit Exchange Database
  • Insert the SN field in the header
    • Drag & drop from the Data Sources view or
    • Insert Fields More Fields, Database tab
  • Launch mailing.


edit flag offensive delete link more


Thank you so much, I just passed my interview !!

dales gravatar imagedales ( 2018-09-28 13:05:25 +0200 )edit

Question Tools

1 follower


Asked: 2015-09-22 07:37:24 +0200

Seen: 46,443 times

Last updated: Sep 24 '15