All the remaining pages should pop off just how you want it. If you continue to have issues and want me to look at it you can pm me a link to the file and i’ll steer you in the right direction. You are 95% of the way there.
You create a numbering macro in Excel. I have mine set-up so I can do multi-up NCR crash numbering and still be able to cut & stack the output. Raffle tickets would be just as easy. PM me with your e-mail and I will send you my excel file.
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.
Select the Text Tool (T) and start dragging a text box that will wrap around the whole ticket including the crop marks. This is very important since the Data Merge will automatically calculate the duplication. Then open up the Text Frame Option (Command + B) and set the Inset spacing to 1p4 for the top and 1p8 for the left. Of course, you can place the text for the numbers anywhere you like. I set the numbers to a small text.
The only minus: Corel Corp don’t heard about the breacking of Berlin Wall and eastern european characters don’t work. Yes, i now, Alex post an solution in VBA in his former Yahoo group. I have a script too.
Click Numbering in the Paragraph group. In Word 2003, Numbering is on the Formatting toolbar. At this point, you have a one-column table with one hundred rows displaying a sequential list of 1 to 100.
On an e-ticket receipt, the airline code and ticket number is located at the bottom center of the receipt. In this example, you would enter 2150030834 in the ticket number box. The 001 is already provided to the left of the box if American Airlines is selected as the airline flown. Enter the 3-digit airline code preceding the ticket number if any other airline is selected. The 4 at the end is for internal use only.
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.
This is a step-by-step tutorial of how to number your raffle tickets. It is also a great way to learn how to use Microsoft Word’s Mail Merge functionality. When you are going through, there are many times when dialog boxes or other pop-ups may occur. Be sure to read on to the next step, as most of the time there will directions on what to do next.
Use the navigator on the right hand side and choose Edit All to make changes to all your tickets, such as changing the overall text style and size. Choose Edit One to make changes to individual tickets.
To make more numbers, just duplicate this frame. Every time you make a new frame, InDesign increments the number automatically. Note that in the following image, the frames are not threaded together: Master Pages You may be tempted to place this number on a master page.
Below are 15 printable ticket raffle templates which are easy to use and customize. You’ll find choices for basic business types and kid-themed tickets as well as templates for multiple prize options. Simply find a raffle ticket template that you like and that fits your overall purpose, and make the necessary changes. It’s all that easy. You might have to take a trial-and-error approach to DIY printable raffle tickets, but once you get the hang of the process, you can use the same format as much as you like. How do you go about sequentially numbering for your raffle tickets? You can do sequential numbering manually, or you can use Microsoft Excel in a mail-merge type of operation. If you’re not sure how to go about the mail-merge, the directions are above in the Template Design File section. Once your tickets are printed, then comes the task of cutting and perforating the tickets so that you can easily tear the ticket from the stub. It’s not as hard as you might think. With a full-size paper cutter and an inexpensive tracing wheel, you can easily complete this part of the job. To make it a community effort, get help from your fundraising colleagues. A morning spent on this task — with the enticement of coffee and doughnuts — will fly by when you’re having fun with other people.
You probably know about Word’s mail merge feature, and you might even use it to print labels or other documents, where some of the information changes (such as form letters). You can use sequential numbering same feature with Publisher. Although you might not think of Publisher as an Office app, it comes with several different versions of Office. In this article, I’ll show you how to print sequentially numbered tickets using Publisher and Excel. This article provides instructions for Publisher 2007, 2010, and 2013.
The first thing you need to know is how many tickets you plan to put on a page. That determines the number of columns, or fields, you need in the data file. Next you need to divide the total number of tickets (20,000 in this case), by the number of tickets per page. Round up to the next whole number. This is the number of rows, or records, in the data file. Each record represents a single page in the merged file.
Contact a manufacturer. Whether you’ve found a local ticket producer or an outlet online, you need to get a hold of them before you can order your tickets. Online companies will have their contact info somewhere on their webpage. Drop them a line, introduce yourself and let them know you’re interested in purchasing raffle tickets. Be sure to let them know roughly how many tickets you’re looking to buy, as well as the date you want to have them by. A representative should respond within a business day to take things forward from there.
I used the CS3 directions to number 500 tickets both at the top and bottom of each ticket 4 up on a page. This method worked great and really didn’t take very long at all. I dudplicated several spreads at a time to create my 125 pages of tickets ( 4up = a total of 500 numbered tickets). Thanks so much for the help!
2. Edit the Template to meet your needs. To replace a template graphic with your own, click the graphic to select it, then hit the ‘Delete’ key. The template graphic disappears. Go to the ‘Insert’ menu, select the picture or clip art command, then browse to the image you want to place on your ticket. Click the image to add it to your raffle ticket.
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.
Now for the slightly hard bit. If you just try and complete your merge now, you’ll get several pages of tickets. Each page will have four tickets on it. But all tickets on any page will have the same number. Each page will have a different number, but all the tickets on that page will have the same number. That’s no good. You need each ticket to have a different number.
If you’d rather make your tickets from scratch, take advantage of Publisher’s “Insert” tab to add your own images or draw from the “Shapes” collection. Add the numbers in the same way, starting with Step 3.
TicketBench Enterprise allows you to design and print event tickets, raffle tickets, or any document that requires you to combine text, graphics, serial numbering, reserved seating, and other variable data. Print Tickets like the pros with Ticket Bench Enterprise on your computer.
I am trying to create raffle tickets, 4 on a page with only a number on the stub. My problem is when I get to the print preview and change it to “multiple pages per sheet” it is just changing the number on the next page and not on the next ticket. I followed all the directions on adding the number to each ticket from the merge document (of course all the step by step information I can find is only for 2007 and NOT 2013 so guessing there is something wrong with what I am doing). When I go into the print screen it is also changing my paper from 8 1/2 x 11 to 11 x 17 and putting 8 on the page.
Fill in the information. Much like making your tickets by hand, you’ll need to input information for the tickets. Because you’re doing it via computer, it will be faster to make the tickets consistent. Write in the basic information into the template you’re using. The individual ticket number can be either written in or sequenced via a program like Microsoft Publisher. Although specifics will vary between raffle events, here are some things you’ll absolutely want on each ticket:
First, create a numbering “list” by choosing Type > Bulleted & Numbered Lists > Define Lists. Then click New to create a new list. You can name it anything you want, but make sure the Continued Numbers across Stories is enabled:
The four templates with automatic serial numbering are quite nice and one of them will most likely be suitable for your needs. You can edit them as well. If you’re going to do that, save the original template separately. Doing so will give you a fresh template, in case you need one.
The background image has a size of 22p5 by 5p6. You can choose any size as long as it fits onto your page. To fit the Rectangle Frame to the background image, select the Option + Command + C. This fits the frame to the content.