With all of the many available templates, how do you select the right ticket design? It’s a good idea to choose a design featuring a background image that in some way fits with your fundraising purpose. This ties your efforts together in a cohesive way, making your tickets more attractive to buyers. A good design gives potential buyers an idea into the type of cause they’re supporting right off the bat.
You don’t have to be a born salesperson to move all your tickets, but the better your sales tactics, the more successful you’ll probably be. Peter Kajanzy teaches how to crush a sale with pro techniques. One bit of advice he offers: When people ask for the price, instead of doing a complex breakdown of one for $2, three for $5, and so on, go straight to “You can buy five tickets for $8.”
I answer readers' questions about Microsoft Office when I can, but there's no guarantee. When contacting me, be as specific as possible. For example, "Please troubleshoot my workbook and fix what's wrong" probably won't get a response, but "Can you tell me why this formula isn't returning the expected results?" might. Please mention the app and version that you're using. I'm not reimbursed by TechRepublic for my time or expertise, nor do I ask for a fee from readers. You can contact me at susansalesharkins@gmail.com.

I usually do my numbering in excel and save it as a tab delimited text file. I would put the starting number in A1 and insert a formula in A2 that is basically A1+1. Then I grab the lower right corner of that cell and while holding cmd (on Mac), I drag the cell down to A10 (or whatever number of pages you will be printing). This would auto populate the cells and change the formula to basically add 1 to the previous cell. Now go in B1 and insert a formula that adds 10 to A1 (or whatever number of pages you will be printing). In this example, the value should be 11. Then drag this cell to repeat the formula right to have the number of up you will have. The select A2 trough A10 and drag them the same way to populate the remaining cells. Save your excel file for future reference and save as tab delimited text. Open the file in textedit, find every tab and replace all with a paragraph change. Then import the file in investing in linked text boxes over your imposition.

Now click on the Microsoft Office Word Help option. Consequently, to the right side of the word document, a support box will pop up. You can easily look for the option Search for and after you find this box, you need to type Create numbered tickets and hit on the green arrow. This Help feature will do all the work for you and it will enlist a number of relevant choices in the area of your search. (501 Microsoft Templates)
I had wanted to create a file that didn't require Excel as the data source, so I created one using SEQ fields. It was terrible and too huge to mention (thanks Doug Robbins), so I recreated it using Word as the data source so that people who only have Word can use it. You can create up to 5,000 tickets without changing the data file. If you only have Word and need to create more than 5,000 tickets, please don't type the ticket numbers. Just drop me an email and I'll create another data file for you with the required numbers.

