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.
I had wanted to create a file that didn't require Excel as the data source, so I created one using SEQ fields. It was terrible and too huge to mention (thanks Doug Robbins), so I recreated it using Word as the data source so that people who only have Word can use it. You can create up to 5,000 tickets without changing the data file. If you only have Word and need to create more than 5,000 tickets, please don't type the ticket numbers. Just drop me an email and I'll create another data file for you with the required numbers.
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.
I’d like to share my solution. It came to me partially in my sleep, I tried refining it this morning but because of time, finally had my production person print the manually numbered tickets so that we could deliver them to the customer who needed them today. Here is my solution. I deduced that it would be better to let a program designed to count, do the counting. I used Excel. I then let InDesign CS4 do the merging. Here’s the formula.
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.
Open a new blank document in Word. Create two raffle ticket designs, one for the person who buys the ticket and one for the organization selling them. Make sure to connect the two tickets, for example by making them in two-cell tables, side-by-side. Include the name of the organization, perhaps the first prize, and any other information you want on the buyer’s ticket. You might, for example, include spaces for the buyer’s name (“Name__________”) and phone number on the organization’s ticket. On both tickets, enter a dummy number for the raffle ticket number as a placeholder.
Microsoft Publisher, the desktop publishing component of the Professional version of the Office Suite, can perform many time-saving tasks for busy business owners, including layout and design work. It can even help you avoid a shopping run to try to find tickets for your next employee picnic, holiday giveaway or executive board meeting. Create your own tickets, including the vital sequential ordering needed for raffles or attendance tracking, using Publisher’s page numbering. With a few tricky manipulations of the page number process, you can start running the numbers in an entirely new fashion.
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.
The very first step you need to do is to drag your cursor towards the Help icon in the new word document. This icon usually appears in the right part of the top portion of the tool bar listing. It is depicted by a question mark symbol. You have to left click on this menu with your mouse and you need to opt from the type of help listed in the drop-down carte du jour. (Ticket Invitation Templates Download)
I would like to number a voucher book, i have place 4 vouchers on a page, the thing is that i want each of these vouchers to start with different number, 100, 200, 300, 400, and then i want to number them 99 times. The problem is that they have to be numbered only 1 per page, so that when i have printed them all i can easily crop them and staple them right up with having to go through it all.
Create a master frame in ID to hold the number and if I have more than one ticket on a page just link the frames. Apply a paragraph style that starts in a new frame for the numbers. Place the text file with a shift click and the numbers are formatted and the new pages are autoflowed. The number list is very easy to create in Excel with the auto fill feature for that type of thing.
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.
Thank you for these instructions!! I'm using them to auto number my son's baseball team raffle tickets which we hand numbered last year (UGH!). I followed the instructions exactly but for some reason the numbering is starting at 2 every time. I did deselect the checkbox about the column headers which seems the obvious culprit. Any ideas? I'm using Word on a PC. Thanks!!