What is the best way to set up a document to do this without having to manually enter 300 numbers? The best way to handle this depends on whether you’re using CS2 or CS3. I much prefer the CS3 method.
I’m struggling with this as well. I tried creating a .txt file of sequential numbers 1-99 from Excel and brought it in as a datamerge. My tickets are 8″x3″, 3-up, but when I did the merge, InDesign added 3,416 pages. Where the Hell is THAT coming from?? Any clue what I’m doing wrong? I’m using a tutorial that is using CS5, but I don’t see how that has anything to do with all those bloody pages.
2: Cut and Stack within Data Merge using a script I’ve made for the task: Episode 9: Cut and Stack Assistant script – YouTube (the script is available from my website https://colecandoo.com/downloads/ for FREE).
Next we will import our pre-designed raffle image. For the purpose of this tutorial we will be using a pdf that was created using Adobe Illustrator (Download pdf File). Place this pdf into the document by going to (File > Place) browse from the file and click Open.
Second, customize the raffle ticket so that it is specific to the event. There is enough space to include the top three raffle prizes along with the name of the organization and the event information. It is simple to add these details in Publisher.
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.
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.
This video gives an overview of how to use Corel Draw and layout and number raffle tickets using Number Pro to create the data file for the numbers needed. This video covers how to import a data file previously created with number pro and positioning the numbers on the raffle ticket file that was also created prior and imported as an image file. To learn how to create a data file with the raffle ticket numbers you want to use – check out http://www.number-pro.com or search for How To Use Number-Pro here on youtube. As always more info can be found at http://www.number-pro.com
Brilliant! I followed your instructions to the end, though I had to Google how to do a mail merge in Publisher 2010. But, with your help, I now have gorgeous raffle tickets of my own design! Thank you 🙂
(If you prefer using the keyboard, rather than the mouse, then do this instead of dragging down: select cell A2, hit CTRL+C to copy, then select cell A3 and use SHIFT+PageDown to select all the way down to row 500. Then hit CTRL+V to paste.)
Printing raffle tickets on the back: The price is $15 per 1000 raffle tickets. If you want a logo or artwork printed on the back of the raffle tickets upload your artwork with your order and enter “print logo on back”: in the “back lines” section. You will receive an email proof before your raffle tickets are printed.
Online Proof: Our online proof is there to give you an idea what your tickets will look like. If you’re not happy with the proof just tell us to send an actual proof (Our Artists have a lot more flexibility then the online proofing). If you’re adding a logo there is no need to request a proof. In either case complete your order and you will receive a proof the next business day.
Annabelle – You need the tickets in the top slot of each page to run from 1 to 167, then the second slot down to be 168 – 335, then have 336 – 500 in the third slot. Easiest way to achieve that would be to create a your list of numbers in Step 3 in Excel so it runs as 1,168,336,2,169,337 … etc., like this:
Now, what if you want to create multiple tickets for your organization? It is a really hassle free and easy process. Once you have done with your editing and typing of the document, you just need to copy and paste the complete word template over and over again to generate multiple tickets.
3. Modify any template text with your own custom text by clicking the template text to select the text box. Drag your mouse over the text to highlight it, then begin typing your own text. Your text replaces the template text. To change the text font, highlight your text and go to the ‘Home’ menu. Select the font you want to use from the drop-down font menu.
Thank you so much for this! These instructions were perfect and clear, and I got it all done, except when I go to print. It prints out 1 per page. I have Word 2007, and tried printing out on letter size with 4 per page, but then it prints them all very tiny in the corners. Can you help me? Thanks 🙂
Making a set of raffle tickets is exceptionally easy to do with our Microsoft Word based raffle ticket template system. Simply download one of our raffle ticket templates to your computer. Next, open the raffle ticket template in Microsoft Word. At this point you can customize your raffle tickets by adding/editing text material.
Perforate your tickets. Printed tickets are more uniform, so it works in your favour if you’re a little more professional with them. Perforating your tickets means you’ll be able to tear them each off quickly. Perforating tools are spindled wheels that poke holes evenly in a line. Run them between tickets like you would use a pizza cutting wheel. Cut your tickets out into rows and perforate the border between each ticket.
It appeared designed for variable numbers in one place. My customer needed her tickets numbered in two places, on the ticket and on the stub. Because she needs them tomorrow there is no time to send them out to be numbered manually. I’ll keep watching this space for more info. Thanks folks.
I don’t want to have to data entry to finish each line. Will take forever. Is there a way to get a same, same format in microsoft word. I have used a sequence number generator to get a list. Its the comma and second duplicate # that is the problem.
There is a good chance that the digital printer that you will use, has a cut and stack imposition method. This is a method that replicates Peter’s description, except it is done at the RIP and automatically. If this is the case, all you would need to do is supply a file from your data merge (20,000 single pages), and the imposition is taken for you.
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.
Once you have your new blank document, go to File… > Page Setup… to set the correct size. You want to set this to the size of your raffle ticket, not the size of paper you are printing on. You probably want 4 raffle tickets per page, so if you are printing on A4 then set the size to 20cm wide x 7cm high, with 1cm margins:
The four templates with automatic serial numbering are quite nice and one of them will most likely be suitable for your needs. You can edit them as well. If you’re going to do that, save the original template separately. Doing so will give you a fresh template, in case you need one.
Nicole – I’m not sure. Are the page and margin settings (from step 1) definitely correct? If each ticket was a little too big, so that only two tickets could be fitted on each sheet of paper, http://thedailyrant.net might create the problem you’ve experienced. Other than that, I’m baffled …
(These instructions are for Microsoft Publisher. Instructions for printing raffle tickets using Microsoft Word are here. Or use this special online raffle ticket program which is much easier than Word or Publisher!)
Once you are happy with your basic layout, copy everything three times so you have a page of four tickets. At this point, they won’t be numbered tickets just yet, you will add the numbers in a moment:
If you got to the end of these instructions, then well done you! If skipped to bottom, then maybe consider trying this online tool to design and print your own raffle tickets without battling with Excel and Publisher! You can design awesome tickets and print them at home, just with a few clicks, all in your web browser:
With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. Learn more about Allen…
I work at a quick copy shop as the in house designer. They JUST moved from manual numbering to digital and each job keeps building and getting worse since I brought digital numbering to their attention. I mean it’s super easy if there’s one number but two per ticket and 8 up? It’s hard with limited tools but doable.
Learn how to sequentially number tickets in multiple locations like tickets that have a stub. This can be done using most popular desktop publishing software like Indesign, Word, Publisher and CorelDraw and Number Pro. You can learn more, try the demo, watch instructional videos or send questions at www.number-pro.com
It depends what the design is for the tickets. But if you set up primary text frames, linked for the area for the numbers, you can create a numbered list with the numbering format you want. Then, just pour in a whole load of paragraph returns that have that numbered list applied. And make sure each numbered paragraph is set to start in the next column.
I use a little program called “Number It” I purchased on E-bay a couple of years ago. It will print the ticket (from bmp file) and number on the Canon 3200 in one pass. BW or Color. Nice little program and well worth the $50-80 price.