A very common usage for the Print Merge function in CorelDRAW is for adding numbers to tickets or invoices. Unfortunately it can be a bit of a hassle to create the list of numbers. When you have multiple tickets on a single printed sheet, it becomes even more complex as you want each stack of tickets to be in numerical order.
I am printing many pages of tickets. Each page has 5 tickets and I would like to sequentially put a number on each ticket. I have tried to use the auto page numbering feature but that is putting the same number on each of the 5 tickets and then increments for the next page — not what I need. Also, can the numbering not suppress the leading zeroes? Thanks.
My only argument against Data Merge for numbering tickets is that it takes far longer (for me, at least) than this numbering feature. However, if you had multiple pieces of data (not just numbers) that needed to change from ticket to ticket, then Yes! Data Merge or XMPie or InData or something like that would likely be better.
You have 2 options depending on your needs. If your background image is the full 8 1/2″ x 11″ size, then you can simply go to Format>Background>Fill Effects (this may be different on newer versions of Word). This will insert an image behind the entire document. When printing, you will need to make sure the background printing checkbox is ticked. If you need to insert an image into each box, you will then need to use text boxes with no fill to place text over the images.
When you have multiple tickets per page, you need to use a different numbering scheme. This link show how to use a merge with an Excel spreadsheet to create incrementing numbers: Publisher Auto-number Tickets Here’s another page on the same topic: Numbered Tickets in Publisher
If you got to the end of these instructions, then well done you! If skipped to bottom, then maybe consider trying this online tool to design and print your own raffle tickets without battling with Excel and Publisher! You can design awesome tickets and print them at home, just with a few clicks, all in your web browser:
3. Click with your cursor in the top left of the ticket on the template (if you have chosen a template with multiple tickets per page). Click inside one of the text boxes on the ticket and type a number, such as 0001.
Using Pub 2002, is there a way to create a merge and print tickets (3-up) with numbers on the main part of the ticket and the same number on a tear-off portion to use for prizes? Hi GG (email@example.com), in the Microsoft� newsgroups you posted: || Using Pub 2002, is there a raffle ticket numbering in word to create a merge and print tickets || (3-up) with numbers on the main part of the ticket and the same || number on a tear-off portion to use for prizes? http://www.mvps.org/publisher/numbering6.html See if the above link helps. — Brian Kvalheim Microsoft Office Publisher MVP Official Publisher MVP Site: http…
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 …
(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.
Update the sequence of numbers of copied tickets by highlighting the number and clicking on the right button of your mouse. A drop-down menu will give you the option to update the field and the system will automatically update the number in sequence. Each ticket must be individually updated before printing.
wow, what a relief to find these solutions! I had to gang 250 stickers on a single page and number them sequentially (so, page numbering and master page solutions wouldn’t work). The tips for Indd ‘numbered lists’ worked like a charm, even tho I’m in CS5. This was a lifesaver; MANY thanks!
Microsoft Publisher offers many design tools that let you create any type of publication or document. You can essentially make anything in Publisher, including tickets. The easiest way to make tickets in Microsoft Publisher is to download a ticket template from Microsoft Office’s website and modify it in Publisher with your own text, colors and graphics. These steps can be used for creating tickets in both Microsoft Publisher 2003 and 2007.
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.
You’ve got some tips to help make your raffle more successful. You’ve got several free Word ticket templates to choose from. You know how to sequentially number tickets in two different ways. All that is left for you to do is go sell those tickets, have the draw, and then feel good about helping someone out. All for pennies on the dollar over ordering custom made tickets.
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.
I’ve described how to do this using Data Merge a number of times, including in post # 6 at I need to number 20,000 tickets in InDesign and have them in order when I cut them where I describe how to do it for stack-cut imposition without a plugin.
Any time you want to produce another batch, open the document, press Ctr-A, then F9 and input the starting Ticket #. Simple. Alternatively, if you have Word configured to update fields at print time, just print the document. When you do so, you’ll be prompted for the starting # and Word will take care of the rest.
I answer readers’ questions about Microsoft Office when I can, but there’s no guarantee. When contacting me, be as specific as possible. For example, “Please troubleshoot my workbook and fix what’s wrong” probably won’t get a response, but “Can you tell me why this formula isn’t returning the expected results?” might. Please mention the app and version that you’re using. I’m not reimbursed by TechRepublic for my time or expertise, nor do I ask for a fee from readers. You can contact me at firstname.lastname@example.org.