I am creating a file in inDesign for a client that is asking for numbered tickets. They'd like to be able to print a specific number for each ticket. I've read some of the older answers for similar questions that refer to Data Merge, but I'd prefer not to take that route if avoidable. What I'd ultimately like to do is create a space for the numbers to go, select the number of pages within the Print menu, and have the spaces populate with the corresponding numbers while printing.
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 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.
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. The script that Mike referred to worked very well with CS2 and was fairly easy to extend to doing counterfoil numbers as well, but doesn’t seem to work with CS3. I have thrown together a small online script to generate the contents of a data source file to do ticket numbering through the normal CS3 InDesign data merge routine.
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 have a 700. In Indesign I design raffle tickets 5 up. You have to create an excel file with your numbering 5 up or 5 columns, save as a text file. Use your data merge in Indesign. If your file is too large your Indesign will crash. So keep the placement of your number and delete all other copy on the page. Then do a data merge. It will create just the numbered pages. Send that to your Fierty command workstation as process and hold. Go back and send original file with just your copy layout as a process and hold job. In your command workstation open copy file


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.

We have a 700. In Indesign I design raffle tickets 5 up. You have to create an excel file with your numbering 5 up or 5 columns, save as a text file. Use your data merge in Indesign. If your file is too large your Indesign will crash. So keep the placement of your number and delete all other copy on the page. Then do a data merge. It will create just the numbered pages. Send that to your Fierty command workstation as process and hold. Go back and send original file with just your copy layout as a process and hold job. In your command workstation open copy file
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.
OfficeArticles.com provides examples of Formulas, Functions and Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Formulas, Functions and Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.

Whether they're getting ready to win or ready to enter your big event, your guests will love the thrill of entering with our raffle tickets. Each ticket comes with a twin ticket, which means you get to keep one while they keep the other – there's no memorizing of entry numbers with these ticket! Also the number of the ticket remains with your patrons as long as the ticket does! Plus, with the great selection of colors we offer, the ticket isn't going to get lost any time soon.
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!
The ticket numbering problem seems solved, if awkwardly. But what about linking automatic numbering of text references to a figure (e.g. “see fig.101″) to a legend of that figure (e.g. Fig. 101 shows….”)? Is this quite beyond InDesign CS3? If it is solvable the solution isn’t mentioned in any CS3 book I have managed to get hold of, nor is it dealt with in the CS3 Help facility as far as I can see, nor were the speakers at a recent Adove CS3 Workshop able to solve it. Please advise this frustrated book author!
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.

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.
In Excel, I created a file with columns A-H labeled: ticket 1, stub 1; ticket2, stub2; ticket3, stub3; ticket4, stub4. I then numbered two rows across 1 -4, then 5 -8. Then I dropped down to A – H in row 260. (I did this to give 1,000+ numbered tickets.) I then used the Excel fill function chosing series and told the program to skip by 4. It filled the rows. I then saved as a tab delimited text file.
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.
To design a certificate from scratch, you can either start with a completely blank publication or adapt an existing publication. Small-sized publication types, such as business cards, postcards, and labels can be adapted to serve as coupons. Flyers or brochures can be adapted for use as gift certificates. For more information, see Create a publication in Publisher.
Before selling, try to raise as much awareness about your raffle as you can. Flyers are easy to distribute and display – download yours from our free raffle flyer template page. Choose places where you expect a lot of foot traffic. Not only can you hand them out to passersby, but with the right permissions, you can display flyers in store windows and other prominent locations.
1. On the first hand, you need to initiate Microsoft Publisher. You can view a magnifying glass icon and you need to hit inside the little field which shows Available Templates page. Now you should type the Word ‘tickets’ and move your cursor towards the magnifying glass icon. Hit on it. Subsequently you need to evaluate and assess the ticket options in the Microsoft Publisher. After that you can double click on the desired template. For example if you want to open the raffle ticket template just double click on it for the Publisher to open it for you.

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.


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.
@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.
GREAT tip with lots of uses! Thank you. This will save me hours of work on some tickets I’m designing. However, I also need to set up table tents that have numbers on them. They’re 2-up, and are folded, so each number needs to appear twice on the same page. In short, I want a page with 1/1 and 2/2, and I’m getting 1/2 and 3/4. Am I missing an obvious fix? Thank you.
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
×