This post will show you how to create printable numbered raffle tickets at home.





> STOP PRESS: You can use this online tool to design and print your own raffle tickets <

(Or read on to learn how to do it manually in Publisher!)









1. Create your raffle ticket in Publisher

Too much like hard work? Try this online tool to design and print your own raffle tickets without battling with Excel and Publisher!

2. Create a list of raffle ticket numbers in Excel (or another spreadsheet program).

3. Add the numbers to your raffle tickets in Publisher





C'mon, this is crazy-complicated! Save yourself a few hours and try this tool which lets you to design and print your own raffle tickets online. Print them at home, as many as you need.

Or, read on for the rest of the do-it-yourself-the-hard-way instructions. ;-)





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:











You've found this post, so you already know creating raffle tickets to print out yourself is harder than it sounds.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 wasMy first thought:Turns out it took the best part of an afternoon.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.). And you don't really want to have every raffle ticket use up a whole sheet of paper.But you can do it with Microsoft Publisher. Here are the step-by-step instructions: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 size in a minute.Once you have your new blank document, go to File... > Page Setup... to set the correct size. You want to set this to the size of your raffle ticket,the size of paper you are printing on. You probably want 4 raffle tickets per page, sothen set the size to 20cm wide x 7cm high, with 1cm margins:If you are printing on Letter size paper, then use 7.5" wide, 2.5" high and margins of 0.5":Now add text and maybe a logo to create your raffle ticket. Remember to:- Include a ticket stub which you can tear off- Leave space for the raffle ticket number (we'll be adding that in a moment)- 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. Open Excel and create a new workbook. In cell A1, type the number "1" (without quotes) (or another number, if you want to start your numbering from a different number):In the cell below, type "=A1+1" (without quotes) and hit enter/return:That'll put a 2 in that cell, like this:Now click the tiny black square in the bottom right of that cell, keep your mouse button clicked and drag down for as many rows as you need raffle tickets:... all the way down to (say) 500 rows (to give you 500 unique ticket numbers):Now save your spreadsheet somewhere you can find it again, and close Excel.Return to Publisher and click on Tools > Mailings and Catalogs > Mail Merge...A big panel should appear on the left hand side of the screen.Check that "Use an existing list" is selected, then click "Next: Create or connect to an existing list":Navigate to where you earlier saved your raffle ticket numbers spreadsheet and click Open:On the next screen, be sure to, then click OK:Just click OK on the next screen:Now you need to put a ticket number placeholder on your raffle ticket. Click where you need the raffle ticket number to appear, then click "F1" in the left hand panel:Repeat for the stub, to print the ticket number there also:Now, down the bottom of the lefthand panel, click "Next: Create merged publications":Then, click "Print...":Now, pay attention for this last step. Check all of the following:1. Select "Multiple Pages per sheet" (Multiple Copies per sheet)2. Choose the correct paper size for the paper you are actually printing on (A4 or Letter)3. Select "Portrait"4. Under "Page Range", click "Entries:" and type "1-4" (without quotes) (so you just print first four tickets for now, to check things over)5. Click "Print"Something like this should pop out of your printer. Four raffle tickets on a page, each with a different number:If you are happy with the results, click "Print..." again in the left hand panel:But this time set Page Range to "All entries":... and click the Print button, then all your raffle tickets will come out of the printer, each with a unique ticket number.Congratulations!