See to it that there is a place for the show name as well as the movie name. This is a key feature for any movie ticket. It should come out clearly so that the one buying the ticket will clearly see the name of the movie they are going to watch to develop some interest in it. The ticket number should also be brought out clearly but this should not obscure the movie name to enable many to buy the ticket.
I would like to number a voucher book, i have place 4 vouchers on a page, the thing is that i want each of these vouchers to start with different number, 100, 200, 300, 400, and then i want to number them 99 times. The problem is that they have to be numbered only 1 per page, so that when i have printed them all i can easily crop them and staple them right up with having to go through it all.
i’ve had to do tons of this lately and found that for the amounts of tickets being done (e.g. 7000 x 10 tickets + cover & mailer) that chuckT’s solution almost 2 years ago is similar to what i use. would be interested to know if others doing similar VDP are using a wholly indesign/excel solution, or if specific VDP software such as XMPie are being used.
Good morning! Directions are clear for sure but when i go to merge the first ticket is one but the second number on the raffle ticket is two. i have four raffle tickets per page the first three are messed up but the forth is correct all the way down to 500. Any ideas? i have tried with a header and without a header. i even made the first number with a formula. it does work with out putting next record but like you said it is four tickets with the same number and that would use a ton of ink. Any help would be greatly appreciated.
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. :-)
Since it’s a group of people who have chosen to raise fund using this means the format of the raffle ticket has to be the one agreed upon by the group. The initial stages will thus be those of trial and error as each person will have his/her own opinion of what should be the format and design of the raffle ticket. This site recognizes that such challenges exist and the raffle ticket templates that we offer you will be in a design and format that most if not all of the people will fall in love with. After a certain format is accepted by everyone you will not have to worry about how to come up with new raffle tickets as these can be used over and over again.
I basically used Bob Levine’s method (thanks) but wanted to add some extra detail – am using CS2 which is somewhat behind CS3 in this area. David, I was very discouraged to read your response to Josh on April 28th 2008. It seems your comment was quite dismissive to him with exactly no feedback help. He seemed to be looking for some more help trying to work through what you and the other InDesign gurus discuss as a “simple process”. I to, have read through your directions while using both mac & pc platforms. I fail to find the “standard features” screen shots that you show above in either program. I too have spent several hours trying to get the sequential 3-up numbering as described.
Generating numbered tickets in Microsoft Word document might seem quite challenging and a taxing task if you are a novel user who is not adept in handling Word documents.You might have made numerous attempts in exploring Word templates and might have been fruitless, depressed and annoyed with all the alternatives and problems that you might have come across while trying to comprehend how to create tickets in Word.
Click "Save File" at the "Opening Raffle Ticket Setup" prompt. Go to your downloads folder and open the "Raffle Ticket.exe" file. Click "Run" at the security prompt. Click "Next" twice at the installation wizard prompt. Select "I accept" at the software terms. Enter your "User Name" and "Organization" details. Click "Next" twice and select "Install." The software loads on your computer. Click "Finish" to complete the installation.
I basically used Bob Levine’s method (thanks) but wanted to add some extra detail – am using CS2 which is somewhat behind CS3 in this area. David, I was very discouraged to read your response to Josh on April 28th 2008. It seems your comment was quite dismissive to him with exactly no feedback help. He seemed to be looking for some more help trying to work through what you and the other InDesign gurus discuss as a “simple process”. I to, have read through your directions while using both mac & pc platforms. I fail to find the “standard features” screen shots that you show above in either program. I too have spent several hours trying to get the sequential 3-up numbering as described.
Given that Word can support 2,147,483,647 SEQ fields, the whole job could be done in a single document containing 30,000 tickets. On my system, creating such a document took only a few minutes and, once created took about two minutes to update the fields - and that was with about 40,000 pairs of SEQ fields coded as {SEQ Ticket \# 00000} and {SEQ Ticket \c \# 00000}. This number formatting is enough to go to 99,999 tickets.
Microsoft Publisher, the desktop publishing component of the Professional version of the Office Suite, can perform many time-saving tasks for busy business owners, including layout and design work. It can even help you avoid a shopping run to try to find tickets for your next employee picnic, holiday giveaway or executive board meeting. Create your own tickets, including the vital sequential ordering needed for raffles or attendance tracking, using Publisher’s page numbering. With a few tricky manipulations of the page number process, you can start running the numbers in an entirely new fashion.
There is very simple solution that we use and that is to lay out the sheet say 6 up on a A4 sheet as a master page and in document setup set the number of pages to 1,000 if that is the amount you require. Put a page number on each ticket on the page and although they will all have the same number on each page, we put the the first two letters of the customers business name before each number followed by the letters of the alphabet so it then reads for example BT1A, BT2A, BT3A, BT1B, BT2B, BT2C and so on as each page is printed.

In trying to produce 300 tickets, I can get all of the first numbered position to be sequential over 100 pages. But, when moving down to the second or third ticket position on the page and setting up the numbering, I repeatedly find that I get a repeat of the first 100 numbers. I am lost as to how to proceed. Is there any other missing step or info that I am assumed to have knowledge about that was not mentioned above? If you know of some other site that might explain this process any better, please post.
I normally use "Data Merge" in InDesign and use Excel (or something like it) to generate the list of numbers for me. You would copy the numbers into a text file so that InDesign can read them as the merge data source. Note that you would have one ticket on the page and then let InDesign set the other tickets on the page (you can tell the Data Merge control panel about spacing).
That’s enough tips for now. You’ll be filling your fundraising thermometer template How to Create Your Custom Excel Fundraising Thermometer Template How to Create Your Custom Excel Fundraising Thermometer Template Use an Excel thermometer chart to visually keep track of your financial goals. Whether you're saving for a new gadget or fundraising for a good cause, here's a step by step tutorial. Read More in no time. Let’s get to the tickets.
Chuck, It does look as though using data merge is the best way, but rather than generating the numbers in Excel here is an improved number generator script to create indesign number and counterfoil numbering data merge files. We recently had to print 500 numbered tickets 8 up on 8.5 x 11. When we took it back to Bindery they would have had to hand collate the tickets back in order after the cut.
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.
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.
Raffles are not only a great way to get funding for your cause, your participants also get to go home with awesome prizes — it’s a win-win situation! But, fundraising is hard and demanding enough, add designing raffle tickets to it and you can quickly get overwhelmed. We hear you! With Canva, you can design awesome raffle tickets even with little to no design experience and without having to shell out a large sum — you can keep that to aid your cause!
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. :-)
Now for the slightly hard bit. If you just try and complete your merge now, you'll get several pages of tickets. Each page will have four tickets on it. But all tickets on any page will have the same number. Each page will have a different number, but all the tickets on that page will have the same number. That's no good. You need each ticket to have a different number.
×