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. I then let InDesign CS4 do the merging. Here’s the formula.


Thank you for these clear instructions. I have had the same problem as Mommy Vaughan and followed the suggestion. However, on re-opening the Word document, I have the dialogue box Invalid Merge Field. I have to use Task Manager to close down Word. I am using Word 2010. Maybe that is part or all of the problem. Any ideas please? I need to sort this by tomorrow night to print them on Monday!
• On the document page, override the items by Command/Ctrl-Shift-dragging over them (or clicking on them). • Select that one page and duplicate it in the Pages panel, or by choosing Layout > Pages > Duplicate Spread. • Select the original page and the duplicate and then copy those. Repeat this (select pages and duplicate) until you have enough pages. Unfortunately, InDesign isn’t exactly speedy at updating these numbers when you add a bunch of pages.

The EASY way to set up the text file is to use Excel to make a grid the number of sheets wide by the number of tickets per sheet deep. Put the first number in the upper left cell, then fill consecutively to the right until the number of columns is equal to the number of sheets you will print, then move down a row and do the same thing with the next numbers, and so on until you've finished the grid.
An awesome new feature to has been introduced to Microsoft Publisher 2010 is the ability to use Data Sources to create "Catalogue Pages". This is like a Mail Merge for design documents. Now, I would have to agree that Publisher isn't the best graphic design program in the market. But it's certainly adequate for simple ticket designs — for example, for a school social. Let's say we want each ticket to have a unique number and an inspiration quote. This is all possible through Publisher and a data source, e.g. an Excel Spreadsheet.
Gift certificates and promotional coupons can play an important role in your marketing strategy by drawing new and repeat customers to your business. However, how can you tell if they are really working to help you develop your business? To make the most of your time and your marketing budget, you need to track the success of your marketing efforts so that you can determine what marketing tactics are effective for which customers.
Create a master frame in ID to hold the number and if I have more than one ticket on a page just link the frames. Apply a paragraph style that starts in a new frame for the numbers. Place the text file with a shift click and the numbers are formatted and the new pages are autoflowed. The number list is very easy to create in Excel with the auto fill feature for that type of thing.
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.
This program makes you adept for not only creating event tickets but also generating attractive resumes and different menus. What you need to do is to find the appropriate Microsoft template and include the desired texts in the blanks available. The program then allows you to opt for the color of your choice .subsequently you can either save the template as a file or you can click on the print right away.
Select the Text Tool (T) and start dragging a text box that will wrap around the whole ticket including the crop marks. This is very important since the Data Merge will automatically calculate the duplication. Then open up the Text Frame Option (Command + B) and set the Inset spacing to 1p4 for the top and 1p8 for the left. Of course, you can place the text for the numbers anywhere you like. I set the numbers to a small text.
Open a new blank document in Word. Create two raffle ticket designs, one for the person who buys the ticket and one for the organization selling them. Make sure to connect the two tickets, for example by making them in two-cell tables, side-by-side. Include the name of the organization, perhaps the first prize, and any other information you want on the buyer’s ticket. You might, for example, include spaces for the buyer’s name (“Name__________”) and phone number on the organization’s ticket. On both tickets, enter a dummy number for the raffle ticket number as a placeholder.
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.
You’re selling raffle tickets to make money, so why buy the tickets pre-printed? Using Microsoft Word’s mail merge function, you can create your own raffle tickets and design them any way you please. A mail merge doesn’t have to make mail; it is simply a way to define certainly elements of a document, then automatically insert variable elements, such as raffle ticket numbers. The most important thing to remember is that each ticket needs a mate–you don’t want to pull winning ticket number 81018 only to find that no one bought that one.

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.
Another fan of Fusion Pro Desktop here. This is exactly what you need. We have sold both PrintShop Mail and Fusion Pro Desktop for this very application (numbering) and other VDP applications. Fusion Pro Desktop easily beats PrintShop Mail from both a price and performance viewpoint. You could also try Printer's Bench http://www.elkriversystems.com/ProductsList.aspx for a good entry level package

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

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.

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.
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!
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.
The trick is this: I creat an 'template' of the card, somewhere outside of the page. All object for data are text object, with all the formating needed. In place of the photo is an rectangle. The script read an text file (CSV) with the database, duplicate all template object, one by one and replace string in text object with the string from DB and import photo in place of the rectangle, redimension and convert to RGB or CMYK, acording to the initial data (atach.) When the page is full, create another one.
Below, we have a small and easy to follow tutorial on how to create sequentially numbered raffle tickets using Microsoft Word and Microsoft Excel. Simply choose one of our 30 raffle ticket templates and download it to your computer. Next, begin the following tutorial. This tutorial will take you through the process of using Excel to create the numbering sequence, which you will then save, and import into Microsoft Word.
When you have Microsoft Publisher at your hand, you need not worry about running to stores to explore and buy tickets for organizing company day outs, vacation give away or a business board meeting. Microsoft Publisher provides you with several Word templates from which you can create event tickets with ease and skill. It even includes the fundamental chronological ordering required for raffles .once you get the ruse of setting up numbers in the ticket series, you can commence numbering in your own style.
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.
×