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.
publishing software and Number-ProCan I use a regular desktop printer for raffle ticket numbering? Absolutely!With desktop publishing software like Adobe InDesign, Microsoft Word, Publisher or any application that allows you to do a "merge" and a stand alone software application like Number-Pro (www.number-pro.com) you can print your own raffle tickets with numbering or any other document you want to be numbered.The ease of using Number-Pro is that it can be used with any software that allows a file merge. This includes but not limited to:Adobe Indesign

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'm not sure about using an open office version of excel would work the same but create a file with your numbers in it starting with 0000 or however many 0's you need then click and hold in corner of cell and drag down, should auto populate. Document must be Saved As "text (tag delimited)" keep clicking ok. Save it this way only when completed somewhere you'll remember. Now go to inDesign and create one ticket. Add a text box and open data merge, navigate to the number file you just created and click/double click (don't remember) and an "options" box will open. This is where you setup your page size, bleeds, etc., I know multiple pages has to be checked. I think you can preview from this too and make necessary adjustments.

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139
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.
12. To build the document, you will add the first merge field, the room number. To do this, choose Room from the Field list box, and click Insert Print Merge Field. This will place the variable on the document. Next, choose Subject from the Field list box, and click Insert Print Merge Field once more. Now both variables are inserted in the CorelDRAW document.
In Excel, I created a file with columns A-H labeled: ticket 1, stub 1; ticket2, stub2; ticket3, stub3; ticket4, stub4. I then numbered two rows across 1 -4, then 5 -8. Then I dropped down to A – H in row 260. (I did this to give 1,000+ numbered tickets.) I then used the Excel fill function chosing series and told the program to skip by 4. It filled the rows. I then saved as a tab delimited text file.
12. To build the document, you will add the first merge field, the room number. To do this, choose Room from the Field list box, and click Insert Print Merge Field. This will place the variable on the document. Next, choose Subject from the Field list box, and click Insert Print Merge Field once more. Now both variables are inserted in the CorelDRAW document.
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.
Given that Word can support 2,147,483,647 SEQ fields, the whole job could be done in a single document containing 30,000 tickets. On my system, creating such a document took only a few minutes and, once created took about two minutes to update the fields - and that was with about 40,000 pairs of SEQ fields coded as {SEQ Ticket \# 00000} and {SEQ Ticket \c \# 00000}. This number formatting is enough to go to 99,999 tickets.
You’ve got some tips to help make your raffle more successful. You’ve got several free Word ticket templates to choose from. You know how to sequentially number tickets in two different ways. All that is left for you to do is go sell those tickets, have the draw, and then feel good about helping someone out. All for pennies on the dollar over ordering custom made tickets.
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.
Thank you again for your assistance. I took care of the text boxes and everything works quite well. I had some aggravating moments trying to figure out where the \* MERGEFORMAT switch was coming from; I kept deleting it and it kept coming back like a mosquito. I assume it had something to do with the text boxes. Anyway, the document is now a thing of beauty. Thank you.

We use the auto page numbering trick here, the trick is to do it as spreads. You just make your pages the same size as the ticket with crops and bleeds. Then set up the shell on the master page and place your auto page number where you want your numbers. Each pages is the next number. You can also have two sets of numbers for perforated ticket. You then can use the page start options to add to the numbers and keep the same number of total numbers. For example you would do a new page start after number 99. 0001 to 0099 so it doesn't add two "0's" to the front of 100 and you get 00100 when you want 0100. Works great for small quantities, we have done up to 1000+ tickets and once you do it once or twice it is a snap to set up. To avoid having to do 1000 pages just send the tickets in groups. Usually between 25 to 100 at a time works good depending on artwork file size. Just save each time before sending to printer and name the file with what the tickets are. Like "MyTickets-0001-0100.Indd". Makes it easier to go back if you have a problem. You can even do two rolls of tickets if your using 12 x 18 sheets by flipping the sheet and doing one row along the top and one along the bottom on reverse side. That is if your ticket is single Sided. Two sided tickets are a bit trickier. :-)
In Excel, I created a file with columns A-H labeled: ticket 1, stub 1; ticket2, stub2; ticket3, stub3; ticket4, stub4. I then numbered two rows across 1 -4, then 5 -8. Then I dropped down to A – H in row 260. (I did this to give 1,000+ numbered tickets.) I then used the Excel fill function chosing series and told the program to skip by 4. It filled the rows. I then saved as a tab delimited text file.
Pink order (#2) - Ordered these again, even though I wasn't impressed with the first round because they were cheap and they serve the purpose we needed for work. But this time we ordered pink and the new set is beautiful! Lines on back for address/name/phone# seems original order isn't from the same printing company maybe? Nothing stamped made in USA on blue set or Indiana ticket Co. This order has both. The punch outs are not on this roll at all, which is perfectly rolled up, no folded rows. So we're not using the rest of the blue order that we had and instead going forward with these.
Word templates are wonderful things. Microsoft, and hundreds of other people, have created some great free templates for almost everything. With these free templates you can make meeting agendas The 15 Best Meeting Agenda Templates for Microsoft Word The 15 Best Meeting Agenda Templates for Microsoft Word These meeting agenda templates for Microsoft Word can get you off to a great start for any type of meeting. Read More , beautiful flowcharts How to Create Stunning Flowcharts With Microsoft Word How to Create Stunning Flowcharts With Microsoft Word Used with imagination, flowcharts can simplify both your work or life. Why not try out a few flowcharts with one of the easiest tools on hand – Microsoft Word. Read More , professional resumes How to Create a Resume Template with Microsoft Word How to Create a Resume Template with Microsoft Word Your resume could be the difference between interviewing for the job of your dreams or never hearing back from the employer — use these tips to make sure it's the best it can be. Read More , and custom calendars 10+ Sites to Find the Perfect Free Printable Calendar Template All Year Long 10+ Sites to Find the Perfect Free Printable Calendar Template All Year Long You can never have enough reminders that your most valuable personal resource is limited. Our selection of printable weekly, monthly, and yearly calendars will help you manage your time wisely. Read More in minutes. A custom calendar might be a good fundraiser, too!
×