You’ve got some tips to help make your raffle more successful. You’ve got several free Word ticket templates to choose from. You know how to sequentially number tickets in two different ways. All that is left for you to do is go sell those tickets, have the draw, and then feel good about helping someone out. All for pennies on the dollar over ordering custom made 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 which version of InDesign first introduced printing Thumbnails like this, but even if yours doesn’t support that, your printer driver may have a similar feature of its own. Check the printer’s own dialog box by clicking “Setup…” near the bottom left corner of the Print dialog and dismissing the warning, then clicking “Preferences…” in Windows’s Print dialog that comes up (I’m not sure how to access this on Mac OS X, but I’m pretty sure there’s an easy way). For instance, on many HP printers, the feature you want is called “Pages per sheet” and has a drop-down offering 1, 2, 4, 9, or 16 pages per sheet.
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.

Numbered tickets are a bitch in InDesign. Mainly because if the RIP time. I've found that what I have to do is do two runs. One run of just the tickets with the blank area for the numbers. Then I put those back through the copier to print the numbers on them. You want to set up an excel sheet with just one set of your numbers. Not 1, 1, 2, 2. Just 1-3000. Then you create the text boxes for the numbers for the first ticket and draw a text box that is the exact size of the ticket around and send it to the background. Then do a mail merge. You will grab the mail merge name of the column and drop it into each text box so each text box will have the name of your column (like <>). That means that being the same, each number will go into each box so the first ticket will get number 1 and number 1. Then you do the mail merge doing multiple entries per page or whatever it's called and it will create all the pages needed. So you will end up with a 375 page document to create 3000 total tickets based on an 8 up.

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. :-)

Thank you for these instructions!! I'm using them to auto number my son's baseball team raffle tickets which we hand numbered last year (UGH!). I followed the instructions exactly but for some reason the numbering is starting at 2 every time. I did deselect the checkbox about the column headers which seems the obvious culprit. Any ideas? I'm using Word on a PC. Thanks!!