You don’t have to be a born salesperson to move all your tickets, but the better your sales tactics, the more successful you’ll probably be. Peter Kajanzy teaches how to crush a sale with pro techniques. One bit of advice he offers: When people ask for the price, instead of doing a complex breakdown of one for $2, three for $5, and so on, go straight to “You can buy five tickets for $8.”
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.
I have done this twice now, getting flustered. The ticket part the person keeps has the correct sequential number on it, but the side that we keep has the same number on it for the whole page. What part am I missing, at first I did not uncheck the box, but this time I did but have the same number on the stub side that we keep with the person's name, etc
I basically used Bob Levine’s method (thanks) but wanted to add some extra detail – am using CS2 which is somewhat behind CS3 in this area. David, I was very discouraged to read your response to Josh on April 28th 2008. It seems your comment was quite dismissive to him with exactly no feedback help. He seemed to be looking for some more help trying to work through what you and the other InDesign gurus discuss as a “simple process”. I to, have read through your directions while using both mac & pc platforms. I fail to find the “standard features” screen shots that you show above in either program. I too have spent several hours trying to get the sequential 3-up numbering as described.
The ticket numbering problem seems solved, if awkwardly. But what about linking automatic numbering of text references to a figure (e.g. “see fig.101″) to a legend of that figure (e.g. Fig. 101 shows….”)? 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!
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.
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.
So we came up with a way that when each stack was cut they would simply be stack on top of each other. We couldn’t figure out a way to add 8 sets of grouped numbers to 8-up layout so I had to go into the txt file and number it manually. It worked fine but took a little time. Is there an option to pull 8 different sets of numbers to one page? 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.
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.
Getting Word to put a unique number on each raffle ticket is easy enough, but persuading Word to print out several uniquely-numbered raffle tickets per sheet of paper is very hard (I think it is impossible, actually. At least I couldn't figure it out. UPDATE: I did figure it out. Instructions for printing raffle tickets using Microsoft Word are here.). And you don't really want to have every raffle ticket use up a whole sheet of paper.
1. On the first hand, you need to initiate Microsoft Publisher. You can view a magnifying glass icon and you need to hit inside the little field which shows Available Templates page. Now you should type the Word ‘tickets’ and move your cursor towards the magnifying glass icon. Hit on it. Subsequently you need to evaluate and assess the ticket options in the Microsoft Publisher. After that you can double click on the desired template. For example if you want to open the raffle ticket template just double click on it for the Publisher to open it for you.
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.
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!!