Hi Nino Nino Novak <[email protected]> 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 you. > 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 > > spreadsheet) Perfect! > 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 > document 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 > steps 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 -- David Love A "running mate" is a husband who dared to talk back -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
