[libreoffice-users] Re: Sequentially numberted tickets...
Am 21.08.2013 15:54, schrieb Nino Novak: Am 21.08.2013 06:42, schrieb David Love: 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. then the Next Record fields seem to not work, see below. Oh, I think here I draw the wrong conclusion: If the field numbers are empty then only the number fields from the first ticket have been correctly inserted, the other fields must be somehow wrong. However - make the fields visible with Ctrl+F9 (or View Field Names) then look what's wrong with them :-) BTW: If you want a preview of the resulting Merged Document on the fly, you can select a couple of rows in the F4 data source window (click on the first row, then shift-click on the tenth row or so, so that they are all marked blue) and click on the Data to fields button in the data source window. Nino -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Re: Sequentially numberted tickets...
Hi Nino Nino Novak nn.l...@kflog.org 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 copypaste 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 dragdrop) 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 correctrepeat 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: users+unsubscr...@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
[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 copypaste 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 dragdrop) 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 correctrepeat 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+unsubscr...@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
Re: [libreoffice-users] Re: Sequentially numberted tickets...
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 nn.l...@kflog.org To: users@global.libreoffice.org users@global.libreoffice.org 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 copypaste 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 dragdrop) 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 correctrepeat 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+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Re: Sequentially numberted tickets...
Nino Novak nn.l...@kflog.org wrote: 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 [snip] Thanks, Nino. I will give it a go and report back. David -- David Love Do more than anyone expects, and pretty soon everyone will expect more -- To unsubscribe e-mail to: users+unsubscr...@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
