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


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: users+unsubscribe@global.libreoffice.org
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

Context


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.