One of the most profitable products a small print shop can produce is Raffle Tickets. But the trouble is most small to medium sized print shops either don't have a numbering unit or it is not setup to number multiple documents on a single sheet of paper. Most print shops do however have a laserjet or multi purpose printer. Combine that with some graphic software like Publisher and and easy to use numbering software program and you can capture the raffle ticket business and not let it slip away from you.

@Andy: I’m sorry that I sounded dismissive. That wasn’t my intent. Rather, I was just admitting that I had no idea why someone using CS3 would not see the dialog boxes as they are shown above. If you’re using CS2, they would be significantly different. But the second part of the tip (where I show the numbering dialog boxes) relies on CS3 or later. If you are using CS3 or CS4 and you don’t see that dialog box, feel free to email me at david [at] indesignsecrets [dot] com and send me a screen shot of what you are seeing.
To use mail merge to create a batch of gift certificates or coupons with tracking numbers, you need to set up a data source that contains a column listing the tracking numbers. If you plan to add only the tracking numbers to your publications, create a data source for the tracking numbers. If you also plan to use mail merge to insert additional information into your publications, such as customer names or addresses, you can add the column of tracking numbers to a data source that also lists the name and address data that you want to use.
Adobe, I expected better! Hi Folks, I’d like to share my solution. It came to me partially in my sleep, I tried refining it this morning but because of time, finally had my production person print the manually numbered tickets so that we could deliver them to the customer who needed them today. Here is my solution. I deduced that it would be better to let a program designed to count, do the counting. I used Excel.
It was the paper size and multiple pages that was stumping me. However I do have a tip for those wanting a short cut to raffle books of 10. It is a little more fidgety so Im sure someone who is experienced with excel (Im not) but it will make the cutting perfect. Print out in sheets of ten and you just need to staple, cut and perforate...then you have 4-5 ready made raffle books.
Having personalized raffle tickets printed can get expensive, especially if you operate a fund-raising operation and must do this often. An alternative to using costly printing services is to use the raffle ticket template. With the raffle ticket template, you save money. The raffle ticket template also gives you complete creative control. Simply by opening a template in Microsoft Word means that can design it yourself by adding both text and images, all from the comfort of your own home.
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

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.
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.
The next step is to create the simple Excel workbook that contains the ticket numbers. Open a blank Excel sheet. Using Figure B as a guide, create the ticket numbering sheet and save it, making sure to note the new workbook's name and location. As we discussed earlier, the Excel workbook stores the ticket numbers. In this example, we'll create 11 tickets numbered 100 through 110. You'll need to update the ticket values for each merge.
Thank you for the explanation. Yes, our digital machine (Minolta Bizhub) does have a variable data module, however the support folks do not seem to be able to successfully get it to number in the correct order for output to print and stack properly for our needs. Indesign works great in this manor but with the quirps we are discussing here. Anyway your assumption that I do not understand threads is true. I have never done "threading". I am going to focus on this next as you mentioned it is easier than data merge. We do numbering of carbonless forms, raffle and event tickets often here and so the "smoother" the better. Apparently my supervisor requires that I make it work with the tools at hand and will not "invest" in any "pricey" new programs.

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.”
In the example I explained, I was using a list, but did it with un-linked text boxes using “continue from previous number” and “continue numbers across stories.” I’m guessing that there is no way to tell InDesign that even though there are 4 text boxes on the page, that there are two different lists? I’d probably have to just create two threaded stories for that scenario to work.
You need at least one space to make the autonumbering kick in. Now Option/Alt-click on the Autonumbering button in the Control panel (or choose Bullets and Numbering from the Control panel flyout menu) and choose the list you created in the Lists pop-up menu. You might want to adjust the other settings to match this: Now you’re done. Click OK and you should see the number appear in the text frame.

You need to create a list of numbers using some method (maybe even through VBA) as a text file, database or other data source, then just insert merge field in the document and use Print Merge to generate multiple labels with different numbers in it. (just need to give it enough space to fit the longest string along as many lines as you think there could be) If I reserve space for 50 chars and the major strings are 25 chars, the result is not professional looking. My solution for all print merge for ID cards (and similarities, incl. Auto numbering) is to merging data BEFORE printing, in an CDR file with all pages. So, I check all the cards and I correct only on text object how need. I found an software with this capabilities, but 300 USD is excesive (not only for Est Europe) for one only week of working (yes, his UI is better than my). I found an software with this capabilities, but 300 USD is excesive (not only for Est Europe) for one only week of working (yes, his UI is better than my) And my script use photo also.

