It’s pretty easy in Excel. Take your number of tickets you’ll get on a sheet, divide 20000 by that number. That will be your number of rows. Type a 1 in the A1 cell location, type =(A1+1) in the A2 cell location. Paste that in as many rows as you determined. Copy the last cell in your first column. Paste that in cell B1. Copy B1 and paste in as many rows as you had in Column A. Copy column B and paste in column C. Copy C and paste in Column D. Repeat as many times as you have tickets on a sheet until you have enough columns as you do tickets on a sheet. Save as Tab deliminated text and bring into data merge on an imposed sheet. Data http://ringringpromotions.org should be able to build you a document easily with as many sheets as you need and on a 1 knife trimmer you should have neatly stacked tickets in order.
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 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!
It’s a random number generator that can pick the numbers for your raffle. It’s specifically designed for raffles that use cloakroom style tickets. Main features: – It can be used to pick the numbers for up to 500 prizes. – Each prize can have a description attached which is displayed along with the number.
After you set up your list of tracking numbers in the data source and design your publication, you are ready to merge your list of tracking numbers with your publication to create a batch of gift certificates or coupons that each displays a unique tracking number.
The SEQ or Sequential Numbering Function in Word is the best and quickest way to number your tickets. Many raffle ticket templates use them, yet few sites explain how it works. To see if it uses the SEQ function, you need to download the template first. Then, open it in Word, click right in the middle of where a serial number is, and then right-click.
I am using your instructions to create a page of tickets – the design has been created as a picture so I added a text box to “hold” the mail merge instructions but I keep getting the error message “You cannot include DATA, NEXT, NEXTIF, or SKIPIF fields in comments, headers, footers, footnotes or endnotes.” I have not included any of these but I’m wondering if it’s because I’ve attempted to insert it in a text box. Is there an easy way to do this? TIA
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.
Does anybody have an easy way to set up sequential numbering in Coreldraw? Our shop has to lay out unit number plaques for vinyl cutting and sometimes my employee has to manually type in hundreds of numbers. I’ve read all the print merge suggestions for raffle tickets and such but I need the numbers entered into an object and not during the print process.
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.
WordTemplatesBundle.com currently has 6 different templates available for free. Two of them are run-of-the-mill tickets that would be great for things like an office or classroom draw. The other four are the ones that are most helpful as they do automatic serial numbering.
For those who would prefer a standalone program with even more features, you can get the commercial version ($10) of Numbergen from MacroMonster. You’ll note that the sequence of numbers can be formatted for either CorelDRAW or Microsoft Word. If you do any numbering, you’ll find the commercial version well worth every penny.
Raffle tickets are a fun and easy way to raise money for an event. Whether it is for a fund-raising event, a family reunion or an office Christmas party, raffle tickets are fun ways for people to participate in the greater good with the possibility of winning a cool prize. Raffles can be private, organization based, local or worldwide events. How Raffles Tickets Work The event will set up certain prizes. Raffle tickets are then sold, and the people told to […]
I need to number 20,000 tickets in InDesign and have them in order when I cut them, I know there is a way to use data merge or something. I just can’t get it to work. Any help would be greatly appreciated.
Numbering of the raffle tickets can be quite a challenge but one can still manage to do this. You could accomplish this by manually numbering the raffle tickets. Alternatively you could use a software program such as Microsoft Excel through a mail-merge operation to number the raffle tickets.
Is there a script out there that you can define the font, size and numbering sequence for Corel? I work for a real estate company and I have to cut 0-500 in various sizes and increments. Sometime the numbers will always end in a Letter (A) or even end with the same numer ( 5001, 5011, 5021, 5031) and so on.
PrintMeister – Starter Kit of blank pre-perforated door hangers, bookmarks, raffle tickets, calendars and post cards, printed samples of all stationery formats and color swatch booklets showing paper types and colors. Also includes laminating pouch samples of and for bookmarks and wallet size calendars.
1. Create a text frame on the Master page, while dragging, split the frame horizontally and vertically using arrows on the keyboard (Gridify your frame), this way all frames are threaded, you may do the same on both pages of the Masters (Spread) but make sure you link last frame of left Master page and first text frame of right Master page.
Now you are ready to begin inserting your data. To make everything easier, please be sure to have your Mail Merge Toolbar visible. You can enable it by going to Tools > Letters and Mailings > Show Mail Merge Toolbar (displayed in step 3 of this document)
My solution for this when trying to add a number on a page between already existing numbers where to usa a current text frame of the previous number and create a new list object from there. And then I would overset that text and press the overset +-sign to place it on the page. Works perfect.
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.
Add unique numbers to gift certificates By using a unique number on each certificate, you can track when gift certificates are redeemed, by whom, and for what product or service. In addition, by adding unique tracking numbers, you can ensure that the gift certificates are not duplicated or redeemed more than once.
Open your Layers window. If it is not already open, open it by going to (Window > Layers). Rename the layer with the placed pdf ‘Background’ and then create a new layer and name it ‘Numbering’. Lock the ‘Background’ layer. Then select the ‘Numbering’ Layer.
(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.
Hi Cathy – I’m not sure what would cause that to be honest. Because (even with these instructions!) it can be quite hard to get Word to do this right, I did build a little web-based service to do the same thing. Have you tried that? http://app.raffleticketcreator.com
Rather, I was just admitting that I had no idea why someone using CS3 would not see the dialog boxes as they are shown above. If you’re using CS2, they would be significantly different. But the second part of the tip (where I show the numbering dialog boxes) relies on CS3 or later. If you are using CS3 or CS4 and you don’t see that dialog box, feel free to email me at david [at] indesignsecrets [dot] com and send me a screen shot of what you are seeing. The script that Mike referred to worked very well with CS2 and was fairly easy to extend to doing counterfoil numbers as well, but doesn’t seem to work with CS3. I have thrown together a small online script to generate the contents of a data source file to do ticket numbering through the normal CS3 InDesign data merge routine.
There is very simple solution that we use and that is to lay out the sheet say 6 up on a A4 sheet as a master page and in document setup set the number of pages to 1,000 if that is the amount you require. Put a page number on each ticket on the page and although they will all have the same number on each page, we put the the first two letters of the customers business name before each number followed by the letters of the alphabet so it then reads for example BT1A, BT2A, BT3A, BT1B, BT2B, BT2C and so on as each page is printed.
When you are ready to print, you will need to either merge the data to a new document or straight to your printer. I recommend merging to a new document so you can preview the entire thing before printing. The icons look like (Merge to Document, Merge to Printer)