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.
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!
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.
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.
Layout your ticket in InDesign, one on each page, using the Page Number function to number the tickets. If you have something like Imposer Pro (I know it doesn't work from InDesign CS3) you can, for instance, impose the pages 4up consecutive and get 4 tickets on an A4. Alternatively, make a PDF of the whole document and impose (manually, if you have to), the advantage here is that this can work as a template for other tickets, simply make a new PDF of the same size and update the PDF in the template document every time you have a new raffle ticket to do.

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.
After dealing with the numbering problem, you also need to end up with single raffle tickets from the stub. The cutting and perforating bit can be quite a hustle depending on the number of raffle tickets that you are planning to sell. But this is something that can be done by one individual who is dedicated. All one would require is full size paper cutter together with an inexpensive tracing wheel to get over this stumbling block in whole process. You could also choose to enlist a group of people to help you out in this to finish this in a timely manner.
Your raffle might be subject to gaming commission or tax laws. Check with your municipality, state or province, and federal governments to make sure your raffle is legal. These government departments aren’t just enforcers. They are often great resources on how to run a successful fund raising raffle. Raffles are fun! Getting in trouble with the law or tax man is not.
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.

I came across this website that explained how to do it using Microsoft's "Raffle Ticket" template (https://www.techwalla.com/articles/how-to-create-numbered-tickets-in-word). However, when I tried to update the sequences as the article said, I could not find the option to update the field (I think they were referring to the option "edit field"), after copying and pasting the template onto a second page.
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.
Remember that you must update the values in the sheet if you want to continue the numbering series with the next batch of tickets. For instance, if you want your next batch of tickets to start with 112, you'd open the workbook and change the value 100 to 112, and update the remaining values accordingly. Don't forget to save the workbook after updating the values.
The SEQ or Sequential Numbering Function in Word is the best and quickest way to number your tickets. Many raffle ticket templates use them, yet few sites explain how it works. To see if it uses the SEQ function, you need to download the template first. Then, open it in Word, click right in the middle of where a serial number is, and then right-click. how to number raffle tickets in publisher
×