(Ticket artwork courtesy of. Thanks, Mordy, for pointing out this site!) CS3 List Numbering A significantly more elegant way to handle numbering in InDesign is to use the autonumbering feature in CS3. (CS2 also has an paragraph numbering feature, but it’s not nearly as powerful.) First, create a numbering “list” by choosing Type > Bulleted & Numbered Lists > Define Lists. Then click New to create a new list. You can name it anything you want, but make sure the Continued Numbers across Stories is enabled: After you click OK and close the Define Lists dialog box, create a text frame and type any character (such as a space).
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.

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.


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.

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.

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.


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! All the “solutions” mentioned on this page are great examples of a great irritation in the graphics industry: When offering solutions, PLEASE mention the platform you are using and save people some frustration; what works great for you on a PC may not work at all on a Mac. What options you see on your version of Indesign are NOT cross-platform and Corel is strictly a Windows application. Thus we get puzzled responses from those who can’t understand why someone cannot grasp what they see as a simple process.
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.
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! Being the printer, I can’t say I pass the job on to the printer.:-) We do it using auto page numbering, export it as one big pdf, and then use our imposition program to lay the file up multiple times on a page. A lot of jobs we do leave the number blank, and use the numbering machine later, but we’re getting more and more jobs that are run on digital presses like the Docucolor 250 and have numbers too small for the numberer, so we have to do them in the file. This works fine for single-sided jobs, but when a job numbers on one side, but not the other, it gets tricky, especially if it’s NCR, which has to be duplexed.
You probably know about Word's mail merge feature, and you might even use it to print labels or other documents, where some of the information changes (such as form letters). You can use the same feature with Publisher. Although you might not think of Publisher as an Office app, it comes with several different versions of Office. In this article, I'll show you how to print sequentially numbered tickets using Publisher and Excel. This article provides instructions for Publisher 2007, 2010, and 2013.

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

Corel DrawLay out as many tickets per page. Number anywhere on the ticket.Number-Pro is also used to print multi form document like invoices.This is a great application to have in a small to medium sized print shop as well. If you or your shop does not have the ability to perforate paper and card stock, it can usually be bought at a local wholesale paper supplier or online like perforatedpaper.comNow raffle ticket numbering is within the capabilities of everyone from the home, do-it-yourselfer, organizations wanting to do fundraising and print shops of all sizes. Number Pro is a true raffle ticket number generator
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.
Corel DrawLay out as many tickets per page. Number anywhere on the ticket.Number-Pro is also used to print multi form document like invoices.This is a great application to have in a small to medium sized print shop as well. If you or your shop does not have the ability to perforate paper and card stock, it can usually be bought at a local wholesale paper supplier or online like perforatedpaper.comNow raffle ticket numbering is within the capabilities of everyone from the home, do-it-yourselfer, organizations wanting to do fundraising and print shops of all sizes. Number Pro is a true raffle ticket number generator
Permalink Peter, I have done the "master" function successfully. It appears to work.I ran a form job to the press with a large quantity of numbers successfully. Thank you. A full color ticket job with only two hundred sheets did create a large file in my print que however, and feed very slowly. Can you tell me; Does Indesign still create an image for each sheet when printing? I am still a bit confused about the threading technique you mentioned. Would this create an easier feed to the printer or "smaller" file size?
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.
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.

As far as threading the frames, is it that you don't understand threading? You accomplish that by using the selection tool to click in the outport box (the larger square near the lower right corner of the text frame), then clicking inside the frame you want to be next in the thread. Repeat as often as required, selecting the outport of the last frame you threaded each time. Text will now flow automatically from the first frame to the end of the thread. You can work backwards, too, if you wish, by selecting the inport (upper left) instead of the outport.
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'm trying to number some custom raffle tickets, 10-up on a 12x18 document. I thought surely there's a way InDesign can do that through a master page or something like that but a good google search isn't really producing any conclusive results. I've seen talks here and there about data merge with a .txt that has the numbers on it but haven't seen much on doing this with tickets that are X-UP on a page. Any help would be great. how to number raffle tickets in coreldraw
×