This application creates a data file that can be used with Indesigns Mail/data merge feature that easily allows for numbering raffle tickets and documents and even allows for numbering in multiple locations that is often needed on raffle tickets that require a numbered stud.
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.
10. Back in the document, select your dummy number in the first ticket. Click the button ‘Insert Merge Field,’ then select the one entry in the drop-down menu, which will be the first number from your spreadsheet.
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. Here’s a file with 1,197 numbers in it. 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 insert your ticket numbers, first click the area where you want the number to go. Then, click on Insert Merge Fields. A Dialog will pop up and “Numbers” should be selected. Click OK. You should see “<>” inserted into your document. You can insert the <> anywhere you want on the ticket and as many times as you wish.
In this example, I will create a set of plates that will be put on each classroom door in a local high school. All plates will have the same logo, but each plate will have a different classroom number and subject.
Mail Merge continues to be one of the most powerful, yet misunderstood Microsoft tool. Learn how easy it is to use a simple table and the label merge type to create customized sequentially numbered raffle or admission tickets. See www.sandymcvey.com for practice files and contact information.
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.
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, that might create the problem you’ve experienced. Other than that, I’m baffled …
Unfortunately, InDesign isn’t exactly speedy at updating these numbers when you add a bunch of pages. But it’s not hard to duplicate and reduplicate until you have a thousand or more numbered tickets.
Thanks very much for your prompt reply, which reassured me that I was on the right path. From having read various Help topics, I suspected that I’d have to use an Excel data source for the numbers. Fortunately, my knowledge of Excel was good enough to know about the drag and drop facility to create automatic sequential numbering, so the data source creation was easy. In the end, it was the mail merge (no surprises?) which proved a tad tricky, but I got there in the end. I’ve used MM many times and quite happily in Word documents, but for Publisher label format, it was of course a bit different. The important bit that I had to discover for myself was the significance of, after getting to the Print stage, going into Print options, to Publication & Paper Settings, and selecting Multiple Pages per Sheet (& in my case, also “Single-sided” cos my default of duplex printing had come up). But TA-DA! All is fine now. Thanks very much again.
Once you click on this icon, a dialog will pop up asking you what data you wish to merge. You can either merge all the data (All numbers in the excel file), current record (just 1 sheet), or select a range. I recommend selecting a range, as the Excel file packs contains numbers up to 10,000.
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.
At this point of time, do not forget to bring up to date the series of numbers of tickets already copied. This can be achieved by just highlighting the number and hitting on the right side of the mouse. The word document will let down a drop-down menu that will provide you all the necessary options to revise and keep up to date the field.
Summary: If you need to include serial numbers in your printed matter (labels, letters, documents, etc.), the best way is through the use of Word’s mail-merge sequential numbering in word This tip outlines how you can use this capability to get just the serial numbers you need. (This tip works with Microsoft Word 97, Word 2000, Word 2002, Word 2003, and Word 2007.)
Neighborhood businesses: The shops and stores in your own community are great places to start selling your raffle tickets. These are locales you frequent, where you know the owners and are able talk to them while you’re there. The more familiar you are to them, the more likely they’ll support your fundraising efforts and will be willing provide a selling spot for you.
• On the document page, override the items by Command/Ctrl-Shift-dragging over them (or clicking on them). • Select that one page and duplicate it in the Pages panel, or by choosing Layout > Pages > Duplicate Spread. • Select the original page and the duplicate and then copy those. Repeat this (select pages and duplicate) until you have enough pages. Unfortunately, InDesign isn’t exactly speedy at updating these numbers when you add a bunch of pages.
5. Currently you can pull the default number “1” which Microsoft Publisher shows and put it on your ticket. Don’t forget to hit on the OK tab which makes the publisher to update the event ticket number without any errors.
(Advanced) opens the Filter and Sort dialog box, which you can use to filter using multiple criteria. You also can click Filter under Refine recipient list in the Mail Merge Recipients dialog box to open the Filter and Sort dialog box.
Please join our friendly community by clicking the button below – it only takes a few seconds and is totally free. You’ll be able to ask any tech support questions, or chat with the community and help others.
Most changes you make to the top ticket are automatically made on all the other tickets, too. No tiring copying and pasting needed. The template shows just 5 tickets, but once you have them looking the way you want, just multiply them using copy and paste.
If the second number on your raffle ticket is one higher than the first number, you must have accidentally put the <> tag after the first number (causing the next number, on the same ticket, to increase by one). You only need the <> after the second number on each ticket, so the next ticket gets a new number. (But you don’t need it on the final ticket on the **page**, because the next **page** automatically gets a new number)
To make sure people get their prizes, give them lots of room to print their name, address, and phone number. Some people are leery about giving out their address, but do make sure you get a printed name and phone number.
Receive and unpack your tickets. The tickets normally come wrapped coil and will most likely be perforated. You should leave the coil wrapped until it comes time to sell the tickets so you don’t lose any.
You need to create a list of numbers using some method (maybe even through VBA) as a text file, database or other data source, then just insert merge field in the document and use Print Merge to generate multiple labels with different numbers in it. (just need to give it enough space to fit the longest string along as many lines as you think there could be) If I reserve space for 50 chars and the major strings are 25 chars, the result is not professional looking. My solution for all print merge for ID cards (and similarities, incl. Auto numbering) is to merging data BEFORE printing, in an CDR file with all pages. So, I check all the cards and I correct only on text object how need. I found an software with this capabilities, but 300 USD is excesive (not only for Est Europe) for one only week of working (yes, his UI is better than my). I found an software with this capabilities, but 300 USD is excesive (not only for Est Europe) for one only week of working (yes, his UI is better than my) And my script use photo also.
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.” Generally, you don’t want potential buyers to have to do a lot of math in their heads. Make it easy on them by offering a bundle price. Other tips to help you sell include perfecting your sales pitch:
If you’re planning to sell tickets prior to the event and the proceeds (from ticket sales) for a single draw are not anticipated to exceed £20,000 then you must register with your local authority as a ‘small society lottery’. You would need to pay a small fee and comply with a range of regulatory requirements including providing entrants to the lottery with tickets stating specific information (see below) and preventing children under the age of 16 from participating. If the proceeds for a single draw were to exceed £20,000 you would require a ‘large society lottery’ licence from the Gambling Commission.
That would make sense, but there’s a catch: Autonumbered paragraphs on a master page don’t update until you override them. That is, you have to Command/Ctrl-Shift-click on them to make them “kick in” and update to the correct number.
Create a new document in Word, and set up one ticket to occupy about one quarter of the page. Just use tabs and line breaks to format the text, don’t use text boxes. And leave some space to put the ticket numbers in later. You might end up with something like this:
Got it to work! I modified my spreadsheet and added a header row with the words “Ticket Number” in field A1. Then I left the checkbox checked when I imported the spreadsheet to Word. That seemed to make it happy. THANK YOU!! This was so helpful!!
Thank you for these clear instructions. I have had the same problem as Mommy Vaughan and followed the suggestion. However, on re-opening the Word document, I have the dialogue box Invalid Merge Field. I have to use Task Manager to close down Word. I am using Word 2010. Maybe that is part or all of the problem. Any ideas please? I need to sort this by tomorrow night to print them on Monday!
The raffle ticket paper is pre-numbered and pre-perfed and is available in two different sizes (Large Tickets – 2 3/4″ x 8 1/2″, Small Tickets – 2 1/8″ x 5 1/2″) with 20 different paper colors for each size.