Hi :) How i would do it. 1. Go to an office supplies shop or even a small newsagents 2. Buy a book of raffle tickets for something like 50p or maybe a £5er these days
Job done. Regards from Tom :) >________________________________ > From: Nino Novak <[email protected]> >To: "[email protected]" <[email protected]> >Sent: Thursday, 8 August 2013, 10:14 >Subject: [libreoffice-users] Re: Sequentially numberted tickets... > > >Hi David, > >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): > >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 > >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) > >3. assign the spreadsheet from #1 as data source (for later use as >mailmerge, from memory: File > New > Database > connect to existing > >spreadsheet) > >4. on your above designed ticket page, press F4 to open the spreadsheet >from above as data source > >5. enter (simply drag&drop) column header field into the appropriate >place in stub and repeat this for the ticket > >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) > >7. Print as mailmerge (or form letter or whatever it's called) into 1 >document > >8. review the document and if necessary correct&repeat some of the above >steps > >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 ;-) > >Nino > >-- >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 > > > -- 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
