A raffle refers to a way of generating money by selling numbered tickets, then one or some of the sold tickets are drawn at random and the holder or holders of these tickets get to win a prize. This method of raising cash has been employed by many people especially groups which want to acquire an asset or start a certain project. It is thus not surprising when your child approaches you on how to come up with raffle to help his/her club raise some cash.
Our raffle ticket templates have a placeholder for a ticket number, usually “xxx” to remind you it needs to be replaced. Select it, click Insert Merge Field > Ticket. Do the same for the second ticket number placeholder. Most tickets will have two number placeholders because one part of the ticket is for the raffle host (you) and the other is for the purchaser.
I'm not sure about using an open office version of excel would work the same but create a file with your numbers in it starting with 0000 or however many 0's you need then click and hold in corner of cell and drag down, should auto populate. Document must be Saved As "text (tag delimited)" keep clicking ok. Save it this way only when completed somewhere you'll remember. Now go to inDesign and create one ticket. Add a text box and open data merge, navigate to the number file you just created and click/double click (don't remember) and an "options" box will open. This is where you setup your page size, bleeds, etc., I know multiple pages has to be checked. I think you can preview from this too and make necessary adjustments.
The task of producing numbered tickets in Microsoft Word might seem pretty tough and strenuous especially for those people who are not skilled and trained in using Word files. There are quite a lot of people who have been left disappointed, disheartened and exasperated by their failures in attempting to explore how to create tickets for an event using Word templates. Many unanswered queries, doubts and confusions might have stood in the path of your success.
But it’s not hard to duplicate and reduplicate until you have a thousand or more numbered tickets. I think the conclusion of all these Rube Goldberg approaches is that InDesign still isn’t ready for handling what is really a head-smacking-stupid-simple kind of numbering job — the kind of jobs computers were created for in the first place. My DOS word processor XyWrite — from AD 1987! — could do numbering stuff like this in no time and with no trouble. Quite ridiculous, really, when you consider the staggering graphics and typography capabilities inside InDesign — but the poor thing cannot really count. I handle this much differently. I create a number list in Excel and save as a txt file.
We use the auto page numbering trick here, the trick is to do it as spreads. You just make your pages the same size as the ticket with crops and bleeds. Then set up the shell on the master page and place your auto page number where you want your numbers. Each pages is the next number. You can also have two sets of numbers for perforated ticket. You then can use the page start options to add to the numbers and keep the same number of total numbers. For example you would do a new page start after number 99. 0001 to 0099 so it doesn't add two "0's" to the front of 100 and you get 00100 when you want 0100. Works great for small quantities, we have done up to 1000+ tickets and once you do it once or twice it is a snap to set up. To avoid having to do 1000 pages just send the tickets in groups. Usually between 25 to 100 at a time works good depending on artwork file size. Just save each time before sending to printer and name the file with what the tickets are. Like "MyTickets-0001-0100.Indd". Makes it easier to go back if you have a problem. You can even do two rolls of tickets if your using 12 x 18 sheets by flipping the sheet and doing one row along the top and one along the bottom on reverse side. That is if your ticket is single Sided. Two sided tickets are a bit trickier. :-)

Microsoft Publisher offers many design tools that let you create any type of publication or document. You can essentially make anything in Publisher, including tickets. The easiest way to make tickets in Microsoft Publisher is to download a ticket template from Microsoft Office's website and modify it in Publisher with your own text, colors and graphics. These steps can be used for creating tickets in both Microsoft Publisher 2003 and 2007.
I'm not sure about using an open office version of excel would work the same but create a file with your numbers in it starting with 0000 or however many 0's you need then click and hold in corner of cell and drag down, should auto populate. Document must be Saved As "text (tag delimited)" keep clicking ok. Save it this way only when completed somewhere you'll remember. Now go to inDesign and create one ticket. Add a text box and open data merge, navigate to the number file you just created and click/double click (don't remember) and an "options" box will open. This is where you setup your page size, bleeds, etc., I know multiple pages has to be checked. I think you can preview from this too and make necessary adjustments.
But it’s not hard to duplicate and reduplicate until you have a thousand or more numbered tickets. I think the conclusion of all these Rube Goldberg approaches is that InDesign still isn’t ready for handling what is really a head-smacking-stupid-simple kind of numbering job — the kind of jobs computers were created for in the first place. My DOS word processor XyWrite — from AD 1987! — could do numbering stuff like this in no time and with no trouble. Quite ridiculous, really, when you consider the staggering graphics and typography capabilities inside InDesign — but the poor thing cannot really count. I handle this much differently. I create a number list in Excel and save as a txt file.

So we came up with a way that when each stack was cut they would simply be stack on top of each other. We couldn’t figure out a way to add 8 sets of grouped numbers to 8-up layout so I had to go into the txt file and number it manually. It worked fine but took a little time. Is there an option to pull 8 different sets of numbers to one page? You saved my life! I work at a School Board with 200+ schools and 100+ departments and I have to number every ticket I make.


So we came up with a way that when each stack was cut they would simply be stack on top of each other. We couldn’t figure out a way to add 8 sets of grouped numbers to 8-up layout so I had to go into the txt file and number it manually. It worked fine but took a little time. Is there an option to pull 8 different sets of numbers to one page? You saved my life! I work at a School Board with 200+ schools and 100+ departments and I have to number every ticket I make.
I am using your instructions to create a page of tickets - the design has been created as a picture so I added a text box to "hold" the mail merge instructions but I keep getting the error message "You cannot include DATA, NEXT, NEXTIF, or SKIPIF fields in comments, headers, footers, footnotes or endnotes." I have not included any of these but I'm wondering if it's because I've attempted to insert it in a text box. Is there an easy way to do this? TIA
×