
Do the same for the second ticket number placeholder. Select it, click Insert Merge Field > Ticket. Our raffle ticket templates have a placeholder for a ticket number, usually “xxx” to remind you it needs to be replaced.When presented with the list, select the Ticket numbers.xlsx file you made earlier. Click on Select Recipients > Use Existing List.Change that by clicking on Start Mail Merge > Labels > Cancel. You’ll see that the “Update Labels” is grayed out. Once you’re finished with the design, go to the “Mailings” ribbon to start the mail merge.We’ll roll out this design to other tickets later, so if you decide to make changes (to the text, font or color), do it here. You’ll still need to make some changes before you can create your own tickets. You can use them as they are or modify them as desired. Template Design FileThis is a Microsoft Word file with the ticket designs. There’s a small icon in the bottom right corner that reads “Auto-Fill Options.” Click it and choose “Fill Series”.To fix this, use the autofill feature which is explained next. All cells should now have the same number in them. Since we’re making 40 tickets, drag down all the way to cell A41 (40 tickets, plus your heading row). Drag it down, making a note of the line you’re on.

The cursor will change to a solid black T or “+” sign. Select the cell, and then move your cursor to the bottom right corner of the cell.In the example, we’re using 1 as the first of 40 tickets. Enter the first ticket number in cell A2.These raffle ticket templates come pre-filled, but you have to option to change the ticket numbers by following these directions. Ticket Numbers FileYou can number your tickets using this spreadsheet. If your tickets are $5-10 each, each buyer will likely purchase no more than two. If you price your tickets at $1 each, expect each buyer to purchase from one to five tickets. The lower the price of each ticket, the more tickets you’ll sell. You don’t want to price them too high so that many people would find it too expensive. You’ll need to decide on a selling price. Besides being easy to award the prize, it also eliminates the hassle of securing merchandise. To make your raffle give-away as easy as possible, consider the 50/50 raffle, where 50% of the proceeds generated from ticket sales goes to the drawn winner of the raffle, and 50% goes to the organization raising the funds. They’re generally willing to do that because they understand the goodwill that is generated from their contribution efforts. Many community businesses will donate prizes for the raffle all you have to do is ask. Some states have a list of prohibited items, such as animals and alcohol, so check the laws in your area to ensure that you comply. He types of organizations that can benefit from raffle ticket sales include:
