MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Formulas, Functions and Visual Basic procedures on this web site are provided “as is” and we do not guarantee that they can be used in all situations.
12. To build the document, you will add the first merge field, the room number. To do this, choose Room from the Field list box, and click Insert Print Merge Field. This will place the variable on the document. Next, choose Subject from the Field list box, and click Insert Print Merge Field once more. Now both variables are inserted in the CorelDRAW document.
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.
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.
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.
Grocery stores: A folding table and a couple of colorful posters are all you need to set up an attractive display outside of a grocery store or supermarket. People are going inside to shop, so they have money.
Annabelle – You need the tickets in the top slot of each page to run from 1 to 167, then the second slot down to be 168 – 335, then have 336 – 500 in the third slot. Easiest way to achieve that would be to create a your list of numbers in Step 3 in Excel so it runs as 1,168,336,2,169,337 … etc., like this:
Of course, there are third-party solutions that are available for creating sequentially numbered labels. One that comes highly recommended by several WordTips subscribers is Bates Labels from Payne Consulting (http://www.payneconsulting.com). This free Word template allows you to easily create as many labels as you need for a specific purpose.
This video gives an overview of how to use Corel Draw and layout and number raffle tickets using Number Pro to create the data file for the numbers needed. This video covers how to import a data file previously created with number pro and positioning the numbers on the raffle ticket file that was also created prior and imported as an image file. To learn how to create a data file with the raffle ticket numbers you want to use – check out http://www.number-pro.com or search for How To Use Number-Pro here on youtube. As always more info can be found at http://www.number-pro.com
You can request us to change the stub ie, instead of Name, Address and Phone ADMIT ONE, name and date of your event. (This is helpful if you are pre-selling your tickets because your seller can retain the stub portion for record keeping. If you prefer no stub, place your order and select “tickets with no stub”. In either case, your proof will show a standard stub but your Admission Tickets will either have no stub or one with the information you requested.
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.
If you’re intent on doing your tickets by hand, it’s recommended that only one person make them. That way, the handwriting will be consistent for each one, and it will be easier to spot a dupe if one occurs.
nstantly create Raffle Tickets quickly and efficiently on your Windows PC. No prior knowledge of printing or computers is necessary. Use plain paper and cut tickets apart yourself or use our pre-perforated paper for a professional appearance.
Go to “Format” and “Background” to change or add a background to the ticket. The options for the different types of backgrounds will appear in the box on the left side of the screen. Click on one to apply it to the ticket.
4. Stop dragging when you’ve selected enough numbers. Note that while you’re holding the mouse button down, a tool tip will appear nearby displaying the number you’re up to. If you’ve gone too far, simply mouse back up.
Next we will import our pre-designed raffle image. For the purpose of this tutorial we will be using a pdf that was created using Adobe Illustrator (Download pdf File). Place this pdf into the document by going to (File > Place) browse from the file and click Open.
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 sequential numbering in word Mailings > Show Mail Merge Toolbar (displayed in step 3 of this document)
I work at a quick copy shop as the in house designer. They JUST moved from manual numbering to digital and each job keeps building and getting worse since I brought digital numbering to their attention. I mean it’s super easy if there’s one number but two per ticket and 8 up? It’s hard with limited tools but doable.
This simple raffle ticket design made of two parts. Top part (ticket) is very basic, and the space is limited to the name of your raffle event. Bottom part (coupon) is for the participants who do not need to fill in their information (name, address and phone number).
Yes, it is a pain to reprint one or two sheets if you have closed the file. I’ve learned to leave the file open on the desktop until the tickets are finished. This way if the perf, or cutter messes up I can easily reprint those ticket numbers without re-aligning the art & numbering.