Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index

Hi Nino

Nino Novak <> wrote:

Am 08.08.2013 06:53, schrieb David Love:
I have been asked to design and print numbered tickets for an event
being organised by a Club to which my wife belongs.

How I'd do it (it's from memory, so bear with me for little glitches):

Thank you for the prompt reply and my apologies for the delay in replying to

1. Set up a Calc spreadsheet and enter a header (e.g."number") and the
desired numbers (1 to 150 or even 001 to 150 by chosing a custom number
format with two preceeding zeroes) into a column

Did that without problems.

2. design a nice text page with all 4 tickets in it (you could also try
going with labels but for just 4 tickts per page I'd rather go with
copy&paste instead of fumbling with labels)

O.K. Although I did have some trouble grouping all elements.

3. assign the spreadsheet from #1 as data source (for later use as
mailmerge, from memory: File > New > Database > connect to existing >


4. on your above designed ticket page, press F4 to open the spreadsheet
from above as data source

No problem.  

5. enter (simply drag&drop) column header field into the appropriate place
in stub and repeat this for the ticket

Went without a hitch.

6. after every SECOND field enter "next record" switch (Insert > field >
others > database > next record) but NOT after the fourth ticket (as a
page break always triggers a next record switch)

This is where I've gone wrong and I cannot figure out how.  As I understood
it, on the stub and ticket of tickets number 2, 3, 4, I do what you suggest
above.  Is that correct?

and then, as it will be a new page, the numbering will continue in sequence
until we reach the end of the records.  Is that correct

7. Print as mailmerge (or form letter or whatever it's called) into 1

I do this by Printing to file.  The first ticket is correct.  Tickets number
2, 3 and 4 are not numbered.  It then goes to the next page where the first
ticket is numbered 2 and the other three are not numbered.  And so it goes
on until the end of the records.  Each page is the next number.

I notice that when I have Next Record highlighted and click Insert, all that
happens is a thin grey vertical line appears where I click.  I would have
thought the words <next record> would have appeared.  Am I wrong?

8. review the document and if necessary correct&repeat some of the above

I am at a loss as to what I should do next.

9. print the merged documents,

10. enter perforation (I use a sewing machine, works perfectly if you use
a thin needle and adjust the step width appropriately)

11. cut tickets apart :-)

Enjoy learning ;-)
My enjoyment is leading to "grinding of teeth in frustration"


David Love
A "running mate" is a husband who dared to talk back

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.