I had wanted to create a file that didn’t require Excel as the data source, so I created one using SEQ fields. It was terrible and too huge to mention (thanks Doug Robbins), so I recreated it using Word as the data source so that people who only have Word can use it. You can create up to 5,000 tickets without changing the data file. If you only have Word and need to create more than 5,000 tickets, please don’t type the ticket numbers. Just drop me an email and I’ll create another data file for you with the required numbers.
We had some computer crashes here. Long story short I did a restore and then of course my Outlook is asking me to activate. I had purchased an 2013 addition of Office on line a few years ago.When it a… read more
Next, choose a font and font size for the number (select the code with your mouse and change the font), and add other body text and formatting. Finally, merge the label, card, or sheet “x” times with the LABLCOPY macro (found here in the Library). You’ll get consecutively numbered labels/cards/sheets — as many as you need.
Number-Pro makes numbering raffle tickets and forms easy using your desktop publishing software like Indesign, Microsoft Word and Publisher and Corel Draw. Number Pro creates a data merge file based on your numbering requirements that can easily be integrated into the desktop publishing software that allows for printing directly to your small business or home printer.
You do not need to be a registered charity to run a raffle/lottery, however they cannot be run for private or commercial gain. You will need to set up as a society if you are looking to be registered or licensed as a ‘small society lottery’.
Create a raffle ticket template in Microsoft Word. Word allows you to generate text boxes for this purpose. Simply create two separate text boxes—one for the main ticket and another smaller one for the stub—and place them side-by-side on a page. Enter your raffle ticket information inside of each of the text boxes, then copy and paste the boxes throughout the page to complete your template.
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.
4. Save your raffle tickets, then purchase the appropriate size raffle ticket card stock from an office supply store. The item numbers for Avery brand are listed with the raffle ticket template, but any brand matching the size of your raffle ticket will do.
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.
You don’t have to be a born salesperson to move all your tickets, but the better your sales tactics, the more successful you’ll probably be. Peter Kajanzy teaches how to crush a sale with pro techniques. One bit of advice he offers: When people ask for the price, instead of doing a complex breakdown of one for $2, three for $5, and so on, go straight to “You can buy five tickets for $8.” Generally, you don’t want potential buyers to have to do a lot of math in their heads. Make it easy on them by offering a bundle price. Other tips to help you sell include perfecting your sales pitch:
1. Start Microsoft Publisher. Click inside the small field with the magnifying glass in the middle of the Available Templates page, then type “tickets” and click the magnifying glass icon. Review the Publisher ticket options, then double-click a template, such as “Raffle Ticket,” to open the design in the Publisher window.
1. Create a new Excel spreadsheet. 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.
You’re here because you are trying to do something good for someone in need. The world could use a few more people like you. Yet fund raising, even on a small scale, still takes a lot of work. If you’ve decided a raffle is the way to go, we’re here to help.
The tickets were printed exactly as ordered and arrived on the day they were scheduled to. We are very happy again with the high quality nature of the printing and the material the tickets are printed on, even with choosing the least expensive options. We’ll be back next time we need tickets!
Choose from the list the raffle ticket template you are most likely to use. If you don’t find any that quite matches the design that you had in mind, we have blank raffle ticket templates with which you can design yourself.Download them. All the items on the compilation we have presented are all made by professional graphic designers, so some of them may come at a cost or require you to sign up. Nevertheless, the overall style of your makeup is bolder and edgier.Customize the template with the the color, text, images of your choice. Some raffle ticket templates come packaged with stylistic alternatives for color, font, images, and backgrounds. They are high-res, so they come in vivid colors and image the integrity stays the same when these templates are printed in various sizes.
The problem with your document is that you have put everything into textboxes instead of into the table cells you have below them. You also don’t need the \* MERGEFORMAT switch that every SEQ field in your document now has.
Open Publisher and click on File… > New to create a new blank document. Depending on your settings, you’ll get a bunch of options here with different templates and sizes. You just need to create a new blank document, it doesn’t matter what size because you are going to change the http://sl-inworld.com in a minute.
Good morning! Directions are clear for sure but when i go to merge the first ticket is one but the second number on the raffle ticket is two. i have four raffle tickets per page the first three are messed up but the forth is correct all the way down to 500. Any ideas? i have tried with a header and without a header. i even made the first number with a formula. it does work with out putting next record but like you said it is four tickets with the same number and that would use a ton of ink. Any help would be greatly appreciated.
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: