[Solved] Sequential Print Numbering

[SKawyer]

I have a writer doc created for invoices. In the past I've had to enter to PO number manually; example 15444 *Print*, 15445 *Print*, etc.

I'm sure there is a macro out there to automatically print the numbers in sequence without changing each individual number. Example would be I would like to start with number 15444 and print 10 copies to have 15454 be the last number. I've found Microsoft word has a program for this however it wont obviously work for OpenOffice.

[Villeroy]

Download and save the attached database document.
menu:Tools>Options... OpenOffice Base > Databases [New ...]
Point to the database document.

Open your invoice template.
Put the cursor where you want to insert the invoice number.
menu:Insert>Fields>Other... tab:Database
Choose InvoiceNo > NextNum and hit [Insert]

Now every time when you are going to print a new invoice, you get a message like this:
"Your document contains address database fields. Do you want to print a form letter?"
Anser with <Yes> (hit Enter).
The invoice numbers start with 1,000. If you want to start with another number, say 10,000:
Open the database document.
menu:Tools>SQL...

Code: Select all

ALTER SEQUENCE "SEQ" RESTART WITH 10000

Button [Execute]
Close the database.

[SKawyer]

This just prints the Inovice number as *InvoiceNo.NextNum* but no numbers. It does not ask for anything before I print besides the usual printer properties.

[Villeroy]

You are right. The mail merge field doesn't work with a database sequence like it does with database records.

[SKawyer]

How do I program it to print with the sequence numbers?

[MrProgrammer]

I have a writer doc created for invoices. … Example would be I would like to start with number 15444 and print 10 copies …

Create a new spreadsheet. Put "Invoice" in A1 and 15444 in A2. Click A2. Drag the fill handle in the lower right corner down to fill ten cells with numbers. Save the spreadsheet. Create a new database and connect it to an existing "database", your spreadsheet, as its source. Register and save the new database. Open your Writer document. Use View → Data Sources and navigate to your spreadsheet data. Near the top of the screen drag "Invoice" down into the document to create a field. Position the field where you want it in the document. File → Print → Form letter? → Yes → Records → All → OK. You might need to uncheck "Print automatically inserted blank pages", depending on your printer dialog.

Read about Mail Merge in Help → Index or in User Guides (PDF) or searching for topics about it in the forum. Create Report (Index Cards) of multiple records from excel is a somewhat similar topic with pictures.

You only need to create the spreadsheet and database once (steps in pink). You can save a bit of time if you insert the field, then save that modified document as a template (steps in green). To print different invoice numbers open the existing spreadsheet, create the numbers as desired, save it, then perform the steps in black.

start with number 15444 and print 10 copies to have 15454 be the last number

When starting with 15444 and printing ten sequentially-numbered invoices the last will be 15453, not 15454.

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[SKawyer]

Thank you, that worked.