How do you auto-number a raffle ticket

English
,
#1

I’m very new using Libre, so I asking for help in learning. I started helping a volunteer organization and they have LibreOffice on their laptop. I’ve done the mail merge in Office with Excel and Word to create event tickets for them. But I would love to teach them so they have the ability in the future to do it.

The process in MS Word was to create you event tickets, 8 per sheet and in Excel, the first row was to identify each ticket by a number. I used “Ticket 1 thru Ticket 8” Then I followed the mail merge wizard. Which I linked Ticket 1 to the area I wanted the serial number to be. it worked great.

When I tried the same in Libre, I can get as far as trying to coping the Ticket 1 where I want the serial number but it wont copy the link to the ticket. I’ve tried the mailing option and have linked “FirstName” as “Ticket 1” and so on, without any success.

I hope this helps.

#2

Please edit your question to provide more details. Reopen it (if timeout has not elapsed): click on … below it, then on the “pencil” icon to enter Edit mode (apparently you know how to do it).

Tell us how you proceed in M$ Office. The same procedure may eventually be transposed.

Otherwise, in Writer, I am thinking of using either list numbering (if feasible: the number must be at head of a paragraph) or of inserting the value of a Number range (i.e. a counter). When the number is needed unchanged several times, it is inserted through a cross-reference.

Under MailMerge, you can create the set of numbers in Calc and mail-merge them in Writer.

Mention OS name, exact LO version and save format (stability and reliability are only guaranteed in native format .odt and .ods).

#3

File>New>Database…
Connect to existing DB of type “Spreadsheet”
Specify the spreadsheet document
Yes, register the database.
Save, close and forget the database document for now. But make sure that it won’t be deleted.

Now you have a pseudo-database which shows spreadsheet data as if they where stored in a database.

Open your Writer document.
Get the data source window (Ctrl+Shift+F4).
Select the table in the left pane, drag column headers from the right pane into the Writer document. This generates the right mail merge fields.

When printing:
Confirm that you are going to print a serial letter.
In the upcoming dialog, specify the output medium (printer or file). You may also sort and filter the database records.

If you were using a true database instead of a spreadsheet, auto-numbered records would be a matter of course.

#4

Thank you for replying. I have done what you suggested and everything works great, except one thing. When I drag the “Ticket 1” to its location on the Writer document, it doesn’t copy. When I start to drag it, it shows a red O with a re line through it. I’m guessing here that dragging it to a text box, the system doesn’t like? I’m sure that I’m missing a step, do you any idea what I’m missing or doing wrong? You help is very much appreciated.

#5

Probably it does.
Try it with labels File → New → Labels

Label_2x4_A4.odt (8,8 KB)

#6

… and use the registered database you already have.

1 Like

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.