(If you prefer using the keyboard, rather than the mouse, then do this instead of dragging down: select cell A2, hit cmd+C to copy, then select cell A3 and use SHIFT+fn+down arrow to select all the way down to row 500. Then hit cmd+V to paste.)
Number-Pro can be used to create unlimited amounts of the numbering mail merge file you need. This is great for small print shops, non profit organizations that do there own tickets. Using your own home or office printer you can number your own raffle tickets.
Simply copy the second page of the template by highlighting that page and pressing CTRL + C. Windows shortcut keys Windows Shortcuts 101: The Ultimate Keyboard Shortcut Guide Windows Shortcuts 101: The Ultimate Keyboard Shortcut Guide With so many shortcuts built into Windows and its software, it might seem impossible to learn them all. Here’s the ultimate guide to the most useful keyboard shortcuts. Read More are wonderful things. Then create a new blank page by pressing CTRL + Enter. Then paste the copied page using CTRL + V. Create a new blank page, and paste again. Keep doing this until you have the desired number of pages that you will need.
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, http://ringringpromotions.org 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.
In the example I explained, I was using a list, but did it with un-linked text boxes using “continue from previous number” and “continue numbers across stories.” I’m guessing that there is no way to tell InDesign that even though there are 4 text boxes on the page, that there are two different lists? I’d probably have to just create two threaded stories for that scenario to work.
Use CorelDraw to layout the raffle ticket template. You can use the label design tool (located under “Page Setup” on the “Layout” menu) to create a raffle ticket template. For instance, if you choose a label template with four boxes in a row, the first and third boxes contain the raffle ticket while the second and fourth boxes represent the ticket stub. After choosing your desired label size, enter text and images to create the custom template, then print the document on card stock paper instead of label paper.
– Include any legal wording your local regulations require (in the UK, you’ll probably need a license from your local council, and include details of that on the raffle ticket. More about that here.)
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.
Based loosely on how many tickets you hope to sell, enter a number in cell A1. Standard raffle practice tends toward numbers with at least a few digits, so instead of starting with 1 you might start with 10001.
Create excitement for your event with professional-looking tickets you can make yourself. Avery Tickets with Tear-Away Stubs are easy to design and customize with free templates on Avery Design & Print. Add your logo, event name, date and time, and even sequential numbering to keep track of tickets for admission, VIP passes, fundraiser raffles or prize drawings.
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 the 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.
Now repeat for the second and third tickets. But not the fourth, because that’s at the end of the page, so Word will skip to the next number anyway, because the next page always gets the next item in your merge list. Your document should look like this:
Now for the tricky bit. Mail Merges usually have the one ‘recipient’ per page. So Word won’t pick out the next number in your list until it gets to a new page. By default, it’ll print you four tickets on each page, all with the same number. Then a new page, all with the next number. Etc.
This program makes you adept for not only creating event tickets but also generating attractive resumes and different menus. What you need to do is to find the appropriate Microsoft template and include the desired texts in the blanks available. The program then allows you to opt for the color of your choice .subsequently you can either save the template as a file or you can click on the print right away.
It is recommended that you provide the time and venue of the show unless you have a fixed location for the movies. By providing these details you will save yourself the stress of having to persuade watchers to pick up the movie tickets.
Create the sample label so that it has the word Exhibit followed by a merge field that represents the number being pulled from the Excel worksheet. Make sure the label contents are formatted the way you need them.
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
In trying to produce 300 tickets, I can get all of the first numbered position to be sequential over 100 pages. But, when moving down to the second or third ticket position on the page and setting up the numbering, I repeatedly find that I get a repeat of the first 100 numbers. I am lost as to how to proceed. Is there any other missing step or info that I am assumed to have knowledge about that was not mentioned above? If you know of some other site that might explain this process any better, please post.
I am using my all-time favorite graphic creation program (better than Adobe Illustrator or Corel) in creating stickers with serial numbering. Have a look on how user-friendly it is and very easy to use. If you want some tips and techniques similar to this, just ask, subscribe or comment on it.
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.
A few days ago my wife asked me if I could help her print out raffle tickets for our local kindergarten quiz night. She had this Word document, with the raffle tickets neatly arranged on the page and was about to start typing a unique ticket number on every ticket. All 500 of them.
At this point, you’re ready to load your card stock into the printer and print the tickets. I recommend that you preview the print job before sending it to the printer to make sure everything’s in order. To print the tickets, do the following:
If you have already developed a set of specific code numbers that you want to use to track and categorize customer responses, you can type these numbers into a column of the data source that you plan to use for the mail merge.