My quick process involves setting up a row of plaques with a01, a02, a03, thru a09. Then copy the plaques to the clipboard. Run the REPLACE TEXT feature to replace "a" with "1". Move row down and paste clipboard back into page. Run REPLACE TEXT to replace "a" with "2". Repeat until I get all the numbers. It's faster than manually typing the numbers in but I know there's go to be someway of automating the process.
Raffle Ticket and Event Ticket NumberingRaffle ticket numbering can be easy and give you a larger array of products to offer your customers.     Besides the printer, and software you will need a paper cutter and perforator if you are going to offer a ticket with a stub. For a small table top machine that is affordable I would recommend the unit below. This is adjustable and allows for multi perforations and scoring in one pass.
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. Football, Baseball, Raffles, Prom, Graduation… the list goes on. The worse part is each is different and has to have x number in this color that color it can be very frustrating. Then to top it off I have the most random number of requested tickets sometimes and it was extremely difficult to find a method that worked and yours did! Like a charm! I can choose how many zero how many out I need and if there are special versions I can separate them too! Thank you, I was just about to run screaming from the building!
Then you want to go to your numbered doc. Go to VDP tab. Leave Create Master alone. Use master pull down tab should have your document name in list. Select that. Do the same as the before right click and remove raster and the process and hold. When done processing you should be able to view your documents merged together with the numbering in the right places. Hope this helps. Oh be aware....clean out your Fiery often, if you get to many VDP doc archieved your Fiery will crash. It just cant handle it unless you have the Fiery with the extra features.
data merge can be a little tricky for this. Try making a single ticket at the top of your page (not on the master page). Put your merge fields into this ticket. Then when using data merge click the option to put more then one per a page, preview and see if this does what you want it to do. Granted if you have double sided printing, data merge gets very tricky, but can be done.

Subsequently you have to select the template named Raffle tickets 6 per page. Microsoft Word will make available a preview of the chosen template and then inquires whether you wish to download the particular template. Now choose the option to download. Consequently your current word document gets replaced with the template of raffle ticket which is ready to undergo editing in your hand.
There’s an old Steve Martin joke about how to make a million dollars which starts, “First, get a million dollars…” That’s the key to this trick, too: First, get a bunch of numbers. Here’s a file with 1,197 numbers in it. Now import or paste those numbers into a thread so that the numbers appear in the right place. If you need two matching numbers, just import it twice.

CS2 (or earlier) “Cheesy” Numbering There’s an old Steve Martin joke about how to make a million dollars which starts, “First, get a million dollars” That’s the key to this trick, too: First, get a bunch of numbers. Now import or paste those numbers into a thread so that the numbers appear in the right place. If you need two matching numbers, just import it twice. To ensure each number fills its own text frame, select the whole story (Command/Ctrl-A), open the Keep Options (Command/Ctrl-Option/Alt-K) and choose In Next Frame from the Start Paragraph pop-up menu.

I know that PrintShopMail will do it, but I was wandering if there was a less expensive solution out there so that I could get numbered tickets (usually 4-up) right off the Xerox. I just want to avoid having to go the the Windmill after trimming and doing it the old fashion way. There is a tiny little copy shop here in town that is doing it, and am willing to bet that they are not using PrintShopMail, but I'm also not going to ask them to share their methods with a competitor. There has to be cheaper solution. I know that I can do it with auto page numbering in Indesign, but that means I can only print raffle tickets 1-up which wont work.
This takes a little figuring out. I spent about 3 hours before I got it right, because I can be a little dense about things sometimes, but if you are going to do set numbers of tickets a few times, the time you spend arranging the numbers is well spent and will be made up on the cutter and in the sorting. It seems to me that you could do the same thing for use with the variable data module on the BizHub. I suspect the issue is that you have consecutive numbers on the same sheet so someone has to sort them all and stack them in order after they're printed and cut.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139
The very first step you need to do is to drag your cursor towards the Help icon in the new word document. This icon usually appears in the right part of the top portion of the tool bar listing. It is depicted by a question mark symbol. You have to left click on this menu with your mouse and you need to opt from the type of help listed in the drop-down carte du jour. (Ticket Invitation Templates Download)
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.
Number-Pro makes numbering raffle tickets and forms easy using your desktop publishing software like Indesign, Microsoft Word and Publisher and Corel Draw. Number Pro creates a data merge file based on your numbering requirements that can easily be integrated into the desktop publishing software that allows for printing directly to your small business or home printer.
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.
×