I am trying to create raffle tickets, 4 on a page with only a number on the stub. My problem is when I get to the print preview and change it to "multiple pages per sheet" it is just changing the number on the next page and not on the next ticket. I followed all the directions on adding the number to each ticket from the merge document (of course all the step by step information I can find is only for 2007 and NOT 2013 so guessing there is something wrong with what I am doing).  When I go into the print screen it is also changing my paper from 8 1/2 x 11 to 11 x 17 and putting 8 on the page.
If you’re producing any kind of numbered items in-house that are multiple-up on a sheet where you need to control all the variables to meet your production needs, the autonumbering feature through numbered lists is the way to go! Just step and repeat away & InDesign will do all the work. No need to fool with a seperate “numbers” file or deal with a data merged document. I think it’s by far the best option for basic numbering.
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.

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.


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

I am printing many pages of tickets. Each page has 5 tickets and I would like to sequentially put a number on each ticket. I have tried to use the auto page numbering feature but that is putting the same number on each of the 5 tickets and then increments for the next page -- not what I need. Also, can the numbering not suppress the leading zeroes? Thanks.
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.
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.
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.

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.
This video gives and example of raffle ticket printing using number pro with InDesign to create the numbering needed for 200 tickets. From creating the data file needed to laying out the document and finally the finished file ready for printing. Number-pro is an easy to use, stand alone application that can be used with InDesign, Corel Draw, Word, Publisher and any other desktop publishing or graphics software that
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.
Create your first ticket, without the numbering. Then where you want the number to appear first, press Ctrl-F9 to create a pair of field braces (ie '{}') and fill in between them so that you get '{SEQ Ticket \# 00000}'. Then, where you want the duplicate number to appear, create another field and fill it it so that you get '{SEQ Ticket \c \# 00000}'. From there it's mostly just a matter of duplicating the whole ticket however many times you want. When you're done press Ctrl-A to select the whole document, then press F9 to update the fields.

I thank you for your explanation. I also do tickets in a similar manor. I use excel to create the numbers as well. I create a 4 column set of numbers and assign each column to the ticket positions from left to right (four up tickets) on an 8.5 x 11 sheet. I merge the numbers to the tickets and send to print. With Indesign the numbers are able to print from last to first(printing face up, normal order, collated). They then come out stacked in order so that we simply cut and stack each column one on top of the other to complete the number set in order. I am going to try the threading technique you mentioned.
• 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.

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
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.
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
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.
Drag the number, which Publisher defaults to “1,” into place on the ticket. To change the sequence, such as to start with “100” instead of “1,” click the “Page Number” button again and choose “Format Page Numbers.” Click the “Start this section with” radio button and type the new number into the field. Click the “OK” button to have Publisher update the ticket number.
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?
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.
     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.
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.

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.
Microsoft Publisher offers many design tools that let you create any type of publication or document. You can essentially make anything in Publisher, including tickets. The easiest way to make tickets in Microsoft Publisher is to download a ticket template from Microsoft Office's website and modify it in Publisher with your own text, colors and graphics. These steps can be used for creating tickets in both Microsoft Publisher 2003 and 2007.

Am I the only individual here who is using CS3, and trying the method described, only to find that my version (5.0.2) for the mac doesn’t have the options anywhere that the author suggests? I have spent the past 2 hours trying to find the same screenshots the author has, only to become reall discouraged. Perhaps he is using a windows version that is setup differently?


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