tag:blogger.com,1999:blog-47089418172572382612024-03-13T13:40:45.630-07:00Raffles and Raffle TicketsTips and advice on running raffles and printing numbered raffle tickets.Bruce Ghttp://www.blogger.com/profile/09056360686702009784noreply@blogger.comBlogger23125tag:blogger.com,1999:blog-4708941817257238261.post-66752351330774595462018-11-15T02:02:00.000-08:002018-11-15T02:02:47.203-08:00One Secret Tip To Create Awesome NUMBERED Raffle Tickets in Word<h2>
Discover how the little-known SEQ command in Word lets you really easily create numbered raffle tickets yourself at home. You don’t need Excel for this method.</h2>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<h4 style="text-align: left;">
Step 1: Create your basic ticket layout in Word</h4>
<div style="text-align: left;">
Either download a template from the internet, or create your own layout. Remember your ticket will probably need a ticket stub where you write the name of the purchaser. And your ticket stub and the main ticket will need to have the ticket number printed on them. Obviously all the tickets need a different number, but we'll come to that in just a moment. Here's my layout:</div>
<div style="text-align: left;">
<b><br /></b></div>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh2xIbrYgW_xjIBQEUMbPWHG5FmJJk6DInfe64wMy6PPNkBypBzcC0dxdvB36EItbJpHY1GMz3q95p2oDNbvLXa4Em1RJmo-1MQqfcVJOVd5za-skHnApxonlb5Pm_vlb3PebaWBPzOP78/s1600/Step+4+-+Check+that+ticket+number+appears.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="700" data-original-width="1508" height="296" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh2xIbrYgW_xjIBQEUMbPWHG5FmJJk6DInfe64wMy6PPNkBypBzcC0dxdvB36EItbJpHY1GMz3q95p2oDNbvLXa4Em1RJmo-1MQqfcVJOVd5za-skHnApxonlb5Pm_vlb3PebaWBPzOP78/s640/Step+4+-+Check+that+ticket+number+appears.png" width="640" /></a><br />
<br />
<br />
<br />
<h4>
Step 2: Select your typed ticket number and toggle "Field Code" mode</h4>
Select the ticket number you have typed and hit CTRL+F9 (Windows) or CMD+fn+F9 (Mac). This surrounds what you typed with a special pair of curly brackets. You can't just type these brackets directly - you have to hit CTRL+F9 (or CMD+fn+F9 on a Mac):<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjvX7mlUTNLLgVJaPQHWvILKc_4GmFUKNyhyphenhyphenV0xMjZQRgLimWc67jaRu-OMSK7VTmwtXUQzLIQ7YWzHk424D0RKGuNlAaoj1Zo9bmdb3OLnnDvOH1J7DejhVtrnFvr8HwWNntyWClP3L0o/s1600/Step+2+-+enter+field+code+mode.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="723" data-original-width="1513" height="304" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjvX7mlUTNLLgVJaPQHWvILKc_4GmFUKNyhyphenhyphenV0xMjZQRgLimWc67jaRu-OMSK7VTmwtXUQzLIQ7YWzHk424D0RKGuNlAaoj1Zo9bmdb3OLnnDvOH1J7DejhVtrnFvr8HwWNntyWClP3L0o/s640/Step+2+-+enter+field+code+mode.png" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<h4 style="clear: both; text-align: left;">
Step 3: Type the magic code!</h4>
<div class="separator" style="clear: both; text-align: left;">
Instead of '0001' (what I typed as the first ticket number), type this between the curly brackets:</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
SEQ 0001-1000 \# "0000"</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Make sure you leave a space at the start and end of this bit of code, so it will look like this on your screen:</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
{ SEQ 0001-1000 \# "0000" }</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEinsRIlHdg6lRcKVtjH8huub4Nl5mN9myT7GMZaxZjqv_SU1iSbHUupPBR0_TtXc_ozwhHVf9gf4hlj2B34RPVX-Sd3OsvFciGtv8eH_THaNHdiwrkCNQlu3QtW44p_-DZrhyMokVtM7EQ/s1600/Step+3+-+type+the+SEQ+field+code.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="696" data-original-width="1507" height="294" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEinsRIlHdg6lRcKVtjH8huub4Nl5mN9myT7GMZaxZjqv_SU1iSbHUupPBR0_TtXc_ozwhHVf9gf4hlj2B34RPVX-Sd3OsvFciGtv8eH_THaNHdiwrkCNQlu3QtW44p_-DZrhyMokVtM7EQ/s640/Step+3+-+type+the+SEQ+field+code.png" width="640" /></a></div>
<br />
This code will create numbers from 0001 to 1000. If you need a different range, just replace '0001-1000' with whatever you need, e.g. for tickets from 0599 to 1099 use:<br />
<br />
{ SEQ 0599-1099 \# "0000" }<br />
<br />
Don't worry that your layout will start to look messed up because typing the code pushes everything else around. Once you toggle the code back to displaying the ticket number, the layout will pop back into place.<br />
<br />
<h4>
Step 4: Type more magic to put the <i>same</i> ticket number on the other half of the ticket (you'll get a different number on each individual ticket in a moment):</h4>
Select where you typed the second number on the other half of the ticket and hit CTRL+F9 (or CMD+fn+F9 on a Mac) again. This time type the following between the brackets:<br />
<br />
{ SEQ 0001-1000 \# "0000" \c}<br />
<br />
Note the '\c' at the end - that indicates to Word to use the same number as on the other half of the ticket.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_MLXx7nRfagi7v1kwMt8TPjVwIy182xEsdvYcARbsBg4IM4X6eCPEvHB_-xBPPd3DEC8RomqPbvXZ-AIkJpJStHO0pQMn7JmzjF5cQU5-suWtf8OXp0OsmUf8HmLSNmpNvNPWaMdV7MQ/s1600/Step+5+-+Repeat+for+the+other+number+on+the+ticket.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="740" data-original-width="1508" height="314" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_MLXx7nRfagi7v1kwMt8TPjVwIy182xEsdvYcARbsBg4IM4X6eCPEvHB_-xBPPd3DEC8RomqPbvXZ-AIkJpJStHO0pQMn7JmzjF5cQU5-suWtf8OXp0OsmUf8HmLSNmpNvNPWaMdV7MQ/s640/Step+5+-+Repeat+for+the+other+number+on+the+ticket.png" width="640" /></a></div>
<br />
Again, don't worry that the code is messing up the layout and wrapping onto two lines. It'll sort itself out in the next step.<br />
<br />
<h4>
Step 5: Toggle your magic code back to displaying numbers.</h4>
Hit Alt+F9 (Alt+fn+f9 on a Mac) to toggle the display from displaying the field code to displaying the output of the code: your numbers.<br />
<br />
<i>Powertip:</i> Did the code just disappear and no numbers replaced it? Fear not. Hit CTRL+A (cmd+A on a Mac), then F9 (fn+F9 on a Mac). That will update your fields and you should see something like this again:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjdGmNlDZQNchjzhM5_35qBtAPjQcFn_sJjp4fmI42syCesqTYzZ5hgouwjcqbEFsXkv5STKOkXL7owv0JIqoxCJf14RHzUM2cVspCBQhX76AT2XHI05faagrep19UgOOn8XIjjSkg_r5w/s1600/Step+4+-+Check+that+ticket+number+appears.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="700" data-original-width="1508" height="296" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjdGmNlDZQNchjzhM5_35qBtAPjQcFn_sJjp4fmI42syCesqTYzZ5hgouwjcqbEFsXkv5STKOkXL7owv0JIqoxCJf14RHzUM2cVspCBQhX76AT2XHI05faagrep19UgOOn8XIjjSkg_r5w/s640/Step+4+-+Check+that+ticket+number+appears.png" width="640" /></a></div>
<h4>
<br /></h4>
<h4>
Step 6: Copy your ticket down the page</h4>
<div>
Now copy the whole ticket and paste down the page, so you have four tickets (or as many as you like - the numbering will work automatically).</div>
<br />
At first, the numbering won't look right, and every ticket will have the same number, like this:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiWMRPvf-6Odhxj5yM74Qsq-iTywJbeE3moKFXYHLgDRroNcOh3QaeLmnAsuceEHdnGo9v1DigCmavg7AZEevuxR2Wf2u5EGrqvwelKeiWNKs0qILcEwbIm2E8UKjmMSTrGbbMh_UPYMfM/s1600/Step+6+-+Copy+the+ticket+down+the+page.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="952" data-original-width="670" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiWMRPvf-6Odhxj5yM74Qsq-iTywJbeE3moKFXYHLgDRroNcOh3QaeLmnAsuceEHdnGo9v1DigCmavg7AZEevuxR2Wf2u5EGrqvwelKeiWNKs0qILcEwbIm2E8UKjmMSTrGbbMh_UPYMfM/s640/Step+6+-+Copy+the+ticket+down+the+page.png" width="450" /></a></div>
<br />
<h4>
Step 7: Update the fields</h4>
Hit CTRL+A (cmd+A on a Mac) to select everything. Then F9 (fn+F9 on a Mac) to update, and you should see a different number on each ticket, but each ticket will have the same number on the stub and the other half:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEguYc_v4WBJ9cEQf6mb0jloA2GUuMS3qyVEealzYyvd0iA4HXnMTV6i1H5zQ-QkHAON_lX7BRKAcJyIF4BtvERShL1XIMcHPFkvWC54LVGWP2kI8eoanbDqwy_hgV9lG-z88mlmosz3Kd8/s1600/Step+7+-+Update+the+field+codes.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="956" data-original-width="580" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEguYc_v4WBJ9cEQf6mb0jloA2GUuMS3qyVEealzYyvd0iA4HXnMTV6i1H5zQ-QkHAON_lX7BRKAcJyIF4BtvERShL1XIMcHPFkvWC54LVGWP2kI8eoanbDqwy_hgV9lG-z88mlmosz3Kd8/s640/Step+7+-+Update+the+field+codes.png" width="387" /></a></div>
<br />
<h4>
Step 8: Copy all this to get as many tickets as you need</h4>
Copy everything on your page and paste on a fresh page. Keep doing that until you have as many tickets as you need. The numbering will look wrong at first, but do the same update trick (CTRL + A, then F9) and it will sort itself out:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj42f-Z60RbBR4OpXj2V4KRBlHzbqqhHYkExqML0WeVL7VvulIzf9DObjSIYK4sw113EF8JYY1azdToUcFngyStFmdXl-apVi4kbq9zZOSlDO_N7UxCWd0pP4zt5l5lo-L05YQ0iR1pRAE/s1600/Step+8+-+Copy+as+many+tickets+as+you+need.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="925" data-original-width="582" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj42f-Z60RbBR4OpXj2V4KRBlHzbqqhHYkExqML0WeVL7VvulIzf9DObjSIYK4sw113EF8JYY1azdToUcFngyStFmdXl-apVi4kbq9zZOSlDO_N7UxCWd0pP4zt5l5lo-L05YQ0iR1pRAE/s640/Step+8+-+Copy+as+many+tickets+as+you+need.png" width="402" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
That's it. I've previously <a href="https://www.raffleticketcreator.com/2016/07/print-raffle-tickets-using-template-in.html" target="_blank">published instructions for making numbered tickets in Word by mail merging a list of numbers from Excel</a>, but this method is *way* easier!</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
*******</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
If this isn't working for you, or takes too much time, I have <a href="https://app.raffleticketcreator.com/" target="_blank">an online tool which automates the numbering of your raffle tickets</a> for you, try it out:</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://app.raffleticketcreator.com/" target="_blank"><img alt="" border="0" data-original-height="1017" data-original-width="1103" height="590" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqT9AQccRVrfuO5czuuBwvFDpwdCUHOxY0kx1GE45QDAd_Ob2ohJMYmS-b6XEa_lnVfPJNuoxLj69iILsUPV9okhoc1hp8P4m8_KRuoCUNP9yEC4o0qSxyFJeTdJJ5jQfuIHM5xt1iNIo/s640/Or+do+it+all+online+with+RaffleTicketCreator.png" title="Raffle Ticket Creator online app" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<br />
<div>
<br /></div>
Bruce Ghttp://www.blogger.com/profile/09056360686702009784noreply@blogger.com0tag:blogger.com,1999:blog-4708941817257238261.post-76971111683881233612018-11-14T05:49:00.000-08:002018-12-20T14:13:15.767-08:00Watch this one simple trick to create numbered raffle tickets in Word to print at home (Video Tutorial)<h2 style="clear: both; text-align: left;">
How do you use the SEQ function in Word to create numbered raffle tickets?</h2>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Short version: Create your ticket. Then enter this instead of the first ticket number on each ticket (e.g. on the stub): { SEQ 0001-1000 \# "0000"}. Then enter { SEQ 0001-1000 \# "0000" \c} for the second ticket number (on the main body of the ticket). Then copy your ticket as many times as you need: each ticket will have a different number, but the stub on each ticket will have the same number as the main body of the ticket.</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Watch the video to see exactly how this works:</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<iframe allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen="" frameborder="0" height="315" src="https://www.youtube.com/embed/ka1jzIpXWoY" width="560"></iframe></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Or use my online service: <a href="https://app.raffleticketcreator.com/" target="_blank">https://app.raffleticketcreator.com</a></div>
<br />Bruce Ghttp://www.blogger.com/profile/09056360686702009784noreply@blogger.com0tag:blogger.com,1999:blog-4708941817257238261.post-38040577700438832762018-03-19T03:56:00.003-07:002018-03-19T03:58:15.931-07:00Printing booklets of numbered raffle ticketsWhen running a raffle, you often sell tickets in booklets of 5 or 10 tickets. It is nice to have the numbers in these booklets running in consecutive order. So you have one booklet with ticket numbers 101-120, the next one 121-130 and so on.<br />
<br />
If you print out your tickets in straight number order, though, you can't easily compile them into booklets. You'll have something like this:<br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMbnA5Mhv1WnqZ0y7F0ZioIyu4S4blkvVQtJBpGfMQFfY60ZkVoVr_JnV3Cx-od9XOD5Po-7p2YyOaWnylBp8MoD7khUR3NYI-D8L3ha-m46IpEUecFSj-ZzW-1bWr-aG8e4pj6sTfOYM/s1600/IMG_1281.JPG" imageanchor="1"><img border="0" height="480" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMbnA5Mhv1WnqZ0y7F0ZioIyu4S4blkvVQtJBpGfMQFfY60ZkVoVr_JnV3Cx-od9XOD5Po-7p2YyOaWnylBp8MoD7khUR3NYI-D8L3ha-m46IpEUecFSj-ZzW-1bWr-aG8e4pj6sTfOYM/s640/IMG_1281.JPG" width="640" /></a><br />
<br />
<br />
This sketch shows four sheets of paper, each sheet having four tickets. If you stack the paper and cut off the top tickets to make a booklet, you'll end up with tickets 1,5,9 and 13 in that booklet. But you wanted tickets 1,2,3 and 4.<br />
<br />
Here's how to organise your numbering so that you can easily stack and cut the paper into booklets. You basically want tickets 1,2,3 and 4 in the top slot on each sheet. Then tickets 5,6,7 and 8 in the next slot down, and so on, like this:<br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgL4uI2li2i2h3_6mIE1eb56UHnuYV4j3gT6Nilc-cb-uI11z6eFKEVxZum9B9I4UdiY2Nl7l4NYn2Yy9zOWqd83bxXB1wGmfFSzRpuZqql17wpL20zsMb0X406t0Se_Tl-Adh2B_bB82w/s1600/IMG_1282.JPG" imageanchor="1"><img border="0" height="480" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgL4uI2li2i2h3_6mIE1eb56UHnuYV4j3gT6Nilc-cb-uI11z6eFKEVxZum9B9I4UdiY2Nl7l4NYn2Yy9zOWqd83bxXB1wGmfFSzRpuZqql17wpL20zsMb0X406t0Se_Tl-Adh2B_bB82w/s640/IMG_1282.JPG" width="640" /></a><br />
<br />
So your first <b>sheet of paper</b> has tickets 1,5,9,13, the next <b>sheet</b> has 2,6,10,14, and so on, which looks odd when you print it, but when you then stack the paper and cut the whole stack, you will have <b>booklets</b> of four tickets each with consecutive numbers.<br />
<br />
The exact order you need will depend on how many tickets you want in each booklet. That sketch shows the numbering for four tickets per booklet. But if you wanted ten tickets per booklet, then you'd need the first page to have 1,11,21,31, then the second page to have 2,12,22,32, and so on until your tenth page has tickets 20,30,40,50.<br />
<br />
If you are using my <a href="https://app.raffleticketcreator.com/" target="_blank">Raffle Ticket Creator</a> app, this is all done for you. Just select the booklet option on the final screen and specify how many tickets you want in each booklet and the app will create your tickets in the correct order for you:<br />
<br />
<a href="https://app.raffleticketcreator.com/" target="_blank"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwDExfunphZn_okLpBovDgSI4EnAn4xmTLKBBCsO79yHPz1eCaw8SHLECiZQ-vGCZbusJSYR_TWkqLtZL459i5eEEQyEkoKCE1yWOPM6SqtjRlYssRS_oAM41LQ4melFopzCsO2Q3CLhI/s1600/Screen+Shot+2018-03-19+at+10.54.28.png" /></a><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />Bruce Ghttp://www.blogger.com/profile/09056360686702009784noreply@blogger.com0tag:blogger.com,1999:blog-4708941817257238261.post-66758403416664000362017-11-27T06:46:00.004-08:002017-11-27T06:46:38.539-08:00SchoolStaffSurveys.com is a self-service web app to run a staff happiness survey in your schoolI know there are a lot of headteachers and school principals using Raffle Ticket Creator, so some of you might be interested in another little site I just launched:<br />
<div style="text-align: center;">
<span style="font-size: large;"><br /></span></div>
<div style="text-align: center;">
<span style="font-size: large;"><a href="http://www.schoolstaffsurveys.com/" target="_blank">SchoolStaffSurveys.com</a></span></div>
<br />
SchoolStaffSurveys allows headteachers, department heads and school business managers to easily run staff satisfaction surveys amongst their team of teachers.<br />
<br />
Why would you want to run a staff engagement survey in a school? Because you'll find out lots of things you didn't know before. And, as an extra bonus, your <a href="https://www.gov.uk/government/organisations/ofsted" target="_blank">Ofsted</a> inspector will love you (Non-UK readers: Ofsted is the government agency which inspects and rates each school every few years):<br />
<br />
<i>"Inspectors should consider any evidence the school has from regularly surveying staff ... Inspectors will always report on the school's activity to survey staff ..."</i><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhr1wHs-p_Gtgi8l8HiWXMpBweATht9SDQzfjinsWeWeJVSSjdcMBXFTg8nE3v77iEug3-Y2HKQ9tcbaBTzhPBY7j0VCdy0EXVhhoTZlxH8W36q-u1MsTDR0QPIn6lV80UbDfowtiVXM_Y/s1600/Ofsted+Handbook+Staff+Surveys.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="346" data-original-width="700" height="197" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhr1wHs-p_Gtgi8l8HiWXMpBweATht9SDQzfjinsWeWeJVSSjdcMBXFTg8nE3v77iEug3-Y2HKQ9tcbaBTzhPBY7j0VCdy0EXVhhoTZlxH8W36q-u1MsTDR0QPIn6lV80UbDfowtiVXM_Y/s400/Ofsted+Handbook+Staff+Surveys.png" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<i><span style="font-size: x-small;"><br /></span></i></div>
<div class="separator" style="clear: both; text-align: left;">
<i><span style="font-size: x-small;"><br /></span></i></div>
<div class="separator" style="clear: both; text-align: left;">
<i><span style="font-size: x-small;">(from the <a href="https://www.gov.uk/government/publications/school-inspection-handbook-from-september-2015" target="_blank">Ofsted School Inspection Handbook 2017</a>)</span></i></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
But of course it isn't just about an Ofsted inspection, its about doing the right thing for your team. However great your relationship with your staff, you can't know everything from everyone just from walking around and having regular chats. A formal survey is a super-powerful way to really get to the details of how effective your leadership is, and where you can work harder to improve.</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
School Staff Surveys uses the question set from the annual UK Civil Service People Survey. It asks about topics like:</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<ul>
<li><i>Is change managed well here?</i></li>
<li><i>Do you have confidence in the decisions made by the leadership team?</i></li>
<li><i>Is poor performance dealt with effectively?</i></li>
<li><i>Are you sufficiently challenged by your work?</i></li>
<li><i>How long do you plan to stay working here?</i></li>
</ul>
<br />
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
And so on. There are twelve sections, each with 5-10 questions. All laid out on a fast, responsive web page which your staff can access on their computer, tablet or phone.</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
You get to see everything in professional-looking graphs which you can share with your team and governors (if you want to!):</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjU6voHS3pvSeX82cyd6L2kU4DJiz7CXEITgPt7fIdkoP8t8ccc5mchmfrlc7ZOpdYb5ARbSCOau-FQERuMgbbuyFyiKJ9ToN-DigEFUsRpCKlzC32ZwQaVInLFoHYvUTc1Nh0RYfT29Mk/s1600/Example+Graph+of+School+Staff+Survey.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="515" data-original-width="557" height="295" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjU6voHS3pvSeX82cyd6L2kU4DJiz7CXEITgPt7fIdkoP8t8ccc5mchmfrlc7ZOpdYb5ARbSCOau-FQERuMgbbuyFyiKJ9ToN-DigEFUsRpCKlzC32ZwQaVInLFoHYvUTc1Nh0RYfT29Mk/s320/Example+Graph+of+School+Staff+Survey.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
So, if you are a headteacher or other school leader, maybe give it it try: <a href="http://www.schoolstaffsurveys.com/" target="_blank">www.schoolstaffsurveys.com</a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<br />Bruce Ghttp://www.blogger.com/profile/09056360686702009784noreply@blogger.com2tag:blogger.com,1999:blog-4708941817257238261.post-37212956373138117032017-04-28T07:30:00.000-07:002017-05-05T01:19:12.577-07:00How to make raffle tickets<h2 id="how-to-print-raffle-tickets">
How to make or print raffle tickets</h2>
<br />
<br />
<div>
There are basically three types of raffle tickets you can use in your fundraising event.</div>
<div>
<br /></div>
<div>
<h4>
Cloakroom tickets</h4>
These are rolls or books of small tickets, in pairs, each pair having a different number. You give one to the ticket buyer and keep the other to use in your lucky draw. This saves you making your own tickets, but they don't look as professional. You can buy these from a stationary store like Staples or Amazon:</div>
<div>
<br />
<blockquote class="tr_bq">
<ul>
<li><a href="http://amzn.to/2pfUhuV" target="_blank">Amazon cloakroom tickets</a></li>
</ul>
<ul>
<li><a href="http://www.staples.com/Staples-Double-Ticket-Roll-Red-2000-Roll-1-Roll/product_196972" target="_blank">Staples cloakroom tickets</a></li>
</ul>
</blockquote>
</div>
<div>
<br /></div>
<div>
<h4>
Make tickets at home</h4>
Here are some step-by-step instructions for making raffle tickets at home. You can use Word or Publisher, or an online tool like Raffle Ticket Creator:</div>
<div>
<br />
<blockquote class="tr_bq">
<ul>
<li><a href="https://app.raffleticketcreator.com/">Make Raffle Tickets online</a> (to print at home)</li>
</ul>
<ul>
<li><a href="http://www.raffleticketcreator.com/2014/01/print-numbered-raffle-tickets-at-home.html" target="_blank">Make Raffle Tickets in Word</a> (step-by-step instructions)</li>
</ul>
<ul>
<li><a href="http://www.raffleticketcreator.com/2012/02/print-raffle-tickets-on-your-own.html" target="_blank">Make Raffle Tickets in Publisher</a> (step-by-step instructions)</li>
</ul>
<ul>
<li><a href="http://www.hloom.com/free-raffle-ticket-templates/" target="_blank">15 Raffle Ticket Templates</a></li>
</ul>
</blockquote>
</div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<h4>
Custom printed tickets</h4>
Any print shop will make you some custom-printed tickets. In the US, allow around $50 for 1,000 tickets and allow a few days turnaround. Below are some online print services who make custom raffle tickets:</div>
<br />
<br />
<blockquote class="tr_bq">
<ul>
<li><a href="http://ticketprinting.com/">TicketPrinting.com</a> </li>
</ul>
</blockquote>
<blockquote class="tr_bq">
<ul>
<li><a href="http://admitoneproducts.com/">AdmitOneProducts.com</a> </li>
</ul>
</blockquote>
<blockquote class="tr_bq">
<ul>
<li><a href="http://raffleticket.com/">RaffleTicket.com</a></li>
</ul>
</blockquote>
<br />
<br />
<div style="orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-indent: 0px; widows: 2;">
<br />
<div style="-webkit-text-stroke-width: 0px; color: black; font-family: Times; font-size: medium; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: normal; letter-spacing: normal; text-transform: none; white-space: normal; word-spacing: 0px;">
<br /></div>
</div>
Bruce Ghttp://www.blogger.com/profile/09056360686702009784noreply@blogger.com0tag:blogger.com,1999:blog-4708941817257238261.post-41214909950146854832017-04-27T10:43:00.000-07:002017-04-28T08:55:35.213-07:00Running a fundraising raffle: the definitive guide<div class="tr_bq">
A fundraising raffle can be one of the most effective ways to raise money for your cause. You can usually get the prizes donated for free. Tickets are cheap and easy to print. The whole thing requires a lot less work and organisation than an auction or feeding a hundred people at a charity supper.<br />
<br />
If you sell $10-worth of tickets to one hundred people, that's $1,000 right off the bat.<br />
<br />
This definitive guide will give you all the tips and advice you need to run a successful, professional fundraising raffle.<br />
<br /></div>
The guide is divided into six sections:<br />
<br />
<blockquote class="tr_bq">
<a href="http://www.raffleticketcreator.com/2017/04/running-fundraising-raffle-definitive.html#how-to-get-great-prizes-for-your-raffle">1. How to get great prizes donated for your raffle</a></blockquote>
<blockquote class="tr_bq">
<a href="http://www.raffleticketcreator.com/2017/04/running-fundraising-raffle-definitive.html#how-much-to-charge-for-each-raffle-ticket">2. How much to charge for each raffle ticket</a></blockquote>
<blockquote class="tr_bq">
<a href="http://www.raffleticketcreator.com/2017/04/running-fundraising-raffle-definitive.html#how-to-print-raffle-tickets">3. How to get raffle tickets printed cheaply and quickly</a> </blockquote>
<blockquote class="tr_bq">
<a href="http://www.raffleticketcreator.com/2017/04/running-fundraising-raffle-definitive.html#raffle-laws-and-licencing">4. Make sure your raffle is legal!</a></blockquote>
<blockquote class="tr_bq">
<a href="http://www.raffleticketcreator.com/2017/04/running-fundraising-raffle-definitive.html#how-to-promote-your-raffle">5. How to promote your raffle</a></blockquote>
<blockquote class="tr_bq">
<a href="http://www.raffleticketcreator.com/2017/04/running-fundraising-raffle-definitive.html#raffle-social-media-tips">6. Contact the winners and announce on social media: best practice</a></blockquote>
<br />
Do you want to do the best job you can of running your raffle? If so, read on.<br />
<br />
<br />
<br />
<br />
<br />
<hr />
<br />
<h2 id="how-to-get-great-prizes-for-your-raffle">
1. How to get great prizes donated for your raffle</h2>
<br />
<br />
People buy raffle tickets for two reasons: to support your cause, and to have a chance of winning a nice prize. If you put effort into getting some really awesome prizes, you'll hugely increase your chances of selling more tickets. Remember local business want promotion. Offering you a prize worth $50 is a lot cheaper than an advert in the local paper. Here are some of the best ways to secure valuable prizes for your raffle.<br />
<a href="http://www.thefreewealth.com/how-to-get-raffle-prize-donations/" target="_blank"><br /></a>
<br />
<blockquote class="tr_bq">
<ul>
<li><a href="http://www.fundraiserhelp.com/fundraising-auction-donations-sources.htm" target="_blank">101 Sources for prize donations</a> </li>
</ul>
</blockquote>
<blockquote class="tr_bq">
<ul>
<li><a href="http://www.thefreewealth.com/how-to-get-raffle-prize-donations/" target="_blank">How to get raffle prize donations</a> </li>
</ul>
</blockquote>
<blockquote class="tr_bq">
<ul>
<li><a href="https://knowhownonprofit.org/how-to/how-to-approach-local-businesses-for-donations" target="_blank">How to approach local businesses for donations</a> </li>
</ul>
</blockquote>
<blockquote class="tr_bq">
<ul>
<li><a href="http://www.rewarding-fundraising-ideas.com/fundraiser-letter.html" target="_blank">Fundraiser Letter Writing Tips</a> </li>
</ul>
</blockquote>
<blockquote class="tr_bq">
<ul>
<li><a href="http://www.better-fundraising-ideas.com/sample-fundraising-letter-raffle.html" target="_blank">Sample Fundraising Request for a Raffle Prize</a></li>
</ul>
</blockquote>
<br />
<br />
<br />
Or, don't have prizes at all and use half of the money raised as a prize. This is known as a 50:50 raffle:<br />
<br />
<br />
<blockquote class="tr_bq">
<ul>
<li><a href="http://www.fundraising-newsletters.com/50-50-raffle-fundraiser.html" target="_blank">The 50:50 Raffle Fundraiser</a></li>
</ul>
</blockquote>
<br />
<br class="Apple-interchange-newline" />
<br />
<br />
<br />
<br />
<br />
<br />
<hr />
<br />
<h2 id="how-much-to-charge-for-each-raffle-ticket">
2. How much to charge for each raffle ticket</h2>
<br class="Apple-interchange-newline" />
<br />
<br />
Here you'll learn how to set the best price. Don't just roll the dice and pick a random price - if your price is too high you won't sell enough tickets. But if your price is too low, you might not raise as much money as you could. Remember some jurisdictions require all tickets to be sold at the same price (so you can’t sell one ticket for $1 and 10 tickets for $8). Check the <a href="http://www.raffleticketcreator.com/2017/04/running-fundraising-raffle-definitive.html#raffle-laws-and-licencing">legal section of this guide</a> for details of the rules in you area.<br />
<br />
<br />
<br />
<blockquote class="tr_bq">
<ul>
<li><a href="https://www.ticketprinting.com/Site/Articles/Article-2006-05-15.aspx">How to price your raffle tickets</a> </li>
</ul>
</blockquote>
<blockquote class="tr_bq">
<ul>
<li><a href="https://www.quora.com/For-a-school-fundraiser-what-is-the-ideal-price-per-raffle-ticket-for-an-item-that-kids-will-want-and-their-parents-will-want-to-get-them-e-g-four-tickets-to-a-Justin-Bieber-concert-and-parking-pass-so-something-that-is-worth-at-least-500">What is the ideal price for a school fundraiser raffle?</a> </li>
</ul>
</blockquote>
<blockquote class="tr_bq">
<ul>
<li><a href="http://budgetraffletickets.com.au/article/ticket-pricing">Ticket Pricing</a></li>
</ul>
</blockquote>
<blockquote class="tr_bq">
<ul>
<li><a href="http://assets.red-gate.com/community/books/DJRTD_eBook.pdf">Don't just roll the dice</a> (awesome guide to setting prices generally, not just raffle tickets)</li>
</ul>
</blockquote>
<div>
<br />
<br />
<br />
<br />
<br />
<br />
<hr />
<br />
<br />
<h2 id="how-to-print-raffle-tickets">
3. How to get raffle tickets printed cheaply and quickly</h2>
<br class="Apple-interchange-newline" />
<br />
<br />
<div>
There are three types of raffle tickets you can use.</div>
<div>
<br /></div>
<div>
<h4>
Standard books of raffle tickets (often known as "cloakroom tickets")</h4>
You can buy these from a stationary store like Staples. These are cheap and easy, but are just a bit of paper with a number on it, so don't look very professional. You'll find them online here:</div>
<div>
<br />
<blockquote class="tr_bq">
<ul>
<li><a href="http://amzn.to/2pfUhuV" target="_blank">Amazon cloakroom tickets</a></li>
</ul>
<ul>
<li><a href="http://www.staples.com/Staples-Double-Ticket-Roll-Red-2000-Roll-1-Roll/product_196972" target="_blank">Staples cloakroom tickets</a></li>
</ul>
</blockquote>
</div>
<div>
<br /></div>
<div>
<h4>
Print tickets at home</h4>
This is even cheaper, and you can include whatever information you need on the tickets. Be prepared for a lot of cutting and stapling, though. Here are the best resources to help you:<br />
<br /></div>
<div>
<br />
<blockquote class="tr_bq">
<ul>
<li><a href="https://app.raffleticketcreator.com/" target="_blank">Raffle Ticket Creator (design online and print at home)</a></li>
</ul>
<ul>
<li><a href="http://www.raffleticketcreator.com/2014/01/print-numbered-raffle-tickets-at-home.html" target="_blank">Create Raffle Tickets in Word</a> (step-by-step instructions)</li>
</ul>
<ul>
<li><a href="http://www.raffleticketcreator.com/2012/02/print-raffle-tickets-on-your-own.html" target="_blank">Create Raffle Tickets in Publisher</a> (step-by-step instructions)</li>
</ul>
<ul>
<li><a href="http://www.hloom.com/free-raffle-ticket-templates/" target="_blank">15 Raffle Ticket Templates</a></li>
</ul>
</blockquote>
</div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<h4>
Use a print shop (local or online)</h4>
If you have your tickets custom-printed, expect to pay about $50 for 1,000 tickets and allow at least 3 days to get your tickets. Here are some great online services who print custom raffle tickets:</div>
<div>
<br /></div>
<div>
<blockquote class="tr_bq">
<ul>
<li><a href="http://ticketprinting.com/">TicketPrinting.com</a> </li>
</ul>
</blockquote>
<blockquote class="tr_bq">
<ul>
<li><a href="http://admitoneproducts.com/">AdmitOneProducts.com</a> </li>
</ul>
</blockquote>
<blockquote class="tr_bq">
<ul>
<li><a href="http://raffleticket.com/">RaffleTicket.com</a></li>
</ul>
</blockquote>
</div>
<div>
<br class="Apple-interchange-newline" />
<br />
<br />
<br />
<br />
<br />
<br />
<hr />
<br />
<br /></div>
<h2 id="raffle-laws-and-licencing">
4. Make sure your raffle is legal!</h2>
<br class="Apple-interchange-newline" />
<br />
Different states have different rules about running raffles, and some are quite onerous (you might have to register the raffle, and report about it afterwards, for example). Here are the links to the rules in every US State, Canadian Province, plus the United Kingdom, Australia and New Zealand.<br />
<div>
<br /></div>
<div>
<div>
<h4>
United States:</h4>
</div>
<div>
<a href="http://www.tax.alaska.gov/programs/programs/reports/Historical.aspx?54160" target="_blank">Alaska</a></div>
<div>
<a href="https://www.azag.gov/consumers/raffles" target="_blank">Arizona</a></div>
<div>
<a href="http://www.dfa.arkansas.gov/offices/policyAndLegal/Documents/et2007_4.pdf" target="_blank">Arkansas</a></div>
<div>
<a href="https://oag.ca.gov/charities/raffles" target="_blank">California</a></div>
<div>
<a href="https://www.sos.state.co.us/pubs/bingo_raffles/FAQs/licenses.html" target="_blank">Colorado</a></div>
<div>
<a href="http://www.ct.gov/dcp/cwp/view.asp?a=4107&q=483094#raf" target="_blank">Connecticut</a></div>
<div>
<a href="http://dpr.delaware.gov/boards/gaming/raffle.shtml" target="_blank">Delaware</a></div>
<div>
<a href="http://www.leg.state.fl.us/statutes/index.cfm?mode=View%20Statutes&SubMenu=1&App_mode=Display_Statute&Search_String=849.0935&URL=0800-0899/0849/Sections/0849.0935.html" target="_blank">Florida</a></div>
<div>
<a href="https://dor.georgia.gov/tax-exempt-organizations-income-tax#field_related_links-486-9" target="_blank">Georgia</a> (Limited info on State website - contact County Sheriff for licence)</div>
<div>
<a href="https://legislature.idaho.gov/statutesrules/idstat/Title67/T67CH77/SECT67-7710/" target="_blank">Idaho</a></div>
<div>
<a href="http://www.ilga.gov/legislation/ilcs/ilcs3.asp?ActID=1400&ChapterID=25" target="_blank">Illinois</a> (Contact County Clerk for local rules and licence application)</div>
<div>
<a href="http://www.in.gov/igc/files/Charity_Gaming_FAQs.pdf" target="_blank">Indiana</a></div>
<div>
<a href="https://dia.iowa.gov/charitable-organizations" target="_blank">Iowa</a></div>
<div>
<a href="http://www.ksrevenue.org/bingoraffle.html" target="_blank">Kansas</a></div>
<div>
<a href="http://dcg.ky.gov/Pages/default.aspx" target="_blank">Kentucky</a></div>
<div>
<a href="http://www.ocg.louisiana.gov/sections/lawsregulations/default.asp?fGroup=20;Administrative+Rules+%26+Regulations#Chapter17-CharitableBingo,KenoandRaffle" target="_blank">Louisiana</a></div>
<div>
<a href="http://www.maine.gov/dps/msp/licenses/nonprofit_gaming.html" target="_blank">Maine</a></div>
<div>
<a href="http://sos.maryland.gov/Charity/Pages/Raffles.aspx" target="_blank">Maryland</a></div>
<div>
<a href="http://www.mass.gov/ago/doing-business-in-massachusetts/public-charities-or-not-for-profits/soliciting-funds/raffles-and-other-gaming-activity/guidance-on-raffles/hosting-a-raffle.html" target="_blank">Massachusetts</a></div>
<div>
<a href="http://www.michigan.gov/cg/0,4547,7-111-34702---,00.html" target="_blank">Michigan</a></div>
<div>
<a href="http://mn.gov/gcb/raffles.html" target="_blank">Minnesota</a></div>
<div>
<a href="http://www.msgamingcommission.com/index.php/faqs" target="_blank">Mississippi</a></div>
<div>
<a href="http://www.moga.mo.gov/MoStatutes/ConstHTML/A03039f1.html" target="_blank">Missouri</a></div>
<div>
<a href="https://dojmt.gov/gaming/gambling-licenses-permits/" target="_blank">Montana</a></div>
<div>
<a href="http://www.revenue.nebraska.gov/gaming/lottraff.html" target="_blank">Nebraska</a></div>
<div>
<a href="http://www.gaming.nv.gov/modules/showdocument.aspx?documentid=2265" target="_blank">Nevada</a></div>
<div>
<a href="http://www.gencourt.state.nh.us/rsa/html/XXIV/287-D/287-D-6.htm" target="_blank">New Hampshire</a></div>
<div>
<a href="http://www.njconsumeraffairs.gov/lgccc/Pages/brcnar.aspx" target="_blank">New Jersey</a></div>
<div>
<a href="http://www.nmgcb.org/information.aspx" target="_blank">New Mexico</a></div>
<div>
<a href="https://gaming.ny.gov/charitablegaming/index.php?ID=4" target="_blank">New York</a></div>
<div>
<a href="http://www.ncleg.net/Sessions/2009/Bills/House/PDF/H85v4.pdf" target="_blank">North Carolina</a></div>
<div>
<a href="https://attorneygeneral.nd.gov/licensing-and-gaming/licensing/charitable-gaming" target="_blank">North Dakota</a></div>
<div>
<a href="http://www.ohioattorneygeneral.gov/Files/Publications-Files/Publications-for-Non-Profits/Bingo-Publications/Policy-201-Games-of-Chance" target="_blank">Ohio</a></div>
<div>
<a href="https://www.ok.gov/oag/Frequently_Asked_Questions.html" target="_blank">Oklahoma</a></div>
<div>
<a href="http://www.doj.state.or.us/charigroup/howtoraffle.shtml" target="_blank">Oregon</a></div>
<div>
<a href="http://www.revenue.pa.gov/FormsandPublications/FormsforBusinesses/Pages/Small-Games_of_Chance.aspx#.WPosHlMrJBw" target="_blank">Pennsylvania</a></div>
<div>
<a href="http://risp.ri.gov/cgu/" target="_blank">Rhode Island</a></div>
<div>
<a href="http://www.sos.sc.gov/Raffles" target="_blank">South Carolina</a></div>
<div>
<a href="http://consumer.sd.gov/fastfacts/raffles.aspx" target="_blank">South Dakota</a></div>
<div>
<a href="http://sos.tn.gov/products/charitable-solicitations-and-gaming/who-can-hold-raffle" target="_blank">Tennessee</a></div>
<div>
<a href="https://www.texasattorneygeneral.gov/cpd/charities-nonprofits-charitable-raffles" target="_blank">Texas</a></div>
<div>
<a href="http://ago.vermont.gov/divisions/criminal-division/gambling.php" target="_blank">Vermont</a></div>
<div>
<a href="http://www.vdacs.virginia.gov/charitable-gaming-organization-licensing.shtml" target="_blank">Virginia</a></div>
<div>
<a href="http://www.wsgc.wa.gov/publications/brochures/5-164-raffles.pdf" target="_blank">Washington</a></div>
<div>
<a href="https://lottery.dc.gov/page/fundraising-and-charitable-games" target="_blank">Washington, D.C.</a></div>
<div>
<a href="http://tax.wv.gov/Business/BusinessRegistration/Pages/BusinessRegistration.aspx#a-id-wvtax-bingo-and-raffle-1" target="_blank">West Virginia</a></div>
<div>
<a href="http://www.doa.state.wi.us/divisions/gaming/charitable/raffle/raffle-license" target="_blank">Wisconsin</a></div>
<div>
<a href="http://law.justia.com/codes/wyoming/2010/Title6/chapter7.html" target="_blank">Wyoming</a> (Legal, but no official information online)</div>
<div>
<br /></div>
</div>
<div>
<br /></div>
<div>
<h4>
<b>US States where raffles are illegal:</b></h4>
</div>
<div>
Alabama</div>
<div>
Hawaii<br />
Utah<br />
<br />
<h4>
United Kingdom:</h4>
<a href="http://www.gamblingcommission.gov.uk/for-the-public/Fundraising-and-promotions/Fundraising/Lotteries-at-events.aspx" target="_blank">Great Britain (England, Wales & Scotland)</a><br />
<a href="http://www.nicva.org/resource/lotteries" target="_blank">Northern Ireland</a><br />
<br />
<h4>
Canada:</h4>
<a href="http://www.aglc.gov.ab.ca/raffle/default.asp" target="_blank">Alberta</a><br />
<a href="http://www2.gov.bc.ca/gov/content/sports-culture/gambling-fundraising/gambling-licence-fundraising" target="_blank">British Columbia</a><br />
<a href="http://lgamanitoba.ca/liquor-gaming-applications/charitable-gaming-licence/raffle/" target="_blank">Manitoba</a><br />
<a href="http://www2.gnb.ca/content/gnb/en/services/services_renderer.544.Charitable_Lottery_Licences_and_Permits.html" target="_blank">New Brunswick</a><br />
<a href="http://www.servicenl.gov.nl.ca/lotteries/" target="_blank">Newfoundland and Labrador</a><br />
<a href="http://www.maca.gov.nt.ca/home/for-businesses/lottery-licensing/" target="_blank">Northwest Territories</a><br />
<a href="https://novascotia.ca/sns/access/alcohol-gaming/gaming/licences.asp" target="_blank">Nova Scotia</a><br />
<a href="http://cgs.gov.nu.ca/en/public_Consumer.aspx" target="_blank">Nunavut</a><br />
<a href="http://www.agco.on.ca/en/whatwedo/licence_rafflelotteries.aspx" target="_blank">Ontario</a><br />
<a href="http://www.gov.pe.ca/jps/index.php3?number=14973&lang=E" target="_blank">Prince Edward Island</a><br />
<a href="https://www.racj.gouv.qc.ca/en/formulaires-et-publications/forms/drawings-french-only.html" target="_blank">Quebec</a><br />
<a href="https://www.slga.com/permits-and-licences/charitable-gaming/raffles" target="_blank">Saskatchewan</a><br />
<a href="http://www.community.gov.yk.ca/lottery.html" target="_blank">Yukon</a><br />
<br />
<br />
<h4>
Australia:</h4>
<a href="http://www.gamblingandracing.act.gov.au/gambling/lotteries/raffles" target="_blank">Australian Capital Territory</a><br />
<a href="http://www.liquorandgaming.nsw.gov.au/Documents/gaming-and-wagering/competitions/gofc_fs_rraffles.pdf" target="_blank">New South Wales</a><br />
<a href="https://nt.gov.au/industry/gambling/lotteries-community-gambling/conditions-on-lotteries-raffles-games" target="_blank">Northern Territory</a><br />
<a href="https://www.business.qld.gov.au/industries/hospitality-tourism-sport/liquor-gaming/gaming/not-profit-charitable/competitions-raffles-bingo" target="_blank">Queensland</a><br />
<a href="http://www.cbs.sa.gov.au/licensing-and-registration/lotteries/" target="_blank">South Australia</a><br />
<a href="http://www.consumer.tas.gov.au/registrations/charities" target="_blank">Tasmania</a><br />
<a href="http://www.vcglr.vic.gov.au/gambling/community-and-charitable-gaming/apply-new-licence/application-process-and-requirements" target="_blank">Victoria</a><br />
<div>
<a href="http://www.rgl.wa.gov.au/docs/default-source/gaming/lotteries_what_your_organisation_needs_to_know.pdf" target="_blank">Western Australia</a></div>
<br />
<h4>
New Zealand:</h4>
<a href="http://www.police.govt.nz/advice/personal-community/housie-raffles/games-chance" target="_blank">New Zealand</a><br />
<div>
<br class="Apple-interchange-newline" />
<br />
<br />
<br />
<br />
<br />
<br />
<hr />
<br />
<br /></div>
<br /></div>
<h2 id="how-to-promote-your-raffle">
5. How to promote your raffle</h2>
<br class="Apple-interchange-newline" />
<br />
<br />
<div>
Thinking you just need to hand out tickets to other group members and ask them to sell some? Think again. A professional sales plan could dramatically increase your sales. Here are some tips from the very best raffle promotors to help you maximise sales and raise as much money as possible for your cause:</div>
<div>
<br /></div>
<div>
<br />
<blockquote class="tr_bq">
<ul>
<li><a href="http://blog.winspireme.com/6-powerful-ways-to-market-your-fundraising-event-for-free">6 Powerful Ways to Market Your Fundraising Event for Free</a> </li>
</ul>
</blockquote>
<blockquote class="tr_bq">
<ul>
<li><a href="https://www.rafflelink.com.au/top-10-raffle-promotion-ideas/">Top 10 Raffle Promotion Ideas</a> </li>
</ul>
</blockquote>
<blockquote class="tr_bq">
<ul>
<li><a href="http://www.fundraiserhelp.com/selling-raffle-tickets.htm">Fundraiser Help: Selling Raffle Tickets</a> </li>
</ul>
</blockquote>
<blockquote class="tr_bq">
<ul>
<li><a href="https://www.accelevents.com/37-ways-to-promote-your-fundraiser/">37 Ways to Promote Your Fundraiser</a> </li>
</ul>
</blockquote>
<blockquote class="tr_bq">
<ul>
<li><a href="http://razoofoundation.org/2012/07/22-ways-to-promote-your-fundraising-event/">22 Ways to Promote Your Fundraising Event</a> </li>
</ul>
</blockquote>
<blockquote class="tr_bq">
<ul>
<li><a href="http://nonprofithub.org/fundraising/22-clever-marketing-ideas-to-promote-your-next-fundraiser/">How to Hype Up Your Next Fundraising Event</a></li>
</ul>
</blockquote>
</div>
<div>
<div>
<br class="Apple-interchange-newline" />
<br />
<br />
<br />
<br />
<br />
<br />
<hr />
<br />
<br /></div>
</div>
<div>
<br />
<h2 id="raffle-social-media-tips">
6. Contact the winners and announce on social media: best practice</h2>
<br class="Apple-interchange-newline" />
<br />
<br />
<br />
Often the winner will be in the room when you make the drawing, but if they are not, be ready to contact them so they can collect their prize. Your state might have specific rules about this, be sure to check the legal links above to check if there is a statutory time limit or other rule you have to comply with. Here are some great simple examples of how to congratulate the winner.<br />
<br />
Don't forget to announce the winners on social media too, and mention the prizes. Remember that you want your prize donors to get maximum publicity so they donate another prize next year!<br />
<br />
<br />
<blockquote class="tr_bq">
<ul>
<li><a href="http://blog.wishpond.com/post/115675435998/5-best-ways-to-announce-notify-contest-winners-with-examples">5 Ways to contact contest winners</a> </li>
</ul>
</blockquote>
<blockquote class="tr_bq">
<ul>
<li><a href="http://blog.promosimple.com/tips/how-to-craft-the-perfect-giveaway-congratulations-message/">How to Craft the Perfect Giveaway Congratulations Message</a> </li>
</ul>
</blockquote>
<blockquote class="tr_bq">
<ul>
<li><a href="http://www.foundletters.com/announcement-letters/sample-winner-announcement-letter/">Sample Winner Announcement Letter</a> </li>
</ul>
</blockquote>
<blockquote class="tr_bq">
<ul>
<li><a href="http://www.sampleletterz.com/announcement-letters/winner-announcement-letter.html">Free Sample Letters: Winner Announcement Template</a></li>
</ul>
</blockquote>
<br />
<br />
<div>
<br class="Apple-interchange-newline" />
<br />
<br />
<br />
<br />
<br />
<br />
<hr />
<br />
<br /></div>
<br />
Thanks for reading this guide, which was produced by <a href="https://app.raffleticketcreator.com/">Raffle Ticket Creator</a> who have helped thousands of fundraisers all over the world prepare professional-looking raffle tickets for their fundraising raffle.<br />
<br />
Best of luck with <i>your</i> raffle!<br />
<br />
<br />
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<br /></div>
Bruce Ghttp://www.blogger.com/profile/09056360686702009784noreply@blogger.comtag:blogger.com,1999:blog-4708941817257238261.post-82506363701701385102017-03-30T05:05:00.000-07:002019-08-05T04:35:46.115-07:00Legal Requirements for Holding a Raffle in Victoria, AustraliaIn Victoria, Australia, a raffle is defined as an event where people can buy tickets in order to gain a chance at winning an item from a predefined prize pool. The definition and the legislation that stands behind it can be found under the<a href="http://www.legislation.vic.gov.au/Domino/Web_Notes/LDMS/PubLawToday.nsf/7e27929611f1d5c2ca256dac00186f32/89f692c56474800dca257a5b0003788d!OpenDocument" target="_blank"> Gambling Regulation Regulations 2005</a>. Similar to the other Australian regions, Victora has its own regulatory body: the <a href="http://www.vcglr.vic.gov.au/" target="_blank">VCGLR (Victorian Commission for Gambling and Liquor Regulation)</a>. The commission operates under the Victorian Department of Justice.<br />
<br />
Knowing and understanding the laws and regulations of Victoria are essential to holding a legal raffle. Illegal events will be punished accordingly to the penal law!<br />
<br />
Conducting a raffle in Victoria requires a company or organization to first register as a nonprofit or charitable organization with the VCGLR. In order to register your company, the V<a href="http://www.vcglr.vic.gov.au/gambling/community-and-charitable-gaming/apply-new-licence/application-process-and-requirements" target="_blank">CGLR provides extensive documentation and application forms on their official website.</a><br />
<br />
The application for registering must be submitted to the VCGLR at least 21 days prior to the date of the raffle. There are cases when this process can be sped up, but it cannot be guaranteed. Once approved, the registration is valid for 10 years. However, a company can renounce its registration at any time.<br />
<br />
Besides the initial registration with VCGLR, a company must also apply for a minor gaming permit if the total prize pool of the planned raffle exceeds $5,000. Every company looking to apply for a minor gaming permit must first appoint a nominee to be their representative. The VCGLR can approve or deny the appointed nominee. Moreover, as a part of the permit application, the nominee will have to provide a credit check, fingerprints, and a National Police Certificate.<br />
<br />
Once the nominee is appointed, he or she will be solely responsible for supervising the raffle activity and its legality.<br />
<h2>
</h2>
<h2>
Small Raffles</h2>
<br />
Any raffle with a total prize pool that doesn’t exceed $500 can be considered a small raffle. Due to the small prize pool, there are very few regulations in place for these events. The organizer of the raffle is not required to print tickets, while the value of the tickets must be at least twice that of the prize pool. Moreover, records of funds, tickets, and prizes must be kept for 3 years.<br />
<h2>
</h2>
<h2>
Medium Raffles</h2>
<br />
If the total prize value ranges between $501 and $5,000, the raffle is considered medium-sized. A minor gaming permit is not required for these events. However, printed numbered tickets are required. Each ticket must contain enough details for the organizer to be able to contact the winner and vice-versa. The draw date must be no later than 3 months after the tickets are put on sale and it must be printed on the ticket.<br />
<h2>
</h2>
<h2>
Large Raffles</h2>
<br />
Every raffle that has a prize pool exceeding $5,000 is considered to be a large raffle and requires a minor gaming permit. Printed numbered tickets are also a requirement. If the total prize pool exceeds $100,000 the company’s nominee must obtain a National Police Certificate. This certificate must also be obtained if the prize pool exceeds $60,000 and the price of the printed tickets is $35 or more<br />
<br />
<br />
________________<br />
<br />
<h3>
<i>Running a fund-raising raffle? Try <a href="https://app.raffleticketcreator.com/" target="_blank">Raffle Ticket Creator to print raffle tickets at home.</a></i></h3>
<div>
<br /></div>
Bruce Ghttp://www.blogger.com/profile/09056360686702009784noreply@blogger.com0tag:blogger.com,1999:blog-4708941817257238261.post-44475171133323673642017-03-23T04:44:00.000-07:002019-07-22T07:10:08.801-07:00How to Keep Your Raffle Legal in QuebecRaffles are not illegal in Canada but they are strictly regulated. Charitable and religious organizations are the only types of establishments that can hold a raffle that is considered legal. Although there are certain similarities between Canadian regions, each has its own set of laws and regulations regarding raffles. Moreover, each province has its own regulatory body which must be contacted in order to receive a valid raffle license.<br />
<br />
The RACJ (<a href="https://www.racj.gouv.qc.ca/en/home.html" target="_blank">Régie des alcools, des courses et des jeux</a>) is the legal panel established by the government of Quebec to regulate all aspects regarding alcohol, games (including raffles), and racing.<br />
<br />
Holding a raffle event and printing numbered raffle tickets for it can only be done by 3 types of organizations in Quebec:<br />
<br />
<ol>
<li>Those which donate all the proceeds towards a charitable cause</li>
<li>Those who organize a fair or an exhibition</li>
<li>Those which have leased a concession from either a fair or an exhibition</li>
</ol>
<br />
In other words, unless you’re holding a charitable raffle or you have an event that’s open to the public, without restrictions, you won’t be able to apply for a raffle license.<br />
<br />
If the raffle even that you’re planning will have a total prize value of more than $1,000, the government must be informed at least 30 days in advance. In all other cases, a 5 days notice will be enough.<br />
<br />
The process of applying for a raffle license is very straightforward. The <a href="https://www.racj.gouv.qc.ca/en/formulaires-et-publications/forms/drawings-french-only.html" target="_blank">RACJ provides an online portal that contains the necessary forms required for the application</a>. Besides the application, a number of other documents are required:<br />
<br />
<ul>
<li>A document stating the maximum number of participants and chances of winning</li>
<li>A statement regarding the total value of the prize, including a short description of each prize</li>
<li>A draft of the printed numbered ticket that will be sold to participants</li>
<li>A proof of security detail is required if the total prize value exceeds $20,000 or at least one prize is valued at over $1,000.</li>
</ul>
<h2>
</h2>
<h2>
Documents Required After the Raffle</h2>
<br />
Once the raffle is over, the organizer is allowed up to 60 days to submit a statement to the Quebec licensing board. The statement must include the following:<br />
<br />
<ul>
<li>Number of printed tickets; number of sold tickets; price of each ticket</li>
<li>Total proceeds acquired from the sale of the tickets</li>
<li>Value of the prizes (awarded and claimed); initial cost of the prizes</li>
<li>Total expenses and profit/loss statement</li>
<li>Name and address for every winner who was awarded a prize valued at $100 or more</li>
</ul>
<br />
<h2>
</h2>
<h2>
Printing Legal Tickets</h2>
The law requires you to include very specific information on your printed raffle tickets:<br />
<br />
<ul>
<li>Price</li>
<li>Name of the company or person benefiting from the draw</li>
<li>Draw order of the prizes and the retail price of each</li>
<li>Sequential number of the ticket and the number of printed tickets</li>
<li>License number issued by the RACJ</li>
<li>Location, date, and time of the raffle draw</li>
<li>Specific time period for the winners to claim their prizes</li>
</ul>
<br />
<br />
__________________<br />
If you want to save money printing numbered raffle tickets at home, then try <a href="https://app.raffleticketcreator.com/" target="_blank">Raffle Ticket Creator</a><br />
<br />Bruce Ghttp://www.blogger.com/profile/09056360686702009784noreply@blogger.comtag:blogger.com,1999:blog-4708941817257238261.post-19024119399314754432017-03-14T04:32:00.000-07:002017-03-14T04:32:16.495-07:00How to Organize a Legal Raffle in British Columbia<div dir="ltr" style="line-height: 1.38; margin-bottom: 10pt; margin-top: 0pt; text-align: left;">
<div style="text-align: justify;">
<span style="font-family: "arial"; font-size: 14.6667px; white-space: pre-wrap;">Similar to other Canadian regions, British Columbia has its own laws. Operating without a license is prohibited by the law. Currently, only charitable and religious organizations can obtain a license from the corresponding office. Regardless, the goal of the raffle must be to raise funds to be used either by a local community or by a 3rd party working towards improving the local community.</span></div>
<div style="text-align: justify;">
<span style="font-family: "arial";"><span style="font-size: 14.6667px; white-space: pre-wrap;"><br /></span></span></div>
<div style="text-align: justify;">
<span style="font-family: "arial";"><span style="font-size: 14.6667px; white-space: pre-wrap;">A nonprofit or religious organization must first apply for the correct corresponding license before it can run a legal raffle and print numbered raffle tickets.</span></span></div>
<div style="text-align: justify;">
<span style="font-family: "arial";"><span style="font-size: 14.6667px; white-space: pre-wrap;"><br /></span></span></div>
<div style="text-align: justify;">
<span style="font-family: "arial";"><span style="font-size: 14.6667px; white-space: pre-wrap;">Reading and understanding the standard licensing procedure and guidelines is a must before applying for a license. Missing documents could lead to further delays or even a negative response. </span></span><span style="font-family: arial; font-size: 14.6667px; white-space: pre-wrap;">Luckily, the </span><a href="http://www2.gov.bc.ca/gov/content/sports-culture/gambling-fundraising/gambling-licence-fundraising" style="font-family: arial; font-size: 14.6667px; white-space: pre-wrap;" target="_blank">GPEB (Gaming Policy and Enforcement Branch) of British Columbia</a><span style="font-family: arial; font-size: 14.6667px; white-space: pre-wrap;"> has a wide range of services that are available for organizations looking to obtain a raffle license. Application forms may be submitted on the online platform supplied by the GPEB or sent by post. Emails and faxes are not permitted.</span></div>
<div style="text-align: justify;">
<span style="font-family: "arial";"><span style="font-size: 14.6667px; white-space: pre-wrap;"><br /></span></span></div>
<div style="text-align: justify;">
<span style="font-family: "arial";"><span style="font-size: 14.6667px; white-space: pre-wrap;">There are several factors that will guide the organization towards the correct license, including price of tickets, gross revenue, expected ticket proceeds, and type of organization requesting the license:</span></span></div>
<h2 style="text-align: justify;">
<span style="font-family: "arial";"><span style="font-size: 14.6667px; white-space: pre-wrap;">Class A License</span></span></h2>
<div style="text-align: justify;">
<span style="font-family: "arial";"><span style="font-size: 14.6667px; white-space: pre-wrap;">Every raffle that has an expected revenue that exceeds $20,000 will fall under this category. In these cases, the raffle event organizer and the person holding the finances must be two different people. Moreover, the proceeds cannot be held in the company’s account. A new, separate account must be created for all financial deposits and withdrawals related to the raffle proceeds. The company that organizes the raffle must apply for a license at least 10 weeks in advance of the actual raffle date.</span></span></div>
<h2 style="text-align: justify;">
<span style="font-family: "arial";"><span style="font-size: 14.6667px; white-space: pre-wrap;">Class B License</span></span></h2>
<div style="text-align: justify;">
<span style="font-family: "arial";"><span style="font-size: 14.6667px; white-space: pre-wrap;">Raffles with an expected revenue of less than $20,000 will fall under this category. Once the receipt of a completed application is received, it may take an additional 3 days for the registry to process the data and release the new license. However, there are cases where there is insufficient information provided. Such cases may take a longer period of time to be approved for a license.</span></span></div>
<h2 style="text-align: justify;">
<span style="font-family: "arial";"><span style="font-size: 14.6667px; white-space: pre-wrap;">Class C License</span></span></h2>
<div style="text-align: justify;">
<span style="font-family: "arial";"><span style="font-size: 14.6667px; white-space: pre-wrap;">Community fairs and exhibitions that hold raffles will have to receive this license before being able to hold any public events. For a fair or exhibition even to be considered eligible for a raffle license, the duration of the event must be at least 3 days or longer. Moreover, the event must be open to the public, without restrictions.</span></span></div>
<h2 style="text-align: justify;">
<span style="font-family: "arial";"><span style="font-size: 14.6667px; white-space: pre-wrap;">Class D License</span></span></h2>
<div style="text-align: justify;">
<span style="font-family: "arial";"><span style="font-size: 14.6667px; white-space: pre-wrap;">Small raffles with an expected revenue that doesn’t pass the $5,000 threshold will fall under this category. The funds from these small raffles must be used to help the community, either on a local level or through a third party. The proceeds from the raffle cannot be used outside of British Columbia.</span></span></div>
<h2 style="text-align: justify;">
<span style="font-family: "arial";"><span style="font-size: 14.6667px; white-space: pre-wrap;">How to Correctly Print Numbered Raffle Tickets</span></span></h2>
<div style="text-align: justify;">
<span style="font-family: "arial";"><span style="font-size: 14.6667px; white-space: pre-wrap;">In order to conform to all regulations, you can choose to print numbered raffle tickets or create and distribute them on a digital platform.</span></span></div>
<div style="text-align: justify;">
<span style="font-family: "arial";"><span style="font-size: 14.6667px; white-space: pre-wrap;">If you decide to print numbered raffle tickets, there are several rules that have been published and updated in January 2016. Each ticket must consist of two independent, detachable parts:</span></span></div>
<h3 style="text-align: justify;">
<span style="font-family: "arial";"><span style="font-size: 14.6667px; white-space: pre-wrap;"><br /></span></span></h3>
<h3 style="text-align: justify;">
<span style="font-family: "arial";"><span style="font-size: 14.6667px; white-space: pre-wrap;">Part 1, which is retained by the raffle participant:</span></span></h3>
<div style="text-align: justify;">
</div>
<ul>
<li>Name and address of the license holder accompanied by a telephone number</li>
<li>License number for the gaming event, written as “BC Gaming Event License #_____”</li>
<li>Sequential number of the ticket and total number of tickets that were printed</li>
<li>Ticket price</li>
<li>Location and date of the raffle draw(s)</li>
<li>The words "Winners consent to the release of their names by the licensee."</li>
</ul>
<br />
<h3 style="text-align: justify;">
<span style="font-family: "arial";"><span style="font-size: 14.6667px; white-space: pre-wrap;">Part 2, which is retained by the raffle organizer:</span></span></h3>
<div style="text-align: justify;">
</div>
<ul>
<li>Designated area that contains details regarding the full name of the ticket purchaser, as well as telephone number and address</li>
<li>License number for the gaming event, written as “BC Gaming Event License #_____”</li>
<li>Sequential number of the ticket</li>
</ul>
<div>
_______________</div>
<div>
Want to save money by printing numbered raffle tickets at home? Try <a href="https://app.raffleticketcreator.com/" target="_blank">Raffle Ticket Creator</a></div>
<div>
<br /></div>
</div>
Bruce Ghttp://www.blogger.com/profile/09056360686702009784noreply@blogger.com0tag:blogger.com,1999:blog-4708941817257238261.post-14462497724064771712017-03-08T12:00:00.000-08:002017-03-08T12:00:07.788-08:00Raffle Regulations in New South Wales: Everything You Need to Know<div dir="ltr" style="line-height: 1.38; margin-bottom: 10pt; margin-top: 0pt; text-align: left;">
<span style="font-family: "arial"; font-size: 11pt; text-align: justify; white-space: pre-wrap;">Raffles are a well-known method of raising funds for a good cause. Whether the proceeds are distributed towards various charities or used to make improvements to a community that needs help, raffles can easily raise enough money to cover such needs. However, although anyone can print numbered raffle tickets and hold a raffle, there are certain regulations that must be met in order for the raffle to be legal.</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 10pt; margin-top: 0pt; text-align: left;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">In Australia, any type of fundraising raffle is considered a “gaming event” and must abide by certain laws and regulations. Similar to other countries from around the world, the Australian government allows each region to have its own rules and regulations.</span></div>
<div dir="ltr" style="line-height: 1.3800000000000001; margin-bottom: 10pt; margin-top: 0pt; text-align: justify;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">New South Wales is no different. Every raffle and similar gaming events must abide strict regulations that are set in place by the <a href="https://www.liquorandgaming.justice.nsw.gov.au/" target="_blank">New South Wales Office of Liquor, Gaming, and Racing</a>. Knowing the laws will help you avoid an accidental illegal raffle that could have unpleasant repercussions.</span></div>
<div dir="ltr" style="line-height: 1.3800000000000001; margin-bottom: 10pt; margin-top: 0pt; text-align: justify;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Similar to casinos and other licensed clubs, a raffle event is subject to laws and regulations that are meant to protect both the consumer and the organizers of the event. </span></div>
<h3 style="line-height: 1.3800000000000001; margin-bottom: 10pt; margin-top: 0pt; text-align: justify;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Important Raffle Regulations</span></h3>
<div dir="ltr" style="line-height: 1.3800000000000001; margin-bottom: 10pt; margin-top: 0pt; text-align: justify;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Charitable and nonprofit organizations do not need to apply for a license if the total prize value does not exceed $30,000. In this case, the raffles are considered lotteries and are subjected to certain regulations.</span></div>
<div dir="ltr" style="line-height: 1.3800000000000001; margin-bottom: 10pt; margin-top: 0pt; text-align: justify;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">If a charitable organization plans on holding a raffle with a prize value which exceed $30,000, it must <a href="https://www.liquorandgaming.justice.nsw.gov.au/Pages/gaming/licence-forms-and-applications.aspx" target="_blank">apply for a license from the NSW Office of Liquor, Gaming, and Racing</a>. In these cases, the raffles are referred to as “art unions”, and the regulations are different from those for lotteries.</span></div>
<div dir="ltr" style="line-height: 1.3800000000000001; margin-bottom: 10pt; margin-top: 0pt; text-align: justify;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">A minimum of 40% of the gross ticket proceeds must be used by the nonprofit organization. Expenses, including the purchasing of prizes, must not exceed 60% of the total gross proceeds.</span></div>
<div dir="ltr" style="line-height: 1.3800000000000001; margin-bottom: 10pt; margin-top: 0pt; text-align: justify;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">If the organizing party offers all its prizes in cash, the total value of the cash prize must not exceed $30,000.</span></div>
<div dir="ltr" style="line-height: 1.3800000000000001; margin-bottom: 10pt; margin-top: 0pt; text-align: justify;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Moreover, if the prizes include alcoholic beverages, tickets cannot be sold to or bought by people under the age of 18. In all other cases, selling tickets to minors is permitted by the NSW law.</span></div>
<h3 style="line-height: 1.3800000000000001; margin-bottom: 10pt; margin-top: 0pt; text-align: justify;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Printed Ticket Guidelines</span></h3>
<div dir="ltr" style="line-height: 1.3800000000000001; margin-bottom: 10pt; margin-top: 0pt; text-align: justify;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">In order to be able to advertise the raffle, a company must print numbered raffle tickets. Each ticket must have a stub that remains with the organizer and a part that remains with the ticket purchaser.</span></div>
<div dir="ltr" style="line-height: 1.3800000000000001; margin-bottom: 10pt; margin-top: 0pt; text-align: justify;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">The stub must contain the number of the ticket and a large-enough area for the purchaser to be able to write his or her name and address.</span></div>
<div dir="ltr" style="line-height: 1.3800000000000001; margin-bottom: 10pt; margin-top: 0pt; text-align: justify;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">The part that is retained by the ticket purchaser must contain the following details:</span></div>
<br />
<ul style="margin-bottom: 0pt; margin-top: 0pt;">
<li dir="ltr" style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; list-style-type: disc; text-decoration: none; vertical-align: baseline;"><div dir="ltr" style="line-height: 1.3800000000000001; margin-bottom: 0pt; margin-top: 0pt; text-align: justify;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Ticket price</span></div>
</li>
<li dir="ltr" style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; list-style-type: disc; text-decoration: none; vertical-align: baseline;"><div dir="ltr" style="line-height: 1.3800000000000001; margin-bottom: 0pt; margin-top: 0pt; text-align: justify;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Name of the organization that will benefit from the proceeds of the raffle</span></div>
</li>
<li dir="ltr" style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; list-style-type: disc; text-decoration: none; vertical-align: baseline;"><div dir="ltr" style="line-height: 1.3800000000000001; margin-bottom: 0pt; margin-top: 0pt; text-align: justify;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Details regarding the prizes and their retail value</span></div>
</li>
<li dir="ltr" style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; list-style-type: disc; text-decoration: none; vertical-align: baseline;"><div dir="ltr" style="line-height: 1.3800000000000001; margin-bottom: 0pt; margin-top: 0pt; text-align: justify;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Details about how the winners will be notified</span></div>
</li>
<li dir="ltr" style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; list-style-type: disc; text-decoration: none; vertical-align: baseline;"><div dir="ltr" style="line-height: 1.3800000000000001; margin-bottom: 10pt; margin-top: 0pt; text-align: justify;">
<span style="background-color: transparent; color: black; font-family: "arial"; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">The date, time, and place of the raffle draw</span></div>
</li>
</ul>
<div style="text-align: justify;">
<span style="font-family: "arial";"><span style="font-size: 14.6667px; white-space: pre-wrap;"><br /></span></span></div>
<div style="text-align: justify;">
<span style="font-family: "arial";"><span style="font-size: 14.6667px; white-space: pre-wrap;">________</span></span></div>
<div style="text-align: justify;">
<span style="font-family: "arial";"><span style="font-size: 14.6667px; white-space: pre-wrap;"><br /></span></span></div>
<div style="text-align: justify;">
<span style="font-family: "arial";"><span style="font-size: 14.6667px; white-space: pre-wrap;">Wanting an easy way to print numbered raffle tickets for your event? Try <a href="https://app.raffleticketcreator.com/" target="_blank">Raffle Ticket Creator</a></span></span></div>
<div style="text-align: justify;">
<span style="font-family: "arial";"><span style="font-size: 14.6667px; white-space: pre-wrap;"><br /></span></span></div>
Bruce Ghttp://www.blogger.com/profile/09056360686702009784noreply@blogger.com0tag:blogger.com,1999:blog-4708941817257238261.post-27802265888590921742017-03-01T04:05:00.002-08:002017-03-01T04:05:54.854-08:00The rules for running a raffle in Alberta, Canada<div dir="ltr" style="line-height: 1.38; margin-bottom: 10pt; margin-top: 0pt; text-align: left;">
<span style="font-family: Arial; font-size: 11pt; text-align: justify; white-space: pre-wrap;">Each Canadian province is allowed to have its own raffle laws and regulations thanks to the federal government. In the state of Alberta, every legal aspect of holding a raffle is enforced by the AGLC (Alberta Gaming & Liquor Commission). There are certain similarities between Canada’s regions, but in order to run a law-abiding raffle event, you need to contact the corresponding office. In some cases, the province further allows municipalities to create their own, local laws. </span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 10pt; margin-top: 0pt; text-align: left;">
<span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">In the province of Alberta, </span><span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;"><b>raffles are only permitted if they have a charitable cause.</b></span><span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;"> You cannot run a legal raffle for personal or financial gains. For this reason, the raffle licenses issued by the AGLC are only given non-profit groups or organizations. In order to be able to start advertising your raffle and print numbered raffle tickets for it, you will have to apply for a license.</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 10pt; margin-top: 0pt; text-align: left;">
<span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">However, there’s a prerequisite for the license: eligibility. In order to prove your eligibility for a raffle, you must first submit a form to your local province office. To be deemed eligible to run a raffle, you must provide documentation regarding your non-profit organization and the purpose of the raffle ticket proceeds.</span></div>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 10pt; margin-top: 0pt; text-align: left;">
<span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Once you are eligible for a license, the </span><a href="http://www.aglc.gov.ab.ca/raffle/default.asp" style="text-decoration: none;" target="_blank"><span style="background-color: transparent; color: #1155cc; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: underline; vertical-align: baseline; white-space: pre-wrap;">AGLC raffle licence page</span></a><span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;"> contains all the details required to complete and submit a form. Currently, there are two types of eligibility forms and licenses that can be issued, based on the value of the ticket proceeds:</span></div>
<h3 style="line-height: 1.38; margin-bottom: 10pt; margin-top: 0pt; text-align: left;">
<span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Ticket Proceeds of $10,000 or Less</span></h3>
<ul style="margin-bottom: 0pt; margin-top: 0pt;">
<li dir="ltr" style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; list-style-type: disc; text-decoration: none; vertical-align: baseline;"><div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt; text-align: left;">
<span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">The eligibility application usually takes around 7 days to be processed and approved</span></div>
</li>
<li dir="ltr" style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; list-style-type: disc; text-decoration: none; vertical-align: baseline;"><div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt; text-align: left;">
<span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">If you provide incomplete information, the process of approval may be delayed depending on the missing information</span></div>
</li>
<li dir="ltr" style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; list-style-type: disc; text-decoration: none; vertical-align: baseline;"><div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt; text-align: left;">
<span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Once your eligibility form has been approved, you will receive an AGLC identification number</span></div>
</li>
<li dir="ltr" style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; list-style-type: disc; text-decoration: none; vertical-align: baseline;"><div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt; text-align: left;">
<span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">The AGLC identification number grants you the possibility to apply for a raffle license from your local Registry office</span></div>
</li>
<li dir="ltr" style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; list-style-type: disc; text-decoration: none; vertical-align: baseline;"><div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt; text-align: left;">
<span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">The license expires when the raffle ends, unlike the AGLC identification number, which can be used again in the future
</span></div>
</li>
</ul>
<h3 style="line-height: 1.38; margin-bottom: 10pt; margin-top: 0pt; text-align: left;">
<span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 700; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Ticket Proceeds of More Than $10,000</span></h3>
<ul style="margin-bottom: 0pt; margin-top: 0pt;">
<li dir="ltr" style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; list-style-type: disc; text-decoration: none; vertical-align: baseline;"><div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt; text-align: left;">
<span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">The latest financial records must be submitted in order to be able to apply for a license</span></div>
</li>
<li dir="ltr" style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; list-style-type: disc; text-decoration: none; vertical-align: baseline;"><div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt; text-align: left;">
<span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">The organization’s charitable mission must be provided through a written statement</span></div>
</li>
<li dir="ltr" style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; list-style-type: disc; text-decoration: none; vertical-align: baseline;"><div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt; text-align: left;">
<span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">In some cases, a lawyer’s trust will be required for the raised funds</span></div>
</li>
<li dir="ltr" style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; list-style-type: disc; text-decoration: none; vertical-align: baseline;"><div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt; text-align: left;">
<span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">In some cases, an outside evaluation of the prize will be required</span></div>
</li>
<li dir="ltr" style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; list-style-type: disc; text-decoration: none; vertical-align: baseline;"><div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt; text-align: left;">
<span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Similar, the eligibility and licensing processes can be delayed if the provided documents are incomplete</span></div>
</li>
</ul>
<b style="font-weight: normal;"><br /></b>
<h3 style="line-height: 1.38; margin-bottom: 10pt; margin-top: 0pt; text-align: left;">
<span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Regulations about what to print on each numbered ticket</span></h3>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 10pt; margin-top: 0pt; text-align: left;">
<span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">The AGLC strictly prohibits the sale of raffle tickets to minors (under the age of 18). Each ticket must have two parts: a stub kept by the organizing party and a body that remains with the buyer. When the time comes to print numbered raffle tickets, the following guidelines must be followed:</span></div>
<h4 style="line-height: 1.38; margin-bottom: 10pt; margin-top: 0pt; text-align: left;">
<span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">The ticket stub must contain:</span></h4>
<ul style="margin-bottom: 0pt; margin-top: 0pt;">
<li dir="ltr" style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; list-style-type: disc; text-decoration: none; vertical-align: baseline;"><div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt; text-align: left;">
<span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">The buyer’s contact details (full name, address, and telephone number)</span></div>
</li>
<li dir="ltr" style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; list-style-type: disc; text-decoration: none; vertical-align: baseline;"><div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt; text-align: left;">
<span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">A distinct ticket number</span></div>
</li>
<li dir="ltr" style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; list-style-type: disc; text-decoration: none; vertical-align: baseline;"><div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt; text-align: left;">
<span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">The license number issued by the AGLC</span></div>
</li>
</ul>
<div dir="ltr" style="line-height: 1.38; margin-bottom: 10pt; margin-top: 0pt; text-align: left;">
<span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;"><br /></span></div>
<h4 style="line-height: 1.38; margin-bottom: 10pt; margin-top: 0pt; text-align: left;">
<span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">The ticket body must contain details about the:</span></h4>
<br />
<ul style="margin-bottom: 0pt; margin-top: 0pt;">
<li dir="ltr" style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; list-style-type: disc; text-decoration: none; vertical-align: baseline;"><div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt; text-align: left;">
<span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Contact details of the organizing party (company name and address)</span></div>
</li>
<li dir="ltr" style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; list-style-type: disc; text-decoration: none; vertical-align: baseline;"><div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt; text-align: left;">
<span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">License number issued by the AGLC</span></div>
</li>
<li dir="ltr" style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; list-style-type: disc; text-decoration: none; vertical-align: baseline;"><div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt; text-align: left;">
<span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Ticket price</span></div>
</li>
<li dir="ltr" style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; list-style-type: disc; text-decoration: none; vertical-align: baseline;"><div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt; text-align: left;">
<span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Ticket number and total amount of numbered raffle tickets</span></div>
</li>
<li dir="ltr" style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; list-style-type: disc; text-decoration: none; vertical-align: baseline;"><div dir="ltr" style="line-height: 1.38; margin-bottom: 0pt; margin-top: 0pt; text-align: left;">
<span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Correct date and location of the draw</span></div>
</li>
<li dir="ltr" style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; list-style-type: disc; text-decoration: none; vertical-align: baseline;"><div dir="ltr" style="line-height: 1.38; margin-bottom: 10pt; margin-top: 0pt; text-align: left;">
<span style="background-color: transparent; color: black; font-family: Arial; font-size: 11pt; font-style: normal; font-variant: normal; font-weight: 400; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;">Details about the prize and its value</span></div>
</li>
</ul>
<div>
________________</div>
<div>
<br /></div>
<div>
Want to print your raffle tickets at home? Here are <a href="http://www.raffleticketcreator.com/2017/01/3-ways-to-print-cheap-or-free-raffle.html" target="">three ways to create and print raffle tickets at home.</a></div>
<div>
<span style="font-family: Arial;"><span style="font-size: 14.6667px; white-space: pre-wrap;"><br /></span></span></div>
Bruce Ghttp://www.blogger.com/profile/09056360686702009784noreply@blogger.com0tag:blogger.com,1999:blog-4708941817257238261.post-3242752309156902172017-02-08T01:43:00.000-08:002017-02-08T01:43:32.669-08:00Running a Fundraising Raffle in Northern Ireland: Everything You Need to Know<br />
Hosting a legal raffle in Northern Ireland can be a tricky process. Raffles fall under the Betting, Gaming, Lotteries and Amusements legislation, which dates back to 1985. Over the years, the law has suffered several amends, and is set to receive a new set of changes in 2017.<br />
<br />
According to current legislation, a raffle is a type of lottery that involves the purchase of fixed-price tickets, without the need of a certain set of skills. At the end of the lottery, each participant is eligible to win the whole prize or a part of the prize pool, only relying on chance.<br />
<br />
More information regarding raffle laws and regulations can be found on the official website of the <a href="http://www.nicva.org/resource/lotteries" target="_blank">Northern Ireland Council for Voluntary Action.</a><br />
<br />
Currently, there are 3 types of raffles that are legal: small, private, and societies’ raffles. There are different rules and regulations for each of these categories:<br />
<br />
<h2>
Small Raffles</h2>
Based on the Northern Ireland legislation, small raffles are defined by a distinct set of rules. The most important aspect is that 100% of the proceedings that come from ticket sales cannot be devoted to private gains. Secondly, the raffle must take place during a larger event. Thirdly, for a raffle to fall under the “small raffle” category, the entirety of the ticket sales must be done during the previously mentioned event.<br />
These events include, but are not limited to: dinners, dances, bazaars, jumble sales, fetes, athletic events, and so on.<br />
The organizing party must follow these rules:<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>•<span class="Apple-tab-span" style="white-space: pre;"> </span>Keep records of all participants<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>•<span class="Apple-tab-span" style="white-space: pre;"> </span>Clearly state the purpose of the raffle and the destination of the ticket proceeds<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>•<span class="Apple-tab-span" style="white-space: pre;"> </span>Inform all potential participants of the purpose of the raffle<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>•<span class="Apple-tab-span" style="white-space: pre;"> </span>Announce the local police department at least 7 days before the event will take place<br />
<br />
<h2>
Private Raffles</h2>
A private raffle is somewhat different to a small raffle. If a small raffle must be a part of a larger event, a private raffle can be held on its own, as long as it is promoted in Northern Ireland, and the organizers are part of a commercial or residential society.<br />
<br />
There is a ticket sales threshold in place for all private raffles, meaning that the value of the sold tickets cannot be higher than £1.000.<br />
<br />
Finally, all the proceeds of the raffle, except printing and other expenses, must go towards the society itself, to prizes for a part of the participants, or both.<br />
<br />
These raffles can be used by various societies that operate on the territory of Northern Ireland and can be a very useful source of funding.<br />
<br />
<h2>
Societies’ Raffles</h2>
Unlike the private lottery, where members of a society could run a raffle for the gain of the said society, these raffles can only be conducted for charitable purposes. In order to be able to hold a society's raffle, registration is required. The application forms are available at the district council offices. A registry fee (£35) must be paid when applying. Moreover, a copy of the application must also be sent to the local police department (as well as another £17.50 fee).<br />
<br />
After registration, a society is free to hold an unlimited number of raffles every year, as long as the total value of the sold tickets doesn’t surpass the threshold of £1 million per year, or £80.000 per raffle.<br />
<br />
Ticket sales must follow these rules:<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>•<span class="Apple-tab-span" style="white-space: pre;"> </span>Can’t be sold to people under the age of 16<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>•<span class="Apple-tab-span" style="white-space: pre;"> </span>Must be priced at £1 or less and cannot be offered for free for any reason<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>•<span class="Apple-tab-span" style="white-space: pre;"> </span>Can’t be sold in bookmaker offices<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>•<span class="Apple-tab-span" style="white-space: pre;"> </span>Must be sold in person, not by a machine<br />
The prize pool cannot include a single prize that is valued at £25.000 or higher, or 10% of the proceeds acquired from ticket sales - whichever is the greater. Moreover, the society may only use up to 50% of the proceeds to provide the said prizes.<br />
<br />
If you are looking for a way to create printable tickets for your raffle, try <a href="http://app.raffleticketcreator.com/" target="_blank">Raffle Ticket Creator</a>.<br />
<br />
<div>
<br /></div>
Bruce Ghttp://www.blogger.com/profile/09056360686702009784noreply@blogger.com0tag:blogger.com,1999:blog-4708941817257238261.post-72582148368500820162017-02-03T02:36:00.001-08:002017-02-08T01:44:05.448-08:00Legal Raffles in Ontario, Canada: How To Organize ThemRaffles are a very popular method of fundraising used by charities and nonprofit organizations throughout Canada. The Canadian Federal Government allows each Canadian province to have its own laws and regulations. As such, Ontario has its own regulatory office and laws.<br />
<br />
Before you consider organizing a raffle, we should mention that raffles held on the territory of Ontario are classified based on the cash value of the prizes. Based on this value, an organization needs to apply for either a municipal or provincial license.<br />
<br />
If the total cash value of the prizes offered in a raffle does not exceed $50,000, the organization must only apply for a municipal license. However, if the value exceeds the previously mentioned threshold, the charity or organization running the raffle must apply for a provincial license. Each license is only valid for a single raffle event. There is a possibility to apply for a license that allows for multiple raffle events over a certain period of time, but the raffles held under this license are limited to a prize value of $5,000 or less.<br />
<br />
In Ontario, charities and nonprofit organizations are only eligible to apply for a raffle license if they have a proof of existence of at least 1 year. Moreover, it is necessary for the business to have a physical location in Ontario and to prove its charitable services. Each organization that wants to hold a raffle must also show proof that the profits gained from the raffle will be used in a charitable way.<br />
<br />
Organizations looking to obtain their first raffle license must apply for it at least 45 days before the event is scheduled. For organizations who have obtained at least one raffle license in the past, the period is reduced to 30 days for all future licenses. Details about the application process, the forms, and the fees, can be found on the official website of the <a href="http://www.agco.on.ca/en/whatwedo/licence_rafflelotteries.aspx" target="_blank">Alcohol and Gambling Commission of Ontario</a>.<br />
<br />
<h3>
Documents Required for Licensing</h3>
These documents may change over time. Use this list as a guideline, but make sure to check the official website for any potential changes.<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>•<span class="Apple-tab-span" style="white-space: pre;"> </span>Incorporation papers<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>•<span class="Apple-tab-span" style="white-space: pre;"> </span>Operating Budget documents<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>•<span class="Apple-tab-span" style="white-space: pre;"> </span>Board of directors<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>•<span class="Apple-tab-span" style="white-space: pre;"> </span>Financial Statement for the previous fiscal year<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>•<span class="Apple-tab-span" style="white-space: pre;"> </span>Detailed documents regarding company activities<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>•<span class="Apple-tab-span" style="white-space: pre;"> </span>Written proposition for the use of the ticket proceeds<br />
<br />
<h3>
Raffle Ticket Guidelines</h3>
In order to maintain the legality of the raffle, the tickets must also be designed having a certain standard in mind. While the graphical design is up to the organizing party, the content is strictly regulated. Each ticket must have a body (for the participant) and a stub (for the organizer) and contain the following:<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>•<span class="Apple-tab-span" style="white-space: pre;"> </span>Ticket body:<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>•<span class="Apple-tab-span" style="white-space: pre;"> </span>License number and name of the licensed company<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>•<span class="Apple-tab-span" style="white-space: pre;"> </span>Complete data regarding the date, location, and time of the draw<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>•<span class="Apple-tab-span" style="white-space: pre;"> </span>Description of the prize, including the value<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>•<span class="Apple-tab-span" style="white-space: pre;"> </span>The full price of the ticket<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>•<span class="Apple-tab-span" style="white-space: pre;"> </span>The number of the ticket next to the total number of printed tickets<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>•<span class="Apple-tab-span" style="white-space: pre;"> </span>Ticket stub:<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>•<span class="Apple-tab-span" style="white-space: pre;"> </span>The number of the ticket<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>•<span class="Apple-tab-span" style="white-space: pre;"> </span>The license number and the name of the licensed company<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>•<span class="Apple-tab-span" style="white-space: pre;"> </span>Enough space for the whole name, address, and telephone number of the person who purchased the ticket.<br />
<br />
To create tickets like this on your computer to print out at home try <a href="http://app.raffleticketcreator.com/" target="_blank">Raffle Ticket Creator</a><br />
<br />
<div>
<br /></div>
<style type="text/css">
p.p1 {margin: 0.0px 0.0px 10.0px 0.0px; text-align: justify; font: 12.0px Times; color: #106dd6}
span.s1 {text-decoration: underline}
span.s2 {color: #000000}
</style>Bruce Ghttp://www.blogger.com/profile/09056360686702009784noreply@blogger.com3tag:blogger.com,1999:blog-4708941817257238261.post-4902800257105834632017-01-17T03:34:00.003-08:002017-01-17T03:34:50.267-08:00Everything You Need to Know About Running a Raffle in the Australian Capital Territory<div class="p1" style="text-align: left;">
<span style="text-align: justify;"><span style="font-family: Arial, Helvetica, sans-serif; font-size: small;">The Australian Capital Territory is a federal district formed within the state of New South Wales, and houses the country’s capital - Canberra. Throughout all the Australian states, raffles are classified as “gaming”, and fall into the same category as casinos and other gaming licensed clubs. However, this is where most of the similarities between state regulations end. Each state has a different set of rules and regulations for raffles, which are put in place and enforced by a local regulatory body.</span></span></div>
<div class="p3">
<span style="font-family: Arial, Helvetica, sans-serif; font-size: small;">In the case of the Australian Capital Territory, the regulatory body is the <b><a href="http://www.gamblingandracing.act.gov.au/" target="_blank">ACT Gambling and Racing Commission</a></b>.</span></div>
<div class="p3">
<span style="font-family: Arial, Helvetica, sans-serif; font-size: small;">There are 5 key features that you should know before starting a raffle in ACT:</span></div>
<br />
<ul class="ul1">
<li class="li3"><span style="font-family: Arial, Helvetica, sans-serif; font-size: small;">Any type of action that allows participants to win prizes based on a purchased ticket falls under the raffle category. Whether you’re selling tickets or asking participants to take part in a skill-based event, it will be considered a raffle, as long as there is a pre-determined prize pool.</span></li>
</ul>
<ul class="ul1">
<li class="li3"><span style="font-family: Arial, Helvetica, sans-serif; font-size: small;">Anyone can run a raffle in ACT without a permit, as long as all the proceeds are offered towards a charity or charitable cause. Moreover, the prize value must be below $500. Anything over the $500 threshold requires a valid raffle permit.</span></li>
</ul>
<ul class="ul1">
<li class="li3"><span style="font-family: Arial, Helvetica, sans-serif; font-size: small;">The value of the tickets sold can’t exceed a certain threshold which is directly related to the value of the prize. If the total prize value does not exceed $10,000, the value of the sold tickets cannot exceed 5 times the value of the prize. Similarly, if the total prize value is over $10,000, the value of the sold tickets must be within 10 times of the prize value.</span></li>
</ul>
<ul class="ul1">
<li class="li3"><span style="font-family: Arial, Helvetica, sans-serif; font-size: small;">Minors can participate in raffles as long as the raffle prizes don’t include alcohol, tobacco, or other items that are restricted to minors.</span></li>
</ul>
<ul class="ul1">
<li class="li3"><span style="font-family: Arial, Helvetica, sans-serif; font-size: small;">Raffle tickets can be created in any shape and size, but the information on them must follow certain rules. If the value of the raffle prizes exceeds $2,000, each raffle ticket must contain the following information:</span></li>
</ul>
<ul class="ul1">
<li class="li3"><span style="font-family: Arial, Helvetica, sans-serif; font-size: small;">Commission issued permit number</span></li>
</ul>
<ul class="ul1">
<li class="li3"><span style="font-family: Arial, Helvetica, sans-serif; font-size: small;">Details pertaining to the person or organization that is holding the raffle and details about the purpose of the raffle</span></li>
</ul>
<ul class="ul1">
<li class="li3"><span style="font-family: Arial, Helvetica, sans-serif; font-size: small;">A list containing all possible prizes, including their retail value</span></li>
</ul>
<ul class="ul1">
<li class="li3"><span style="font-family: Arial, Helvetica, sans-serif; font-size: small;">Conditions (if any) that participants must fulfill in order to be eligible to win</span></li>
</ul>
<ul class="ul1">
<li class="li3"><span style="font-family: Arial, Helvetica, sans-serif; font-size: small;">A sequential number</span></li>
</ul>
<ul class="ul1">
<li class="li3"><span style="font-family: Arial, Helvetica, sans-serif; font-size: small;">Details about the location, date, and time of the prize draw</span></li>
</ul>
<ul class="ul1">
<li class="li3"><span style="font-family: Arial, Helvetica, sans-serif; font-size: small;">Complete information about the date and publication of the raffle results, including the process through which the winners will be contacted by the organising party</span></li>
</ul>
<br />
<style type="text/css">
p.p1 {margin: 0.0px 0.0px 10.0px 0.0px; text-align: center; font: 12.0px Times}
p.p2 {margin: 0.0px 0.0px 10.0px 0.0px; text-align: center; font: 12.0px Times; min-height: 14.0px}
p.p3 {margin: 0.0px 0.0px 10.0px 0.0px; text-align: justify; font: 12.0px Times}
li.li3 {margin: 0.0px 0.0px 10.0px 0.0px; text-align: justify; font: 12.0px Times}
span.s1 {text-decoration: underline ; color: #106dd6}
ul.ul1 {list-style-type: disc}
</style>
<br />
<div class="p3">
<span style="font-family: Arial, Helvetica, sans-serif; font-size: small;">If you want to run a raffle and don’t know where to start, we offer our own <span class="s1"><a href="http://app.raffleticketcreator.com/">Raffle Ticket Creator App</a></span>. You won’t find an easier way to create and print raffle tickets</span>.</div>
Bruce Ghttp://www.blogger.com/profile/09056360686702009784noreply@blogger.com0tag:blogger.com,1999:blog-4708941817257238261.post-8925745640984721992017-01-10T05:22:00.001-08:002017-02-03T08:05:49.351-08:003 ways to print cheap or free numbered raffle tickets for your fundraising event<br />
<h2 style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;">
</h2>
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiHV-8bVtxLTlvdofBrESWMmkeKtRTXEVWxjGSoCbAcYZeDc3qnxT0YZuUuqPYIbnbuK44GUGLGmTMvoPK4y2LXG_Y7uu9Xm4V1A_Zwxhklkrqb_CcKPgBuIhEHhwAdjiEOI6HMw9vS5Vg/s1600/Printing+raffle+tickets+on+home+printer.jpg" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img alt="image of raffle tickets on home printer" border="0" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiHV-8bVtxLTlvdofBrESWMmkeKtRTXEVWxjGSoCbAcYZeDc3qnxT0YZuUuqPYIbnbuK44GUGLGmTMvoPK4y2LXG_Y7uu9Xm4V1A_Zwxhklkrqb_CcKPgBuIhEHhwAdjiEOI6HMw9vS5Vg/s400/Printing+raffle+tickets+on+home+printer.jpg" title="" width="400" /></a><br />
<h3>
Here are three ways to print cheap or free numbered raffle tickets for your local fundraising event</h3>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br /></div>
<h2>
<a href="http://app.raffleticketcreator.com/">1. Use the online Raffle Ticket Creator service</a></h2>
<a href="http://app.raffleticketcreator.com/" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="286" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjv1mhini6gM7OCwxohUExDrzvlEv627ZmFMCue918rqgtdysjc07pFerbX3byyajQ1LsxQzEKZaTEwAwI8jqrSmYhW-nsAlWCXo_qepk-rrscqFzZ_JTbmda5yuAgxfN_pb0NMSgUHuTQ/s320/Screen+Shot+2017-01-09+at+16.46.43.png" style="text-align: center;" width="320" /></a><i>Cost: about $20</i><br />
<i>Difficulty: super-easy</i><br />
<br />
I wrote the instructions for options 2 and 3 below, which are free but pretty hard work. If you don't have too much time and / or really don't like fiddling around for hours on your computer, then try <a href="http://app.raffleticketcreator.com/">my online service</a> which lets you design your ticket online and then download the finished document of numbered tickets ready to print at home.<br />
<br />
Click here to try it: <a href="http://app.raffleticketcreator.com/">Raffle Ticket Creator</a><br />
<br />
<div>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br /></div>
<h2>
2. Use Word (and a bit of Excel)</h2>
<h2>
<br /><div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhTzYf1Ph22wVwAjFVd7frGPMPOBq5shYsFNVtgBoGV6MZYjHvmz_TZfZHibgzdQrdMBVICC4reT2ZY7-1HEI7JnitXIn0eZ0mM1NmAGX9fN46b-S-hM7krfgJx5_26K4a8SPIbhm8cPLg/s1600/11.+Free+Raffle+Ticket+Template+for+Word+and+Excel+Office+2016.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="272" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhTzYf1Ph22wVwAjFVd7frGPMPOBq5shYsFNVtgBoGV6MZYjHvmz_TZfZHibgzdQrdMBVICC4reT2ZY7-1HEI7JnitXIn0eZ0mM1NmAGX9fN46b-S-hM7krfgJx5_26K4a8SPIbhm8cPLg/s320/11.+Free+Raffle+Ticket+Template+for+Word+and+Excel+Office+2016.png" width="320" /></a></div>
</h2>
<i>Cost: free apart from the paper and ink</i><br />
<i>Difficulty: hard (2hours+)</i><br />
<br />
Creating numbered raffle tickets in Word might might sound simple, but it gets quite tricky to persuade Word to put a different number on every ticket. You need to do a mail merge (which isn't that hard, you might have done that before) and then edit the mail merge code in the document to get Word to put a different number on every ticket (rather than a different number on every page, which is what you usually need in a mail merge).<br />
<br />
Allow a good couple of hours of fiddling around to get your numbered raffle tickets this way!<br />
<br />
Instructions for:<br />
<a href="http://www.raffleticketcreator.com/2016/07/print-raffle-tickets-using-template-in.html">Word 2016</a> (Mac or Windows)<br />
<a href="http://www.raffleticketcreator.com/2014/01/create-numbered-raffle-tickets-in-word.html">Word 2011</a> (for Mac)<br />
<a href="http://www.raffleticketcreator.com/2014/01/print-numbered-raffle-tickets-at-home.html">Word 2007</a> (for Windows)<br />
<br />
<br />
<h2>
3. Use Publisher (and a bit of Excel)<div class="separator" style="clear: both; text-align: center;">
</div>
</h2>
<div>
<br /></div>
<div>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-Znx2rtksLt9FAEuJscrKZez1weTBmytDNs3ZH7qx9JIowHNjMkiSZMgDEvxoVHX5YJYbvT82_5muChzRKxoBofrLpBNT3nhC739rwo3Yw_RyQyVSWwkrgsM0JGiXhTgrfATEV0rZCSc/s1600/print-raffle-tickets.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-Znx2rtksLt9FAEuJscrKZez1weTBmytDNs3ZH7qx9JIowHNjMkiSZMgDEvxoVHX5YJYbvT82_5muChzRKxoBofrLpBNT3nhC739rwo3Yw_RyQyVSWwkrgsM0JGiXhTgrfATEV0rZCSc/s320/print-raffle-tickets.png" width="297" /></a><i>Cost: free apart from the paper and ink</i></div>
<div>
<i>Difficulty: hard (2 hours+)</i></div>
<div>
<br /></div>
<div>
Creating numbered raffle tickets in Publisher is similar to doing it in Word. It is a bit harder, but you get a bit more flexibility about the layout of your tickets. As with Word, you need to run a mail merge to generate the ticket numbers, although you don't need to edit the merge fields like you do with Word. That makes it a bit easier, but on the other hand Publisher can be a little more cumbersome to work with than Word, so it is still not very straightforward.</div>
<div>
<br /></div>
<div>
Here are the instructions for <a href="http://www.raffleticketcreator.com/2012/02/print-raffle-tickets-on-your-own.html">creating numbered raffle tickets in Microsoft Publisher</a></div>
<br />Bruce Ghttp://www.blogger.com/profile/09056360686702009784noreply@blogger.com2tag:blogger.com,1999:blog-4708941817257238261.post-90940553089031170632016-07-04T07:30:00.000-07:002018-11-07T02:04:50.937-08:00The Secret to Creating NUMBERED Raffle Tickets in WordStruggling to get Word to put numbers on raffle tickets? I’ve got your back. Follow these 7 simple steps to raffle ticket awesomeness.<br />
<br />
<h3>
How do I create numbered raffle tickets in Word?</h3>
<br />
First, create your ticket layout in Word. Then use Excel to make a list of ticket numbers. Use the Mail Merge function to pull these numbers into your Word ticket template. The clever bit: use the <<NextRecord>> tag to get a different number on each ticket. Then run your merge and print.<br />
<br />
Read on for more detail!<br />
<br />
<i>Note: this takes quite a while. If you want a shorter way to do this, I recommend <a href="https://app.raffleticketcreator.com/">Raffle Ticket Creator</a>. This website lets you design a ticket online and then download a PDF with all your numbered raffle tickets, ready to print at home. Try it now: <a href="https://app.raffleticketcreator.com/">https://app.raffleticketcreator.com</a></i><br />
<br />
<h2>
Step 1 - Create one basic ticket template</h2>
Create a new document in Word and type in the basic information that you need on your raffle tickets. The event you are raising money for, the price of the ticket, the date of the draw and the prizes that are on offer. Depending on your local laws, you might also need to include a licence number and contact name on each ticket.<br />
<br />
Just use tabs and spaces to lay everything out, rather than tables. This will make it easier later on.<br />
<br />
You might end up with something like this:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjYKMSKHuP1wHye5p_iFa4vYSEYKeuEyPJh3Ri46ICsjmEiyk0itBRzGPL_V3nClN_HMdc8eQUPkvrDHuU6NspC1pq4VDalr0GMkkvMwKHA6MWfcnOVRsNUiT9rTPqVyNGGKNVuTQfMZZ0/s1600/Raffle-ticket-template-for-Word-2016-Step-1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="331" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjYKMSKHuP1wHye5p_iFa4vYSEYKeuEyPJh3Ri46ICsjmEiyk0itBRzGPL_V3nClN_HMdc8eQUPkvrDHuU6NspC1pq4VDalr0GMkkvMwKHA6MWfcnOVRsNUiT9rTPqVyNGGKNVuTQfMZZ0/s640/Raffle-ticket-template-for-Word-2016-Step-1.png" width="640" /></a></div>
<br />
<br />
<h2>
Step 2: Make your template prettier</h2>
Next, maybe add a logo and a border to brighten it up a bit. Remember to leave some space for the ticket numbers to go (we'll add them in a moment).<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1rcQkcs5eZTLKlUdfZDdQB3OvM985KRR-RpfYz__C1zmtqO7sMMSGXKAOmsy_XH76VE98DvLvEhy_J4h96tJmvpxS6t4Ge6SeV_CdjYCKXAcFO9Pna3w8M4i6R8DFIeEjC70_QRacc6U/s1600/Raffle-ticket-template-for-Office-2016-Step2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="416" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1rcQkcs5eZTLKlUdfZDdQB3OvM985KRR-RpfYz__C1zmtqO7sMMSGXKAOmsy_XH76VE98DvLvEhy_J4h96tJmvpxS6t4Ge6SeV_CdjYCKXAcFO9Pna3w8M4i6R8DFIeEjC70_QRacc6U/s640/Raffle-ticket-template-for-Office-2016-Step2.png" width="640" /></a></div>
<br />
<br />
<h2>
Step 3: Create four tickets per page</h2>
Next, copy and paste the whole ticket so you have four tickets on a page. You might need to tinker with your layout a bit to get them all to fit neatly:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjIwSLGV-rVRYd56zpkHX1qW7tDd6_PZJs3P39qt_6Z8jFWTOJIjRiDmFeiKCZPdEgtGOFZw0shT7uFmysULteB6pg-lBt97pFLl1kDjnDcS6R8LZh99EzhFTNs4iUeZyjJc1x3MYwwN-Q/s1600/Print-Raffle-Tickets-At-Home-Step3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjIwSLGV-rVRYd56zpkHX1qW7tDd6_PZJs3P39qt_6Z8jFWTOJIjRiDmFeiKCZPdEgtGOFZw0shT7uFmysULteB6pg-lBt97pFLl1kDjnDcS6R8LZh99EzhFTNs4iUeZyjJc1x3MYwwN-Q/s640/Print-Raffle-Tickets-At-Home-Step3.png" width="446" /></a></div>
<br />
<br />
So, now you have a template ready with four raffle tickets per page. You just need to add numbers to each one.<br />
<br />
<b>Need help getting started? </b>Here is the template I used in the screenshots above, feel free to download it and use it yourself:<br />
<a href="https://s3.amazonaws.com/raffle-ticket-creator/templates/Raffle-ticket-template-in-Word-2016-A4-paper.docx"><br /></a>
<a href="https://s3.amazonaws.com/raffle-ticket-creator/templates/Raffle-ticket-template-in-Word-2016-A4-paper.docx">Download Raffle Ticket Template for Word 2016 (A4 Paper)</a><br />
<br />
<a href="https://s3.amazonaws.com/raffle-ticket-creator/templates/Raffle-ticket-template-in-Word-2016-US-Letter-Paper.docx">Download Raffle Ticket Template for Word 2016 (US Letter Paper)</a><br />
<br />
<br />
<h2>
Step 4: Use Excel to generate your ticket numbers</h2>
Use Excel to generate your list of numbers, which you will then automagically pull into your Word raffle ticket template.<br />
<br />
Open Excel and create a new workbook. In the top left cell (cell A1), type "Ticket Number" (without quotes), and in the cell below that type "1" (again, without quotes). Your sheet should look like this:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi4p8JLJq9VjhCtEUoDJ9ubqGgpjAqMShzHVW1bAqLWK-1LttvG-mMGqLqKpTr270DhLKWonxb6mWlgY175MANN_83yGnbgGZneruCNoDAWE-2bW93SgnIkHRRI2yF5YDPn-Nmf8padXB8/s1600/Word+2016+Raffle+Ticket+Template-Step4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi4p8JLJq9VjhCtEUoDJ9ubqGgpjAqMShzHVW1bAqLWK-1LttvG-mMGqLqKpTr270DhLKWonxb6mWlgY175MANN_83yGnbgGZneruCNoDAWE-2bW93SgnIkHRRI2yF5YDPn-Nmf8padXB8/s640/Word+2016+Raffle+Ticket+Template-Step4.png" width="494" /></a></div>
<br />
In the next row down, type "=A2+1" (without quotes) and hit enter / return:<br />
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgeHj50ivD51EmZ8LR6x4Wy4UZcyKn4L-ykIneGFbcoKKGaQeG8Wel1yTpd_SqxDX6fC52wVXTZLE7qug4wOaHoKvWzd37TBNUrSNP3zPS0I_uNBegg41WBljGist0PdqTtSxyLxMak2No/s1600/Office+2016+Raffle+Ticket+Template+5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgeHj50ivD51EmZ8LR6x4Wy4UZcyKn4L-ykIneGFbcoKKGaQeG8Wel1yTpd_SqxDX6fC52wVXTZLE7qug4wOaHoKvWzd37TBNUrSNP3zPS0I_uNBegg41WBljGist0PdqTtSxyLxMak2No/s640/Office+2016+Raffle+Ticket+Template+5.png" width="514" /></a></div>
<br />
That will put a "2" in that cell, like this:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg1sdvdZnRHBYHiQ-MDjQJegbBdehYlVJlUUl8CgnFx-sLK9M85_hc6UFwK2HlNjmI6EDSfR9cCltsUQsvzUtDq-EouwnGyz-R-rsTGjzOxX_nV7bXwyAZBTe7AKb6hoKFtSOIpJcbYZkk/s1600/Using+Excel+to+create+numbered+raffle+tickets.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg1sdvdZnRHBYHiQ-MDjQJegbBdehYlVJlUUl8CgnFx-sLK9M85_hc6UFwK2HlNjmI6EDSfR9cCltsUQsvzUtDq-EouwnGyz-R-rsTGjzOxX_nV7bXwyAZBTe7AKb6hoKFtSOIpJcbYZkk/s640/Using+Excel+to+create+numbered+raffle+tickets.png" width="513" /></a></div>
<br />
<br />
Now, pay attention to this bit if you are not a regular Excel user. Select the cell with the 2 in it, then carefully click the tiny square at the bottom right of that cell. Click that square and drag the mouse down the screen:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1rcQkcs5eZTLKlUdfZDdQB3OvM985KRR-RpfYz__C1zmtqO7sMMSGXKAOmsy_XH76VE98DvLvEhy_J4h96tJmvpxS6t4Ge6SeV_CdjYCKXAcFO9Pna3w8M4i6R8DFIeEjC70_QRacc6U/s1600/Raffle-ticket-template-for-Office-2016-Step2.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><br /></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEig4-TIvea2Q5wfHb_zKQys3uXJPaK2pkeB0Ez-vGTw4UMwiWoTor2F0jppFdrcxeWGwbmKeOh3uWLn69HHkIvtF5YctNPeYeledTnhcKm-hBQWaxh1doGji3CzOQS63J2LeqbT1D_k8D0/s1600/6c.+Create+Raffle+Tickets+using+Word+and+Excel+2016.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEig4-TIvea2Q5wfHb_zKQys3uXJPaK2pkeB0Ez-vGTw4UMwiWoTor2F0jppFdrcxeWGwbmKeOh3uWLn69HHkIvtF5YctNPeYeledTnhcKm-hBQWaxh1doGji3CzOQS63J2LeqbT1D_k8D0/s640/6c.+Create+Raffle+Tickets+using+Word+and+Excel+2016.png" width="602" /></a></div>
<br />
Keep dragging down and let the sheet scroll up until you get to, say, row 501. That will give you consecutive numbers up to 500. Go as far as you need for the number of raffle tickets you need, like this:<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh80L4B0JRy4QfuROXV8xAgRw15Cyzvuf9wfx80w9s6PK_AsKDgb4T504p_wagDihyIyfwvYk5SrF4KF45zdb_mXynPNDr-wHrnucjNc7RzfyeDTSPxWZLIjLzsN7mTrxHPQ-XqGi906hs/s1600/Raffle+Ticket+Template+for+MS+Office+2016+6.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh80L4B0JRy4QfuROXV8xAgRw15Cyzvuf9wfx80w9s6PK_AsKDgb4T504p_wagDihyIyfwvYk5SrF4KF45zdb_mXynPNDr-wHrnucjNc7RzfyeDTSPxWZLIjLzsN7mTrxHPQ-XqGi906hs/s1600/Raffle+Ticket+Template+for+MS+Office+2016+6.png" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<i>(If you prefer using the keyboard, rather than the mouse, then do this instead of dragging down: select cell A3, hit CTRL+C (or cmd+C on a Mac) to copy, then select cell A4 and use SHIFT+fn+down arrow to select all the way down to row 501. Then hit CTRL+V (or cmd+V on a Mac) to paste.)</i> </div>
<br />
<b>Now save your spreadsheet somewhere that you can find it again, and close Excel.</b><br />
<br />
<h2>
Step 5: Pull your ticket numbers into your Word template</h2>
Go back to your raffle ticket template in Word 2016 and go to Mailings > Select Recipients > Use Existing List:<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhIWtqrFUb-_Tc48kuyW6z9tcV5Alt2rmNtqON8e4Xcvk_XNo6FxzBR6D7i3trqSL93Q44l0Z5Ml-e-lLtrK_QkTf72t5yGeVYLRrzPyJ_mLt3qhizWYkkZj57GMhOHEVw-rASDs6zfUDs/s1600/Raffle+Ticket+Mail+Merge+Tips+Step+7.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhIWtqrFUb-_Tc48kuyW6z9tcV5Alt2rmNtqON8e4Xcvk_XNo6FxzBR6D7i3trqSL93Q44l0Z5Ml-e-lLtrK_QkTf72t5yGeVYLRrzPyJ_mLt3qhizWYkkZj57GMhOHEVw-rASDs6zfUDs/s1600/Raffle+Ticket+Mail+Merge+Tips+Step+7.png" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Navigate to the Excel spreadsheet which you created earlier with your raffle ticket numbers. Click 'OK' to the next two questions (and "Allow" if you also get some security questions):</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgwYFhME-NFMCJuzzrpaWgm9CX-pD7itLtNRZg65GPBmbf29DvmAtHLXYGYTe7rr7zkXkVxY_7MSLXr6v5TygG7m7nIuIRXFnekgwwWvhN28QPDvoZrdMQuS_DWZiP2agiNJnz2nFf5l6E/s1600/Excel+2016+Raffle+Ticket+Template+8.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgwYFhME-NFMCJuzzrpaWgm9CX-pD7itLtNRZg65GPBmbf29DvmAtHLXYGYTe7rr7zkXkVxY_7MSLXr6v5TygG7m7nIuIRXFnekgwwWvhN28QPDvoZrdMQuS_DWZiP2agiNJnz2nFf5l6E/s1600/Excel+2016+Raffle+Ticket+Template+8.png" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhqY5AqNiTNXurp54qVkUx-w2lYsMkrFchZqmlg6faIXiLBXQ5OeME3mqvqU8IJ-TlLyD9hxGS-M_B5PSbPdZQqJQUKOIZvfH9c2gh4JAVzy6q4SJnbL7rzEIGJszPRhfELcBLPLTTVTi4/s1600/Excel+Raffle+Ticket+Template+9.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhqY5AqNiTNXurp54qVkUx-w2lYsMkrFchZqmlg6faIXiLBXQ5OeME3mqvqU8IJ-TlLyD9hxGS-M_B5PSbPdZQqJQUKOIZvfH9c2gh4JAVzy6q4SJnbL7rzEIGJszPRhfELcBLPLTTVTi4/s1600/Excel+Raffle+Ticket+Template+9.png" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Now place your cursor where you want the ticket number to appear. Then in the menu ribbon, go to Mailings and click "Insert Merge Field". Select "Ticket_Number" (which should be the only option which appears):</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEivAQKS1yACTzFnZ4EHMYTPPqUzhbspgYi_V9qzubXgivj8p9k_CBE_jJL_2Dpjkty5oOkPatcVUhAwTdCmJId81GyUzZNCc1-QNU0ZxSifTXC96IUnbPue9xeZgvSX-breL-JmKEC-FJU/s1600/10.+Raffle+Ticket+Template+in+Office+2016.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEivAQKS1yACTzFnZ4EHMYTPPqUzhbspgYi_V9qzubXgivj8p9k_CBE_jJL_2Dpjkty5oOkPatcVUhAwTdCmJId81GyUzZNCc1-QNU0ZxSifTXC96IUnbPue9xeZgvSX-breL-JmKEC-FJU/s1600/10.+Raffle+Ticket+Template+in+Office+2016.png" /></a></div>
<br />
That will insert a placeholder where your ticket number will appear:<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjK8qeXsQuPfUtNwcsXs6RH71py3mfs1w9S1nnKTF_svyCld_wGbtSPo3W2L4y8RymcVjQbZBKWiv5DszZcVezE4YqgX-7JvlDVAqH7M182ZYgnF4LZbNJ-6gqkjbasR0x-s3cgNJkcohU/s1600/11.+Free+Raffle+Ticket+Template+for+Word+and+Excel+Office+2016.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjK8qeXsQuPfUtNwcsXs6RH71py3mfs1w9S1nnKTF_svyCld_wGbtSPo3W2L4y8RymcVjQbZBKWiv5DszZcVezE4YqgX-7JvlDVAqH7M182ZYgnF4LZbNJ-6gqkjbasR0x-s3cgNJkcohU/s1600/11.+Free+Raffle+Ticket+Template+for+Word+and+Excel+Office+2016.png" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
(If that's not in the correct place, just delete the placeholder, put your cursor in the correct spot, then hit "Insert Merge Field" again.)<br />
<br />
Repeat this for each place where you need the ticket number to appear on your raffle ticket template. Most likely, you'll need it on each counterfoil and each main ticket, so eight in total, like this:<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZ-QPJiU6uiLE_PbRsgtKlOIirpm_9FDl7L2U326Wrhk77mHig-8F4tdpXsQSpCLosVHB01R3FoGsT8MiJGV0MFqsDkDCwPZBfyBar7o1DSMK03zZ-P1zRxkcu_of4D_Ycywe5Cy-QbiQ/s1600/12.+Word+2016+Raffle+Ticket+Template+Free.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZ-QPJiU6uiLE_PbRsgtKlOIirpm_9FDl7L2U326Wrhk77mHig-8F4tdpXsQSpCLosVHB01R3FoGsT8MiJGV0MFqsDkDCwPZBfyBar7o1DSMK03zZ-P1zRxkcu_of4D_Ycywe5Cy-QbiQ/s640/12.+Word+2016+Raffle+Ticket+Template+Free.png" width="403" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<br />
<h2>
Step 6: Tell Word to put a new number on each ticket</h2>
Now for the tricky bit. Pay attention, Bond. A Mail Merge normally has just one "recipient" per page. So Word won't move on to the next number in your list until it gets on to the <i>next page</i>. But you need a new number for <i>each ticket</i>.<br />
<br />
To tell Word to change the number for each ticket in your template, you need to insert a special "Next Record" marker on each ticket.<br />
<br />
Put your cursor just after the second Ticket Number placeholder on the first ticket:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjJjN8ecB-HamwIUu7iXzmGFHd3nKX2BejaR4YXcNKDBUCttKofimNRRS9Q4rDOrDpZU_eUeInFKOfUFg93kWJ3fmRxyjCQK7R6eQMK7AqWtnZpwpNZ9WyL6mYS3X8H2iW1IWZsKDKWbSs/s1600/Cursor+in+the+right+place+on+raffle+ticket+template.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjJjN8ecB-HamwIUu7iXzmGFHd3nKX2BejaR4YXcNKDBUCttKofimNRRS9Q4rDOrDpZU_eUeInFKOfUFg93kWJ3fmRxyjCQK7R6eQMK7AqWtnZpwpNZ9WyL6mYS3X8H2iW1IWZsKDKWbSs/s1600/Cursor+in+the+right+place+on+raffle+ticket+template.png" /></a></div>
<br />
Then in the Mailings section of the ribbon click the little question mark button and select "Next Record":<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiwL-UI6kKx5y2m1QVf9g-igpnSTVLW5ziuRDIj-lx_JpQj_1Y8JjCRu8DO0zHuK-VDq1IkYUKobKvNPfTp7UWzHU0Y_QlL3hNLbKQHb5r41Cf2N74rnMEWl6LXjooG_T7HL-cr9KjR43E/s1600/13.+Print+raffle+tickets+at+home.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiwL-UI6kKx5y2m1QVf9g-igpnSTVLW5ziuRDIj-lx_JpQj_1Y8JjCRu8DO0zHuK-VDq1IkYUKobKvNPfTp7UWzHU0Y_QlL3hNLbKQHb5r41Cf2N74rnMEWl6LXjooG_T7HL-cr9KjR43E/s1600/13.+Print+raffle+tickets+at+home.png" /></a></div>
<br />
That will insert another placeholder called "Next Record". You'll see it like this:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhba7Qu1qQUfHEuWZy1aFIUDln8N4UXokR0kGe9a9Oq-SN3-8t9EJxKSg8ffMhd1ZuR2jtt7nUlriFTtCv14oKL8rU6Bc6fo285qDnFs-EHnwmJd3GyIOSlLpFJs2bMJSGsR9cQv-EKRdE/s1600/Next+Record+Mail+Merge+Field+for+raffle+ticket.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="346" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhba7Qu1qQUfHEuWZy1aFIUDln8N4UXokR0kGe9a9Oq-SN3-8t9EJxKSg8ffMhd1ZuR2jtt7nUlriFTtCv14oKL8rU6Bc6fo285qDnFs-EHnwmJd3GyIOSlLpFJs2bMJSGsR9cQv-EKRdE/s640/Next+Record+Mail+Merge+Field+for+raffle+ticket.png" width="640" /></a></div>
<br />
Repeat this for the second and third tickets on your template, <b>but not for the last ticket on the page</b> (because Word will move to the next number at the start of the next page anyway):<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEik0DCM5PWdir7BYi-D7wdmjLJse6UKOG6CVnG97OBhyphenhyphenaBRmxsuwumWv8LbvHPFNmCoGEEkbY7rdzXUL_Wp3NJXikVrc_s4h2hCZYFtTnBxBJs8RHC8EYvqOxBPYvGShRelDy0hychBZXQ/s1600/14.+Create+Raffle+Tickets+and+print+at+home.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEik0DCM5PWdir7BYi-D7wdmjLJse6UKOG6CVnG97OBhyphenhyphenaBRmxsuwumWv8LbvHPFNmCoGEEkbY7rdzXUL_Wp3NJXikVrc_s4h2hCZYFtTnBxBJs8RHC8EYvqOxBPYvGShRelDy0hychBZXQ/s640/14.+Create+Raffle+Tickets+and+print+at+home.png" width="433" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<b>Nearly there now!</b><br />
<br />
<h2>
Step 7: Run the merge to create one printable document with all your raffle tickets</h2>
Now you can run your mail merge to generate one big document of tickets and every ticket will have a unique number.<br />
<br />
Click on 'Finish & Merge':<br />
<br />
<div style="text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgmvOfM0wyx1uto0Wl_kJtLUy5ZrC9Wi722hoOaT3FNHbGVo-o0VRGOMjFM8aRj4XC-v8od9kdvzsKhW4aTygEtC_TcPbyg2YlEdQvnIyZcfJj4JEYgGCE6u-s-tYlUOHvuWG2RyBKFRp8/s1600/Word+2016+Raffle+Ticket+Mail+Merge.png" imageanchor="1"><img border="0" height="148" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgmvOfM0wyx1uto0Wl_kJtLUy5ZrC9Wi722hoOaT3FNHbGVo-o0VRGOMjFM8aRj4XC-v8od9kdvzsKhW4aTygEtC_TcPbyg2YlEdQvnIyZcfJj4JEYgGCE6u-s-tYlUOHvuWG2RyBKFRp8/s640/Word+2016+Raffle+Ticket+Mail+Merge.png" width="640" /></a></div>
<br />
Then click 'Edit individual documents':<br />
<br />
<div style="text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgt3kGqQ_sYkmd6Ne0U05sygjYpWEd0gddxQe59hVGRQOixbEv8wZBZF5KkHsTBDKSEKsKf6Q9cpTG6u3O0tQgLrtdLGRfCY_-Fs43mgo4XxYAQXyK-wOIDUnCozKVyi1nqpNzrUSa7tyg/s1600/Create+Word+Document+for+Raffle+Tickets.png" imageanchor="1"><img border="0" height="143" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgt3kGqQ_sYkmd6Ne0U05sygjYpWEd0gddxQe59hVGRQOixbEv8wZBZF5KkHsTBDKSEKsKf6Q9cpTG6u3O0tQgLrtdLGRfCY_-Fs43mgo4XxYAQXyK-wOIDUnCozKVyi1nqpNzrUSa7tyg/s640/Create+Word+Document+for+Raffle+Tickets.png" width="640" /></a></div>
<br />
<br />
Word will whirr away and create a new document, with all your raffle tickets in it and each one will have a unique number:<br />
<br />
<div style="text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgRW1PMANzbO4LGXUpj_UQLYmnjIjEvpe9mHZfLPTO6ShS6lAfO1tJWJjbfY8Z0nzEwx-f7nfF2B2QWueU6jET8_Y_rGXrLokTJB9H0rkMEtZ2xTF1V4O9GCXa90zEN_SENLlV48hH6n64/s1600/16.+MS+Office+2016+Raffle+Tickets.png" imageanchor="1"><img border="0" height="573" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgRW1PMANzbO4LGXUpj_UQLYmnjIjEvpe9mHZfLPTO6ShS6lAfO1tJWJjbfY8Z0nzEwx-f7nfF2B2QWueU6jET8_Y_rGXrLokTJB9H0rkMEtZ2xTF1V4O9GCXa90zEN_SENLlV48hH6n64/s640/16.+MS+Office+2016+Raffle+Tickets.png" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
That's it! Print this document and you are done. Give yourself a big pat on the back!</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<h3 style="clear: both; text-align: left;">
Numbers not in the right place? Fear not.</h3>
<div class="separator" style="clear: both; text-align: left;">
You might find your numbers don't quite appear in the correct place in your finished document:</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh3mynF1bu4RPj2h5WK59eDmq7OBGu13P3Xr3XrJ_6oA6ziyeXryzMZVlzAJfdEqLWXk3ZB-Y3epINLwboPp8DY0t3qN5V3-Vz57Hi4k3kf5VayCFt7B9T_K2EE9r7xq_jYcS_maFPP0mc/s1600/15.+Print+Raffle+Tickets+at+home.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><br /></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhAoVx2c5L_IAIL1sIoBe4TImDuKBy-e54iNiL0XqKmZhoVZuZ0q37byd0U54sqP0OArIgeJBcByUgwYsfyb-cuH-aeCa_UzeCFOxo46MMNktUBrrlEWoLhZNJ-IbStiaXyX_3NZhYs-z0/s1600/15.+Print+Raffle+Tickets+at+home.png" imageanchor="1"><img border="0" height="284" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhAoVx2c5L_IAIL1sIoBe4TImDuKBy-e54iNiL0XqKmZhoVZuZ0q37byd0U54sqP0OArIgeJBcByUgwYsfyb-cuH-aeCa_UzeCFOxo46MMNktUBrrlEWoLhZNJ-IbStiaXyX_3NZhYs-z0/s640/15.+Print+Raffle+Tickets+at+home.png" width="640" /></a></div>
<br />
Easy to fix. Close the new document which Word just created (don't bother to save it). Go back to your main template document and just move the placeholder further to the right. It'll look odd, because the placeholders take up more space than the real numbers, so the layout looks messed up. Something like this:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEipROBHApV4vAQo9Vht5LshMiMQ0CB8g0Arjxq_v0BT1HCFSOr-XECmpdk5f6cVyoTvwVNgHUU1F1JiYcbZ80FxMq5flpaf0LNsn8csiU5YBL50a8_fAcGXXkncPx-1jd7PpH99VA7rnoE/s1600/Word+Mail+Merge+Position+Placeholders+Correctly.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="333" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEipROBHApV4vAQo9Vht5LshMiMQ0CB8g0Arjxq_v0BT1HCFSOr-XECmpdk5f6cVyoTvwVNgHUU1F1JiYcbZ80FxMq5flpaf0LNsn8csiU5YBL50a8_fAcGXXkncPx-1jd7PpH99VA7rnoE/s640/Word+Mail+Merge+Position+Placeholders+Correctly.png" width="640" /></a></div>
<br />
Then click "Preview Results" in the Mailings Ribbon and check where your number is now. Adjust the spacing again if necessary until your number appears in the right place:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi7MrdPMtjRhZiNq3kKwFEAbb7WF_HDb20aaQhteMMRBhbz8rftbqtOYfUOkXfWMY0bq3914B7Pu1N6h25nTq7nrPTkE_OL5YRNRiOCe2ceqFWOt49y9ZAnC2R8DK-OEi094yGkCSNkhdo/s1600/Preview+Raffle+Tickets+in+Word+Template.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="248" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi7MrdPMtjRhZiNq3kKwFEAbb7WF_HDb20aaQhteMMRBhbz8rftbqtOYfUOkXfWMY0bq3914B7Pu1N6h25nTq7nrPTkE_OL5YRNRiOCe2ceqFWOt49y9ZAnC2R8DK-OEi094yGkCSNkhdo/s400/Preview+Raffle+Tickets+in+Word+Template.png" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Then complete your merge as before (Finish & Merge > Edit Individual Documents) and print it out.</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
**************</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Not got half a day to spend fiddling around with Word 2016 to print raffle tickets? Try <a href="http://app.raffleticketcreator.com/">Raffle Ticket Creator</a> instead: just enter the details of your event into a web page and Raffle Ticket Creator will generate a PDF for you with all your tickets in it ready to print!</div>
<br />Bruce Ghttp://www.blogger.com/profile/09056360686702009784noreply@blogger.com23tag:blogger.com,1999:blog-4708941817257238261.post-12050070454404952382014-11-28T02:01:00.003-08:002022-08-24T03:15:28.861-07:00Printable raffle tickets<h2>
Here are some free printable raffle ticket templates for Word:</h2>
<br />
<h2>
<a href="https://docs.google.com/document/d/0B-8c7zKCkTFqWGp0WVRVMXZNQzg/edit?usp=sharing&ouid=104845262310699931341&resourcekey=0-QF_FRSyTmo3zzc5D-mXrPw&rtpof=true&sd=true">Printable Raffle Ticket Template for Word (A4 paper)</a></h2>
<h2>
<a href="https://docs.google.com/document/d/0B-8c7zKCkTFqLU5yc1FHdHBQSG8/edit?usp=sharing&ouid=104845262310699931341&resourcekey=0-9pODHqvU6_XQa5-yIwfw3w&rtpof=true&sd=true">Printable Raffle Ticket Template for Word (US Letter paper)</a></h2>
<br />
You'll find instructions for using these printable raffle ticket templates here:<br />
<b><br /></b>
<a href="http://www.raffleticketcreator.com/2016/07/print-raffle-tickets-using-template-in.html"><b>Update: New instructions here for printing raffle tickets from Word 2016 (Mac or PC)</b></a><br />
<br />
<a href="http://www.raffleticketcreator.com/2014/01/print-numbered-raffle-tickets-at-home.html">Instructions for making printable raffle tickets in Word for PC</a><br />
<a href="http://www.raffleticketcreator.com/2014/01/create-numbered-raffle-tickets-in-word.html">Instructions for making printable raffle tickets in Word for Mac</a><br />
<a href="http://www.raffleticketcreator.com/2012/02/print-raffle-tickets-on-your-own.html">Instructions for making printable raffle tickets in Publisher</a><br />
<br />
<b>You'll need to follow the instructions carefully in order to get Word to put a different number on every raffle ticket (kinda important for a raffle!).</b><br />
<br />
If you don't have Word, or can't be bothering with the rather fiddly process you have to go through to get Word to print a different number on every raffle ticket, try this online tool instead:<br />
<br />
<a href="http://app.raffleticketcreator.com/">Make printable raffle tickets online with Raffle Ticket Creator</a><br />
<br />
The online tool, Raffle Ticket Creator, lets you make printable raffle tickets directly in your web browser. Nothing to download. No fiddling around with hidden merge fields and whatnot in Word.Bruce Ghttp://www.blogger.com/profile/09056360686702009784noreply@blogger.com3tag:blogger.com,1999:blog-4708941817257238261.post-48637923879259561922014-07-18T03:44:00.003-07:002014-09-02T01:50:39.973-07:00Five things you need to know about the law on running a fundraising raffle in TexasFundraising raffles are legal in Texas, but there are some restrictions. Here are the key things that you need to know:<br />
<br />
<h2>
1. Who can run a raffle in Texas?</h2>
Only certain non-profit organisations can run raffles in Texas. Your organisation must be one of the following three types:<br />
<br />
- A non-profit <b>firefighting</b> or <b>medical</b> organisation which does not pay its members anything more than nominal compensation<br />
<br />
- A non-profit <b>religious</b> organisation that has been <b>in existence in Texas for at least 10 years</b><br />
<i><br /></i>
- Another non-profit organisation <b>registered with the IRS</b> that is <b>non-political</b> and <b>run entirely by volunteers</b> that <b>has existed for at least 3 years</b><br />
<br />
<br />
<h2>
2 Only two per year</h2>
Your fundraising organisation can only run two raffles per year, and only one raffle at a time<br />
<br />
<h2>
3 No cash prizes allowed</h2>
You cannot offer cash prizes, and no prize can be worth more than $50,000 (unless the prize is a home, then the limit is $250,000)<br />
<br />
<h2>
4 Tickets must include certain details</h2>
Each ticket must state the <b>name and address</b> of your organization; the ticket price; a <b>description of each prize</b> having a value of more than $10; and the <b>date of the draw</b>.<br />
<br />
<br />
<h2>
5 No need to register</h2>
Unlike in some states, in Texas you <b>don't</b> need to register your raffle or provide any annual report about your raffle. Yay!<br />
<br />
<br />
<br />
Full details are here on the Texas Attorney General's website:<br />
<br />
<h2>
<a href="http://www.texasattorneygeneral.gov/consumer/raffle.shtml">www.texasattorneygeneral.gov/consumer/raffle.shtml</a></h2>
<div>
<br /></div>
<div>
*********<br />
Want to print raffle tickets at home on your own printer? Use this app to help you: <a href="http://app.raffleticketcreator.com/">Raffle Ticket Creator App</a></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<br />Bruce Ghttp://www.blogger.com/profile/09056360686702009784noreply@blogger.com0tag:blogger.com,1999:blog-4708941817257238261.post-375073740950621922014-07-15T03:36:00.000-07:002014-07-18T03:26:11.256-07:00Five things you need to know about the law on non-profit raffles in CaliforniaIn some states raffles are illegal even for non-profits. But, fortunately for fund-raisers, raffles are permitted in California if your organisation meets these criteria:<br />
<br />
<h2>
1</h2>
Your organisation must be a non-profit organisation<br />
<br />
<br />
<h2>
2</h2>
Your organisation must have been operating in California for at least one year<br />
<br />
<br />
<h2>
3</h2>
You must give 90% of the proceeds of the raffle to the organisation. Yep, this means that <a href="http://oag.ca.gov/charities/faq#s9">50:50 raffles are illegal in California</a> (in a 50:50 raffle 50% of the proceeds go into a prize fund, and therefore only 50% goes to the organisation. Raffles in California are only legal if 90% of the proceeds go to the nonprofit organisation.)<br />
<br />
<h3>
And, <i>unless</i> you are a nonprofit religious organization, educational institution, or hospital, you must <i>also</i>:</h3>
<br />
<h2>
4</h2>
Register your raffle with the Attorney General’s office prior to conducting the raffle (using <a href="http://oag.ca.gov/sites/all/files/agweb/pdfs/charities/raffle/ct_nrp_1.pdf">Form CT NRP 1</a>)<br />
<br />
<br />
<h2>
5</h2>
Report annually on your raffle takings and expenses (using <a href="http://oag.ca.gov/sites/all/files/agweb/pdfs/charities/raffle/ct_nrp_2.pdf">Form CT NRP 2</a>)<br />
<br />
(<i>Nonprofit religious organizations, educational institutions, and hospitals are exempt from registering and reporting their raffles, but still have to comply with the other rules like the 90% rule.)</i><br />
<br />
Registration forms and more details are available on the Attorney General’s website:<br />
<br />
<h2>
<a href="http://oag.ca.gov/charities/raffles">oag.ca.gov/charities/raffles</a></h2>
<br />
*********<br />
Want to print raffle tickets at home on your own printer? Use this app to help you: <a href="http://app.raffleticketcreator.com/">Raffle Ticket Creator App</a><br />
<br />
<br />
<br />
<br />Bruce Ghttp://www.blogger.com/profile/09056360686702009784noreply@blogger.com3tag:blogger.com,1999:blog-4708941817257238261.post-43878705528115359922014-01-29T02:21:00.002-08:002022-08-24T03:13:38.481-07:00Templates To Create Professional NUMBERED Raffle TicketsYour fundraising team will love you! You can make NUMBERED raffle tickets yourself and print them at home using this template and step-by-step instructions.<br />
<br />
How do I create numbered raffle tickets in Word? Here’s the short answer:<br />
<br />
<ol>
<li>Create your ticket layout in Word using the template below</li>
<li>Make a list of numbers in Excel</li>
<li>Back in Word, use MailMerge to pull the numbers into your ticket template</li>
<li>Secret step: use the <<NextRecord>> tag to get a different number on each ticket</li>
<li>Run your merge and print out your tickets</li>
</ol>
<br />
See links below for detailed instructions for Word and Publisher.<br />
<br />
Here are the templates:<br />
<h2>
<a href="https://docs.google.com/document/d/0B-8c7zKCkTFqWGp0WVRVMXZNQzg/edit?usp=sharing&ouid=104845262310699931341&resourcekey=0-QF_FRSyTmo3zzc5D-mXrPw&rtpof=true&sd=true">Raffle Ticket Template for Word (A4 paper)</a></h2>
<h2>
<a href="https://docs.google.com/document/d/0B-8c7zKCkTFqLU5yc1FHdHBQSG8/edit?usp=sharing&ouid=104845262310699931341&resourcekey=0-9pODHqvU6_XQa5-yIwfw3w&rtpof=true&sd=true">Raffle Ticket Template for Word (US Letter paper)</a></h2>
<h2>
<a href="http://app.raffleticketcreator.com/">Online Template (doesn't need Word, and works for A4 or US Letter)</a></h2>
<br />
Here are the detailed instructions:<br />
<br />
<b><a href="http://www.raffleticketcreator.com/2016/07/print-raffle-tickets-using-template-in.html">Instructions for printing raffle tickets with Word 2016 (Mac and PC)</a></b><br />
<br />
<a href="http://www.raffleticketcreator.com/2014/01/create-numbered-raffle-tickets-in-word.html">Instructions for printing raffle tickets with older versions of Word for Mac</a><br />
<br />
<a href="http://www.raffleticketcreator.com/2014/01/print-numbered-raffle-tickets-at-home.html">Instructions for printing raffle tickets with older versions of Word for PC</a><br />
<br />
<a href="http://www.raffleticketcreator.com/2012/02/print-raffle-tickets-on-your-own.html">Instructions for printing raffle tickets with Publisher</a><br />
<br />
Allow a couple of hours of fiddling around to get your tickets ready.<br />
<br />
<b>Or, do it in a few minutes using <a href="http://app.raffleticketcreator.com/">this simple online tool</a>, which I built to make it easier for people to print numbered raffle tickets from their own computer:</b><br />
<b><br /></b>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://app.raffleticketcreator.com/"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjnr8wAW55sr6UtUEnDG6EmveDBkJYXERR_MDz208rizaXNWsBFcPgyaCSFqDjpMmnGAUV9cJWg2GEvb7I1uK6HVu35Ako2mkIS0Spe71dr7gop9AQWo-gMgFeke6qmA_69YVM9G8k_DHo/s1600/Numbered-raffle-tickets.png" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://app.raffleticketcreator.com/"><img alt="http://app.raffleticketcreator.com" border="0" height="262" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDwL1Gjs8CdfOpLqtWukzuF2pE-ngHi-4Zopi31bbvOGwEIphn87Qz-8FGUnMWnqcjqmKvqC8xY9kF4NtSTKP54tothtAtB5QkD93IWQ3nSmspx2maRC9fPX27i2maYSLP7AUbFYui9nI/s1600/Raffle-ticket-creator-square.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<br />
<br />
<br />Bruce Ghttp://www.blogger.com/profile/09056360686702009784noreply@blogger.com9tag:blogger.com,1999:blog-4708941817257238261.post-81011358728499790022014-01-14T04:58:00.001-08:002017-03-02T01:44:16.760-08:00Print numbered tickets in Word | Raffle Ticket Creator<h2>
Printable numbered tickets in Word 2007: step-by-step instructions</h2>
<br />
<b><a href="http://www.raffleticketcreator.com/2016/07/print-raffle-tickets-using-template-in.html">Note: Updated version for Word 2016 is here</a></b><br />
<br />
(<a href="http://www.raffleticketcreator.com/2014/01/create-numbered-raffle-tickets-in-word.html">Instructions for Word for Mac 2011 are here</a>. And <a href="http://www.raffleticketcreator.com/2012/02/print-raffle-tickets-on-your-own.html">instructions for Publisher are here.</a>)<br />
<br />
You'll create a document with several raffle tickets on each page, as many as you need, and each ticket will have a unique number. In other words: a template of printable numbered tickets.<br />
<br />
<h2>
<b>Step 1. Create your basic numbered raffle ticket template in Word</b></h2>
Open Word and create a new document and create one raffle ticket. You want to make it about the right size so that you can fit four tickets on the page. Leave space for the ticket numbers, which you'll add in a minute. Something like this:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEihw8XkcgCdEhFY28zYgNh7cQ_0zm-IEHsEfRupwHG_q2J6eDjQWCjHLFuQ9LmcOFkizyE5OMQHId64iLnjDX3rUHmhndENavyEDzCwR1UgMGzgjQjL3LuDFMVZkwjF0MNG3IFxiov3mYI/s1600/raffleticket1..png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="286" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEihw8XkcgCdEhFY28zYgNh7cQ_0zm-IEHsEfRupwHG_q2J6eDjQWCjHLFuQ9LmcOFkizyE5OMQHId64iLnjDX3rUHmhndENavyEDzCwR1UgMGzgjQjL3LuDFMVZkwjF0MNG3IFxiov3mYI/s640/raffleticket1..png" width="640" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
Then maybe add some color and design to it:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjk9lPYS0e_zx3RZGw6oFrORpZWd2X0jJT_jobLa6lu6cfsnjho_-tyxfiC_O1glPXKZ0iZmnnJhaso617ZZQOO48oEK8W8-vVbOgWSYrxf3fd0gZvPyRgVlpWKGCg8kPQ4ufX4aFgBnWk/s1600/raffleticket1apng..png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="336" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjk9lPYS0e_zx3RZGw6oFrORpZWd2X0jJT_jobLa6lu6cfsnjho_-tyxfiC_O1glPXKZ0iZmnnJhaso617ZZQOO48oEK8W8-vVbOgWSYrxf3fd0gZvPyRgVlpWKGCg8kPQ4ufX4aFgBnWk/s640/raffleticket1apng..png" width="640" /></a></div>
<br />
<h2>
<b>Step 2 Create a single page of tickets</b></h2>
Once you are happy with your basic layout, copy everything three times so you have a page of four tickets. At this point, they won't be numbered tickets just yet, you will add the numbers in a moment:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhEzKXtAi8eg9CooYip_WFePIs_qmd8IdQSc0SqaIh-MNTepv-IY2SifEcSAkMQTlh2leHamiu8sa0Gp1LcoJSLoaTxH_JHvF_K4S-wFCnxTg4Lo9zLGUTXLs9LXweeUkt24tJU6R4CLVk/s1600/raffleticket2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhEzKXtAi8eg9CooYip_WFePIs_qmd8IdQSc0SqaIh-MNTepv-IY2SifEcSAkMQTlh2leHamiu8sa0Gp1LcoJSLoaTxH_JHvF_K4S-wFCnxTg4Lo9zLGUTXLs9LXweeUkt24tJU6R4CLVk/s640/raffleticket2.png" width="440" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<h2>
Step 3 - Create a list of numbers, in Excel</h2>
<span style="background-color: white; color: #333333; font-family: "helvetica neue light" , , "helvetica neue" , "helvetica" , "arial" , sans-serif; font-size: 14px; line-height: 19px; text-align: justify;">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):</span><br />
<br style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; text-align: justify;" />
<div class="separator" style="background-color: white; clear: both; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; margin: 0px; outline: none; padding: 0px; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjdznfbE8G4rvK_Ts4q92PLVCDISaKOaK77zWBhAXAiLQCq_rYk3J2CygUV-x9OX6blaxHaIi4VJ7HN7HeFJwu7jDmJ-H1atSFEdze_sTjrQtxf1CkzzoQ1GDGYPpI_Ckg7jGUB9-9l3V4/s1600/raffle-ticket-numbering.png" imageanchor="1" style="-webkit-transition: color 0.3s; color: #009eb8; display: inline; margin-bottom: 0px !important; margin-left: 1em; margin-right: 1em; margin-top: 0px !important; outline: none; text-decoration: none; transition: color 0.3s;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjdznfbE8G4rvK_Ts4q92PLVCDISaKOaK77zWBhAXAiLQCq_rYk3J2CygUV-x9OX6blaxHaIi4VJ7HN7HeFJwu7jDmJ-H1atSFEdze_sTjrQtxf1CkzzoQ1GDGYPpI_Ckg7jGUB9-9l3V4/s1600/raffle-ticket-numbering.png" style="-webkit-border-image: url(data:image/png; border-image-repeat: stretch; border-image-slice: 9; border-image-source: url(data:image/png; border-image-width: 9px; border: 9px none; box-sizing: border-box; display: inline-block; height: auto; margin: 10px auto; max-width: 100%; padding: 8px; position: relative;" /></a></div>
<br style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; text-align: justify;" />
<span style="background-color: white; color: #333333; font-family: "helvetica neue light" , , "helvetica neue" , "helvetica" , "arial" , sans-serif; font-size: 14px; line-height: 19px; text-align: justify;">In the cell below, type "=A1+1" (without quotes) and hit enter/return:</span><br />
<br style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; text-align: justify;" />
<div class="separator" style="background-color: white; clear: both; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; margin: 0px; outline: none; padding: 0px; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjdH2WPeHbq4cFausdtH_Wgfmv7R0H5MlHEeFVfb4m7KhIA0fFzkmd-iwz9xYSCQokUdvB_MGiJmMB-4lU6kb4aHjsfffr8kG6FXQY_ZYX1NJknDh4bx5FBGe6f-CqcxQxWOBJ0R69iYkc/s1600/raffle-ticket-unique-numbering.png" imageanchor="1" style="-webkit-transition: color 0.3s; color: #009eb8; display: inline; margin-bottom: 0px !important; margin-left: 1em; margin-right: 1em; margin-top: 0px !important; outline: none; text-decoration: none; transition: color 0.3s;"><img border="0" class="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjdH2WPeHbq4cFausdtH_Wgfmv7R0H5MlHEeFVfb4m7KhIA0fFzkmd-iwz9xYSCQokUdvB_MGiJmMB-4lU6kb4aHjsfffr8kG6FXQY_ZYX1NJknDh4bx5FBGe6f-CqcxQxWOBJ0R69iYkc/s1600/raffle-ticket-unique-numbering.png" style="-webkit-border-image: url(data:image/png; border-image-repeat: stretch; border-image-slice: 9; border-image-source: url(data:image/png; border-image-width: 9px; border: 9px none; box-sizing: border-box; display: inline-block; height: auto; margin: 10px auto; max-width: 100%; padding: 8px; position: relative;" /></a></div>
<br style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; text-align: justify;" />
<span style="background-color: white; color: #333333; font-family: "helvetica neue light" , , "helvetica neue" , "helvetica" , "arial" , sans-serif; font-size: 14px; line-height: 19px; text-align: justify;">That'll put a 2 in that cell, like this:</span><br />
<br style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; text-align: justify;" />
<div class="separator" style="background-color: white; clear: both; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; margin: 0px; outline: none; padding: 0px; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgrXfkVZBv_k77MLgZOt4cIA9_OFUfSiN6QAyFmE84BP3e0wj3CJVyxz4eqpbVfoerJbhsTajMAmQ7uEmLy3rFskOVcNqUHGiyuKc9QOao70ridPFtkMrivPtJrt3vsi5b1dBeen-qfbAE/s1600/raffle-ticket-numbers.png" imageanchor="1" style="-webkit-transition: color 0.3s; color: #009eb8; display: inline; margin-bottom: 0px !important; margin-left: 1em; margin-right: 1em; margin-top: 0px !important; outline: none; text-decoration: none; transition: color 0.3s;"><img border="0" class="" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgrXfkVZBv_k77MLgZOt4cIA9_OFUfSiN6QAyFmE84BP3e0wj3CJVyxz4eqpbVfoerJbhsTajMAmQ7uEmLy3rFskOVcNqUHGiyuKc9QOao70ridPFtkMrivPtJrt3vsi5b1dBeen-qfbAE/s320/raffle-ticket-numbers.png" style="-webkit-border-image: url(data:image/png; border-image-repeat: stretch; border-image-slice: 9; border-image-source: url(data:image/png; border-image-width: 9px; border: 9px none; box-sizing: border-box; display: inline-block; height: auto; margin: 10px auto; max-width: 100%; padding: 8px; position: relative;" width="225" /></a></div>
<br style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; text-align: justify;" />
<span style="background-color: white; color: #333333; font-family: "helvetica neue light" , , "helvetica neue" , "helvetica" , "arial" , sans-serif; font-size: 14px; line-height: 19px; text-align: justify;">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:</span><br />
<br style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; text-align: justify;" />
<div class="separator" style="background-color: white; clear: both; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; margin: 0px; outline: none; padding: 0px; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhq3eId9R_Hr6pyCD1uPYN1ZQrG6FHgC1lwzAjRbnB_R-kOeJLqSLCgZqsinvUoKCt9lgqMDjpxMombXVBca1u8exkCwpl1PslHjfjvBW0aw5IvCfgfoEVvh2CdiN0E9PTMC4GDIWasqfc/s1600/raffle-ticket-add-unique-numbers.png" imageanchor="1" style="-webkit-transition: color 0.3s; color: #009eb8; display: inline; margin-bottom: 0px !important; margin-left: 1em; margin-right: 1em; margin-top: 0px !important; outline: none; text-decoration: none; transition: color 0.3s;"><img border="0" class="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhq3eId9R_Hr6pyCD1uPYN1ZQrG6FHgC1lwzAjRbnB_R-kOeJLqSLCgZqsinvUoKCt9lgqMDjpxMombXVBca1u8exkCwpl1PslHjfjvBW0aw5IvCfgfoEVvh2CdiN0E9PTMC4GDIWasqfc/s1600/raffle-ticket-add-unique-numbers.png" style="-webkit-border-image: url(data:image/png; border-image-repeat: stretch; border-image-slice: 9; border-image-source: url(data:image/png; border-image-width: 9px; border: 9px none; box-sizing: border-box; display: inline-block; height: auto; margin: 10px auto; max-width: 100%; padding: 8px; position: relative;" /></a></div>
<br style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; text-align: justify;" />
<div class="separator" style="background-color: white; clear: both; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; margin: 0px; outline: none; padding: 0px; text-align: center;">
</div>
<span style="background-color: white; color: #333333; font-family: "helvetica neue light" , , "helvetica neue" , "helvetica" , "arial" , sans-serif; font-size: 14px; line-height: 19px; text-align: justify;">... all the way down to (say) 500 rows (to give you 500 unique ticket numbers):</span><br />
<br style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; text-align: justify;" />
<div class="separator" style="background-color: white; clear: both; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; margin: 0px; outline: none; padding: 0px; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhno5DtVi00h7fAVYZSSBWwHaVJODy7wx5i_iYlbBdnYPruDFqxctmMqxuMUbIqAVsloRyzxBbb5Ptpa2u7grZn632nmhLi4hvfQzJvsLgxqcLP8qrUKjfVziSWdyeIM4LOZXJZvqdpdUk/s1600/raffle-ticket-500-unique-numbers.png" imageanchor="1" style="-webkit-transition: color 0.3s; color: #009eb8; display: inline; margin-bottom: 0px !important; margin-left: 1em; margin-right: 1em; margin-top: 0px !important; outline: none; text-decoration: none; transition: color 0.3s;"><img border="0" class="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhno5DtVi00h7fAVYZSSBWwHaVJODy7wx5i_iYlbBdnYPruDFqxctmMqxuMUbIqAVsloRyzxBbb5Ptpa2u7grZn632nmhLi4hvfQzJvsLgxqcLP8qrUKjfVziSWdyeIM4LOZXJZvqdpdUk/s1600/raffle-ticket-500-unique-numbers.png" style="-webkit-border-image: url(data:image/png; border-image-repeat: stretch; border-image-slice: 9; border-image-source: url(data:image/png; border-image-width: 9px; border: 9px none; box-sizing: border-box; display: inline-block; height: auto; margin: 10px auto; max-width: 100%; padding: 8px; position: relative;" /></a></div>
<br style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; text-align: justify;" />
<i style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; text-align: justify;">(If you prefer using the keyboard, rather than the mouse, then do this instead of dragging down: select cell A2, hit CTRL+C to copy, then select cell A3 and use SHIFT+PageDown to select all the way down to row 500. Then hit CTRL+V to paste.)</i><br />
<br style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; text-align: justify;" />
<span style="background-color: white; color: #333333; font-family: "helvetica neue light" , , "helvetica neue" , "helvetica" , "arial" , sans-serif; font-size: 14px; line-height: 19px; text-align: justify;">Now save your spreadsheet somewhere you can find it again, and close Excel.</span><br />
<br />
<h2>
<b>Step 4: Add numbers to your Word doc, to get a printable document of pre-numbered raffle tickets</b></h2>
Return to your Word document and go to Mailings > Start Mail Merge > Letters:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgoLDdEi_wjOtvkSfhAiZl_9fn5l2VAAh-nqRfqNeXWZYmuQ4klWB-2A53KCnIerVVzSOgCHeH3Z4QZceZi05SMZ2tT-qRC33yTBR6pkcBF-ZNyHnbCzKtg7afqI0LxGvx8Cwszne9Dk1o/s1600/raffleticket3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="436" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgoLDdEi_wjOtvkSfhAiZl_9fn5l2VAAh-nqRfqNeXWZYmuQ4klWB-2A53KCnIerVVzSOgCHeH3Z4QZceZi05SMZ2tT-qRC33yTBR6pkcBF-ZNyHnbCzKtg7afqI0LxGvx8Cwszne9Dk1o/s640/raffleticket3.png" width="640" /></a></div>
<br />
Then go to Select Recipients > Use Existing List:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizz1AUIiVsKNLuJCwsKk56RE8g_MyAogicOUX2cVMV6aulV5iZ0SzXPJb4Fcu_efbD-ZPoIqhlVreWX1y7jPe39Hq7M4mDxewbI250wM34iSXlTi2RIIOCphtjLYCbB5-Q00eb-O0xt5U/s1600/raffleticket4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="332" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizz1AUIiVsKNLuJCwsKk56RE8g_MyAogicOUX2cVMV6aulV5iZ0SzXPJb4Fcu_efbD-ZPoIqhlVreWX1y7jPe39Hq7M4mDxewbI250wM34iSXlTi2RIIOCphtjLYCbB5-Q00eb-O0xt5U/s640/raffleticket4.png" width="640" /></a></div>
<br />
Navigate to the Excel spreadsheet of numbers which you created earlier, and open it. On the dialog box which appears, <b>uncheck</b> the box 'First row of data contains column headers' and Click 'OK':<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjU0eTgsjivVm2Zj6A29o494a-lKqy7hp3wCZfkcak6LTbDx6PxizozqTRhnlurHqX1s6nxKSGRb4wLJ8Kt3r_suzx7aadNugvNgEQpZinXbgaEXi2cg2ze4WCuTDFbzNyKn_dVEfhQWFU/s1600/raffleticket5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjU0eTgsjivVm2Zj6A29o494a-lKqy7hp3wCZfkcak6LTbDx6PxizozqTRhnlurHqX1s6nxKSGRb4wLJ8Kt3r_suzx7aadNugvNgEQpZinXbgaEXi2cg2ze4WCuTDFbzNyKn_dVEfhQWFU/s640/raffleticket5.png" width="640" /></a></div>
<br />
Now put your cursor at the point where you want the ticket number to appear on the ticket.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEinhC5LC_NNa2LyFAVW_y1I0py_ra9fHvxYSfwgbs_S3MnRDLxuxaC7T64sptmvIAbwB5H0FE5fRWMuuHnVby3Ki6FODecw4XlPuWgk_8W88E1jofR5R2ySYRnHbvZL8hDUd_zsWjq3ZMg/s1600/Position+cursor+for+ticket+number.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="336" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEinhC5LC_NNa2LyFAVW_y1I0py_ra9fHvxYSfwgbs_S3MnRDLxuxaC7T64sptmvIAbwB5H0FE5fRWMuuHnVby3Ki6FODecw4XlPuWgk_8W88E1jofR5R2ySYRnHbvZL8hDUd_zsWjq3ZMg/s640/Position+cursor+for+ticket+number.png" width="640" /></a></div>
<br />
<br />
Click on Insert Merge Field, and something like 'M_1' will appear as a clickable item below the 'Insert Merge Field' button. That's a field name, representing your ticket number:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjigaSchYDvIeqaLFY13r1H3tA3mdAqYsIPdxK2AXjEhAO4eh5qPJtWruzxMl0-T4gONVdPKdeTodeIGSI8J9S8wI2fijrGFwc_CodUAyLc6yvnOxfsbBWnEdn_-zJpp6-zaBNDuJ-hkCs/s1600/raffleticket6.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="192" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjigaSchYDvIeqaLFY13r1H3tA3mdAqYsIPdxK2AXjEhAO4eh5qPJtWruzxMl0-T4gONVdPKdeTodeIGSI8J9S8wI2fijrGFwc_CodUAyLc6yvnOxfsbBWnEdn_-zJpp6-zaBNDuJ-hkCs/s640/raffleticket6.png" width="640" /></a></div>
Click that, and a placeholder will appear where your cursor was, which will later insert the ticket number at that point. Do that twice for each ticket (once for the counterfoil, once for the main ticket). You should end up with something like this:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjN_nXEps718lPX8b-9Ap9zpk_rLdtrpTT7HWr9xcUtuhIV2vgp5jGOWuDuXHSnwEkBrYWNgV4HIXT_wMFtAmUv11E_BcDWmti3_qeoFKWbvQzCWoIaIwXjZkw3e_dN0QflgTb0KTtRfA0/s1600/raffleticket7.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="234" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjN_nXEps718lPX8b-9Ap9zpk_rLdtrpTT7HWr9xcUtuhIV2vgp5jGOWuDuXHSnwEkBrYWNgV4HIXT_wMFtAmUv11E_BcDWmti3_qeoFKWbvQzCWoIaIwXjZkw3e_dN0QflgTb0KTtRfA0/s640/raffleticket7.png" width="640" /></a></div>
<br />
Repeat for all four tickets on the page:<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjic5no4wQaTiXu9CJ2SnQX6q_jzYfzX3sE2fISMlhk76qY3v4T5jTEHTUN-8NOu3mfw_swVu_V9pm7yGaCeTyTiqVlTKMkkHRRzy4-rgz5mazUcTQqFyhBHi0NcisaMWew8IkAje_sTwI/s1600/raffleticket8.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjic5no4wQaTiXu9CJ2SnQX6q_jzYfzX3sE2fISMlhk76qY3v4T5jTEHTUN-8NOu3mfw_swVu_V9pm7yGaCeTyTiqVlTKMkkHRRzy4-rgz5mazUcTQqFyhBHi0NcisaMWew8IkAje_sTwI/s640/raffleticket8.png" width="448" /></a></div>
<h2>
<b> Step 5: Make sure each ticket gets a new number</b></h2>
<b><br /></b>
Now for the slightly hard bit. If you just try and complete your merge now, you'll get several pages of tickets. Each page will have four tickets on it. But all tickets on any page will have the same number. Each page will have a different number, but all the tickets on that page will have the same number. That's no good. You need each ticket to have a different number.<br />
<br />
To get Word to put a different number on each ticket, you need to insert a special field to tell Word to look for the next number after the end of each ticket, rather than the end of each page.<br />
<br />
Put your cursor just after the second <<M_1>> placeholder on the first ticket. Then click Rules > Next Record:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg9INVEApXsRqWYSqyKI7d6lz1m7mqkC8f_-korpX5j9O_WK2N801LbmiB4brrDzfmOXBjOMvcRGoq6q8i9l9B9m_DFKnWCaX4cJioQ1ERAd5RTWN5w-oBq-F3dGngDBx_DwFyLyNur6-0/s1600/raffleticket9.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="376" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg9INVEApXsRqWYSqyKI7d6lz1m7mqkC8f_-korpX5j9O_WK2N801LbmiB4brrDzfmOXBjOMvcRGoq6q8i9l9B9m_DFKnWCaX4cJioQ1ERAd5RTWN5w-oBq-F3dGngDBx_DwFyLyNur6-0/s640/raffleticket9.png" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
That will insert the 'Next Record' placeholder in your ticket, telling Word to get the next number ready for the second ticket. Your document should look something like this:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEht-JlVHPmwnj1scNi45iRBhTylbBEtWqDvW_m9J4FR94n2LXSnc7-Wvftp-wBykADniK0lN0gwtEnL3l7YHfOpWZNV-iQ-3cq9crzItv1sO0CVVkMqA-TqP_zR7NFMFMXkH3XAqKZ0J2c/s1600/raffleticket10.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEht-JlVHPmwnj1scNi45iRBhTylbBEtWqDvW_m9J4FR94n2LXSnc7-Wvftp-wBykADniK0lN0gwtEnL3l7YHfOpWZNV-iQ-3cq9crzItv1sO0CVVkMqA-TqP_zR7NFMFMXkH3XAqKZ0J2c/s640/raffleticket10.png" width="640" /></a></div>
<br />
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:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEheSllpv_2DLcG-htP2vSbFcsjhPeYuEmWKL9sobE24RrfcEYSuxtx-gWSKSga7054gzdCd5To05_4C-yT9Y3OjTF5qFMoXKgPYODHnIHhmurfIqVON8l7zPt3pK-QXB8S5rjLIwbt-9qM/s1600/raffleticket11.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEheSllpv_2DLcG-htP2vSbFcsjhPeYuEmWKL9sobE24RrfcEYSuxtx-gWSKSga7054gzdCd5To05_4C-yT9Y3OjTF5qFMoXKgPYODHnIHhmurfIqVON8l7zPt3pK-QXB8S5rjLIwbt-9qM/s1600/raffleticket11.png" /></a></div>
<br />
<h2>
<b>Step 6: Complete your merge to generate a document with lots of tickets, all with different numbers</b></h2>
<b><br /></b>
Now click on Finish & Merge > Edit individual documents:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjiQxcbA7DNSsZi3djj9i92ahX0H2thr5FhT1rW0-v7YKXVFFdMa7ysQK0hBTXRpiw7N8SdpfA1zmYYK4LEv6SaKb0KAnTrrcYvDvhMCs8riDy-O6EyGy8dmTtWBKeWglQ3ztuw63LlPWk/s1600/raffleticket11a.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="298" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjiQxcbA7DNSsZi3djj9i92ahX0H2thr5FhT1rW0-v7YKXVFFdMa7ysQK0hBTXRpiw7N8SdpfA1zmYYK4LEv6SaKb0KAnTrrcYvDvhMCs8riDy-O6EyGy8dmTtWBKeWglQ3ztuw63LlPWk/s640/raffleticket11a.png" width="640" /></a></div>
<br />
Click 'OK' on the next dialog, and you'll get a new document, with four tickets per page and each ticket will have a different number:<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiacy3LPlIwVfwG8PythgWeDjhl2-jA2sKiGFnrIbbICOk0FiM2XO-JrlzdvxBy8jLppWo7vAPWoknI9IUou3mSMy_Lo564jthNDT8-AtbuXWOSJ25lqElXqdr5JQi0ktMNuTbjNehKVFo/s1600/raffleticket12.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="338" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiacy3LPlIwVfwG8PythgWeDjhl2-jA2sKiGFnrIbbICOk0FiM2XO-JrlzdvxBy8jLppWo7vAPWoknI9IUou3mSMy_Lo564jthNDT8-AtbuXWOSJ25lqElXqdr5JQi0ktMNuTbjNehKVFo/s640/raffleticket12.png" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
Print that out, and you are done!<br />
<br />
Looking for an easier way? Use this tool to create numbered raffle tickets online, then print them on your computer:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://app.raffleticketcreator.com/"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj9rIzXyUQXvpGxVfMRMv4pj80Uz66lmm_coHobHhim-kixmHeD_LW-Ex6w3GxG-GXlEwFgDa1rt-xaXEzhlwPtRDR7AOdDZNClLzokH4_znfesVJ7nYHEw8NMzENBbkWpYAOU2ibhdydY/s1600/Numbered-raffle-tickets.png" /></a></div>
<br />
<br />
<br />Bruce Ghttp://www.blogger.com/profile/09056360686702009784noreply@blogger.com55tag:blogger.com,1999:blog-4708941817257238261.post-26489131684653107982014-01-08T03:28:00.000-08:002017-02-08T01:33:56.424-08:00Create numbered raffle tickets in Word for Mac 2011<h2>
This post will show you how to create numbered raffle tickets using Microsoft Word for Mac 2011:</h2>
<a href="http://www.raffleticketcreator.com/2016/07/print-raffle-tickets-using-template-in.html">UPDATE: Click here for new instructions for printing numbered raffle tickets using Word 2016 (Mac or PC)</a><br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwSv4rks9V9tHfVlJc76vNjUUxU_HoZOh-l6wqdqmLHt8_OQj0Gq8HSe156kD8-FYs3oNj8FMiHJacuYErD7K0ypBO2o0FHNRFfKU2wZAIGvvPDj8prhuFC8G8tUezN43T60at071dEcw/s1600/Screen+Shot+2014-01-08+at+11.23.20.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="109" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwSv4rks9V9tHfVlJc76vNjUUxU_HoZOh-l6wqdqmLHt8_OQj0Gq8HSe156kD8-FYs3oNj8FMiHJacuYErD7K0ypBO2o0FHNRFfKU2wZAIGvvPDj8prhuFC8G8tUezN43T60at071dEcw/s1600/Screen+Shot+2014-01-08+at+11.23.20.png" width="320" /></a></div>
<br />
<br />
<h2>
You'll be able to print several tickets per page, each ticket having a different number.</h2>
<div>
(Prefer to use Publisher instead? Instructions for <a href="http://www.raffleticketcreator.com/2012/02/print-raffle-tickets-on-your-own.html">printing raffle tickets using Publisher are here.</a>)<br />
(Using Word on a PC? <a href="http://www.raffleticketcreator.com/2014/01/print-numbered-raffle-tickets-at-home.html">Instructions for printing raffle tickets with Word 2007 for Windows are here.</a>)</div>
<br />
<h2>
<b>Step 1 - Create one raffle ticket</b></h2>
Create a new document in Word, and set up one ticket to occupy about one quarter of the page. Just use tabs and line breaks to format the text, don't use text boxes. And leave some space to put the ticket numbers in later. You might end up with something like this:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0g44Pq2_yzH_J99RrEKM5hk2ueyjegdOL053llM4Qi3amNbArXxJmna1P7aqK57FgiulkXWWCWXsekioN6s9JI1QE40S0XxJM5OnGlTGQX4JxiRwtsiRrK5Dvhv-DtuoQSJ9UMbYlHZE/s1600/Screen+Shot+2014-01-07+at+12.14.35.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="348" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0g44Pq2_yzH_J99RrEKM5hk2ueyjegdOL053llM4Qi3amNbArXxJmna1P7aqK57FgiulkXWWCWXsekioN6s9JI1QE40S0XxJM5OnGlTGQX4JxiRwtsiRrK5Dvhv-DtuoQSJ9UMbYlHZE/s1600/Screen+Shot+2014-01-07+at+12.14.35.png" width="640" /></a></div>
<br />
You might add some decoration too:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg9DdaxGmLAQTb75uhshg8a0crRLhnLNdQzigNLMibopdwzVI4GA43dEPYayOgN5dRigLRjep9SaE5mVNrDZqPNOFB26zPJvCctykU4_aaHkbsMqjxVydmp0ycpgUz2fuELaBsBUcIEZqk/s1600/Screen+Shot+2014-01-07+at+12.31.47.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="376" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg9DdaxGmLAQTb75uhshg8a0crRLhnLNdQzigNLMibopdwzVI4GA43dEPYayOgN5dRigLRjep9SaE5mVNrDZqPNOFB26zPJvCctykU4_aaHkbsMqjxVydmp0ycpgUz2fuELaBsBUcIEZqk/s1600/Screen+Shot+2014-01-07+at+12.31.47.png" width="640" /></a></div>
<br />
<b><br /></b>
<br />
<h2>
<b>Step 2 - Create a page of tickets</b></h2>
<br />
Copy-paste everything three times to fill the page with four tickets:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhTGsJs6Jfbh4AScFavlw6MqeiLl_gvYhCx_6ACl8sAyfG-b3gZxt_MrFQzbjSu6c9ij9vuqV8Ww-cXdL5tVw7-UUtpE-nNMMybn0sVwkQw6Sv_EgvzCdztUbnL3LtjlVt-oH_i82o6J5I/s1600/Screen+Shot+2014-01-07+at+12.36.36.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhTGsJs6Jfbh4AScFavlw6MqeiLl_gvYhCx_6ACl8sAyfG-b3gZxt_MrFQzbjSu6c9ij9vuqV8Ww-cXdL5tVw7-UUtpE-nNMMybn0sVwkQw6Sv_EgvzCdztUbnL3LtjlVt-oH_i82o6J5I/s1600/Screen+Shot+2014-01-07+at+12.36.36.png" width="632" /></a></div>
<br />
<h2>
<b>Step 3 - Create a list of numbers for your tickets, in Excel</b></h2>
<span style="background-color: white; color: #333333; font-family: "helvetica neue light" , , "helvetica neue" , "helvetica" , "arial" , sans-serif; font-size: 14px; line-height: 19px; text-align: justify;">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):</span><br />
<br style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; text-align: justify;" />
<div class="separator" style="background-color: white; clear: both; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; margin: 0px; outline: none; padding: 0px; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjdznfbE8G4rvK_Ts4q92PLVCDISaKOaK77zWBhAXAiLQCq_rYk3J2CygUV-x9OX6blaxHaIi4VJ7HN7HeFJwu7jDmJ-H1atSFEdze_sTjrQtxf1CkzzoQ1GDGYPpI_Ckg7jGUB9-9l3V4/s1600/raffle-ticket-numbering.png" imageanchor="1" style="-webkit-transition: color 0.3s; color: #009eb8; display: inline; margin-bottom: 0px !important; margin-left: 1em; margin-right: 1em; margin-top: 0px !important; outline: none; text-decoration: none; transition: color 0.3s;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjdznfbE8G4rvK_Ts4q92PLVCDISaKOaK77zWBhAXAiLQCq_rYk3J2CygUV-x9OX6blaxHaIi4VJ7HN7HeFJwu7jDmJ-H1atSFEdze_sTjrQtxf1CkzzoQ1GDGYPpI_Ckg7jGUB9-9l3V4/s1600/raffle-ticket-numbering.png" style="-webkit-border-image: url(data:image/png; border-image-repeat: stretch; border-image-slice: 9; border-image-source: url(data:image/png; border-image-width: 9px; border: 9px none; box-sizing: border-box; display: inline-block; height: auto; margin: 10px auto; max-width: 100%; padding: 8px; position: relative;" /></a></div>
<br style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; text-align: justify;" />
<span style="background-color: white; color: #333333; font-family: "helvetica neue light" , , "helvetica neue" , "helvetica" , "arial" , sans-serif; font-size: 14px; line-height: 19px; text-align: justify;">In the cell below, type "=A1+1" (without quotes) and hit enter/return:</span><br />
<br />
<div class="separator" style="background-color: white; clear: both; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; margin: 0px; outline: none; padding: 0px; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjdH2WPeHbq4cFausdtH_Wgfmv7R0H5MlHEeFVfb4m7KhIA0fFzkmd-iwz9xYSCQokUdvB_MGiJmMB-4lU6kb4aHjsfffr8kG6FXQY_ZYX1NJknDh4bx5FBGe6f-CqcxQxWOBJ0R69iYkc/s1600/raffle-ticket-unique-numbering.png" imageanchor="1" style="-webkit-transition: color 0.3s; color: #009eb8; display: inline; margin-bottom: 0px !important; margin-left: 1em; margin-right: 1em; margin-top: 0px !important; outline: none; text-decoration: none; transition: color 0.3s;"><img border="0" class="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjdH2WPeHbq4cFausdtH_Wgfmv7R0H5MlHEeFVfb4m7KhIA0fFzkmd-iwz9xYSCQokUdvB_MGiJmMB-4lU6kb4aHjsfffr8kG6FXQY_ZYX1NJknDh4bx5FBGe6f-CqcxQxWOBJ0R69iYkc/s1600/raffle-ticket-unique-numbering.png" style="-webkit-border-image: url(data:image/png; border-image-repeat: stretch; border-image-slice: 9; border-image-source: url(data:image/png; border-image-width: 9px; border: 9px none; box-sizing: border-box; display: inline-block; height: auto; margin: 10px auto; max-width: 100%; padding: 8px; position: relative;" /></a></div>
<br style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; text-align: justify;" />
<span style="background-color: white; color: #333333; font-family: "helvetica neue light" , , "helvetica neue" , "helvetica" , "arial" , sans-serif; font-size: 14px; line-height: 19px; text-align: justify;">That'll put a 2 in that cell, like this:</span><br />
<br />
<div class="separator" style="background-color: white; clear: both; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; margin: 0px; outline: none; padding: 0px; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgrXfkVZBv_k77MLgZOt4cIA9_OFUfSiN6QAyFmE84BP3e0wj3CJVyxz4eqpbVfoerJbhsTajMAmQ7uEmLy3rFskOVcNqUHGiyuKc9QOao70ridPFtkMrivPtJrt3vsi5b1dBeen-qfbAE/s1600/raffle-ticket-numbers.png" imageanchor="1" style="-webkit-transition: color 0.3s; color: #009eb8; display: inline; margin-bottom: 0px !important; margin-left: 1em; margin-right: 1em; margin-top: 0px !important; outline: none; text-decoration: none; transition: color 0.3s;"><img border="0" class="" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgrXfkVZBv_k77MLgZOt4cIA9_OFUfSiN6QAyFmE84BP3e0wj3CJVyxz4eqpbVfoerJbhsTajMAmQ7uEmLy3rFskOVcNqUHGiyuKc9QOao70ridPFtkMrivPtJrt3vsi5b1dBeen-qfbAE/s320/raffle-ticket-numbers.png" style="-webkit-border-image: url(data:image/png; border-image-repeat: stretch; border-image-slice: 9; border-image-source: url(data:image/png; border-image-width: 9px; border: 9px none; box-sizing: border-box; display: inline-block; height: auto; margin: 10px auto; max-width: 100%; padding: 8px; position: relative;" width="225" /></a></div>
<br style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; text-align: justify;" />
<span style="background-color: white; color: #333333; font-family: "helvetica neue light" , , "helvetica neue" , "helvetica" , "arial" , sans-serif; font-size: 14px; line-height: 19px; text-align: justify;">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:</span><br />
<br />
<div class="separator" style="background-color: white; clear: both; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; margin: 0px; outline: none; padding: 0px; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhq3eId9R_Hr6pyCD1uPYN1ZQrG6FHgC1lwzAjRbnB_R-kOeJLqSLCgZqsinvUoKCt9lgqMDjpxMombXVBca1u8exkCwpl1PslHjfjvBW0aw5IvCfgfoEVvh2CdiN0E9PTMC4GDIWasqfc/s1600/raffle-ticket-add-unique-numbers.png" imageanchor="1" style="-webkit-transition: color 0.3s; color: #009eb8; display: inline; margin-bottom: 0px !important; margin-left: 1em; margin-right: 1em; margin-top: 0px !important; outline: none; text-decoration: none; transition: color 0.3s;"><img border="0" class="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhq3eId9R_Hr6pyCD1uPYN1ZQrG6FHgC1lwzAjRbnB_R-kOeJLqSLCgZqsinvUoKCt9lgqMDjpxMombXVBca1u8exkCwpl1PslHjfjvBW0aw5IvCfgfoEVvh2CdiN0E9PTMC4GDIWasqfc/s1600/raffle-ticket-add-unique-numbers.png" style="-webkit-border-image: url(data:image/png; border-image-repeat: stretch; border-image-slice: 9; border-image-source: url(data:image/png; border-image-width: 9px; border: 9px none; box-sizing: border-box; display: inline-block; height: auto; margin: 10px auto; max-width: 100%; padding: 8px; position: relative;" /></a></div>
<br style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; text-align: justify;" />
<div class="separator" style="background-color: white; clear: both; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; margin: 0px; outline: none; padding: 0px; text-align: center;">
</div>
<span style="background-color: white; color: #333333; font-family: "helvetica neue light" , , "helvetica neue" , "helvetica" , "arial" , sans-serif; font-size: 14px; line-height: 19px; text-align: justify;">... all the way down to (say) 500 rows (to give you 500 unique ticket numbers):</span><br />
<br />
<div class="separator" style="background-color: white; clear: both; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; margin: 0px; outline: none; padding: 0px; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhno5DtVi00h7fAVYZSSBWwHaVJODy7wx5i_iYlbBdnYPruDFqxctmMqxuMUbIqAVsloRyzxBbb5Ptpa2u7grZn632nmhLi4hvfQzJvsLgxqcLP8qrUKjfVziSWdyeIM4LOZXJZvqdpdUk/s1600/raffle-ticket-500-unique-numbers.png" imageanchor="1" style="-webkit-transition: color 0.3s; color: #009eb8; display: inline; margin-bottom: 0px !important; margin-left: 1em; margin-right: 1em; margin-top: 0px !important; outline: none; text-decoration: none; transition: color 0.3s;"><img border="0" class="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhno5DtVi00h7fAVYZSSBWwHaVJODy7wx5i_iYlbBdnYPruDFqxctmMqxuMUbIqAVsloRyzxBbb5Ptpa2u7grZn632nmhLi4hvfQzJvsLgxqcLP8qrUKjfVziSWdyeIM4LOZXJZvqdpdUk/s1600/raffle-ticket-500-unique-numbers.png" style="-webkit-border-image: url(data:image/png; border-image-repeat: stretch; border-image-slice: 9; border-image-source: url(data:image/png; border-image-width: 9px; border: 9px none; box-sizing: border-box; display: inline-block; height: auto; margin: 10px auto; max-width: 100%; padding: 8px; position: relative;" /></a></div>
<br style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; text-align: justify;" />
<i style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; text-align: justify;">(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.)</i><br />
<br style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19px; text-align: justify;" />
<span style="background-color: white; color: #333333; font-family: "helvetica neue light" , , "helvetica neue" , "helvetica" , "arial" , sans-serif; font-size: 14px; line-height: 19px; text-align: justify;">Now save your spreadsheet somewhere you can find it again, and close Excel.</span><br />
<span style="background-color: white; color: #333333; font-family: "helvetica neue light" , , "helvetica neue" , "helvetica" , "arial" , sans-serif; font-size: 14px; line-height: 19px; text-align: justify;"><br /></span>
<br />
<h2>
<span style="background-color: white; color: #333333; font-family: "helvetica neue light" , , "helvetica neue" , "helvetica" , "arial" , sans-serif; font-size: 14px; line-height: 19px; text-align: justify;"><b>Step 4: Add ticket numbers to your raffle tickets in Word</b></span></h2>
<br />
<span style="background-color: white; color: #333333; font-family: "helvetica neue light" , , "helvetica neue" , "helvetica" , "arial" , sans-serif; font-size: 14px; line-height: 19px; text-align: justify;">Return to Word and go to Tools > Mail Merge Manager:</span><br />
<span style="background-color: white; color: #333333; font-family: "helvetica neue light" , , "helvetica neue" , "helvetica" , "arial" , sans-serif; font-size: 14px; line-height: 19px; text-align: justify;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjI_OectuEngdeQoGistXwGnt-9dfhLdFjBv9kZKZbgqBwRIxl3fzMq0GV-zMEDTcznInN2tIa2u5Ekkj4HA-xo_7IgeHIt0KyIm3x59XKNhZkIpJhnvGI0ime8mheLebelLGeABrw0wOE/s1600/Screen+Shot+2014-01-07+at+12.43.42.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjI_OectuEngdeQoGistXwGnt-9dfhLdFjBv9kZKZbgqBwRIxl3fzMq0GV-zMEDTcznInN2tIa2u5Ekkj4HA-xo_7IgeHIt0KyIm3x59XKNhZkIpJhnvGI0ime8mheLebelLGeABrw0wOE/s1600/Screen+Shot+2014-01-07+at+12.43.42.png" width="544" /></a></div>
<span style="background-color: white; color: #333333; font-family: "helvetica neue light" , , "helvetica neue" , "helvetica" , "arial" , sans-serif; font-size: 14px; line-height: 19px; text-align: justify;"><br /></span>
<span style="background-color: white; color: #333333; font-family: "helvetica neue light" , , "helvetica neue" , "helvetica" , "arial" , sans-serif; font-size: 14px; line-height: 19px; text-align: justify;">Then, in the Mail Merge Manager box which appears, select 'Form Letter' under '1. Select Document Type':</span><br />
<span style="background-color: white; color: #333333; font-family: "helvetica neue light" , , "helvetica neue" , "helvetica" , "arial" , sans-serif; font-size: 14px; line-height: 19px; text-align: justify;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhZtjSLj4IYnFd1vFu7BCj0m4UZhIP6qbPPqFN6Ug7aN6RqjKWUc0Wg4Fxn-rofcjZyz2mjYrVdxscBpCsB5qVj4cF4KUvM0qrQDYTBFdy_TElk7uSKX_OsbsXYcnEpR2FiSYMdSnPZb1w/s1600/Screen+Shot+2014-01-08+at+10.43.37.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="125" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhZtjSLj4IYnFd1vFu7BCj0m4UZhIP6qbPPqFN6Ug7aN6RqjKWUc0Wg4Fxn-rofcjZyz2mjYrVdxscBpCsB5qVj4cF4KUvM0qrQDYTBFdy_TElk7uSKX_OsbsXYcnEpR2FiSYMdSnPZb1w/s1600/Screen+Shot+2014-01-08+at+10.43.37.png" width="320" /></a></div>
<span style="background-color: white; color: #333333; font-family: "helvetica neue light" , , "helvetica neue" , "helvetica" , "arial" , sans-serif; font-size: 14px; line-height: 19px; text-align: justify;"><br /></span>
<span style="background-color: white; color: #333333; font-family: "helvetica neue light" , , "helvetica neue" , "helvetica" , "arial" , sans-serif; font-size: 14px; line-height: 19px; text-align: justify;">Then, under '2. Select Recipients List' click 'Get List', then 'Open Data Source...':</span><br />
<span style="background-color: white; color: #333333; font-family: "helvetica neue light" , , "helvetica neue" , "helvetica" , "arial" , sans-serif; font-size: 14px; line-height: 19px; text-align: justify;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhVZPj8wE8dvsxSJrHhTJJYzrH_ZaR6xlnQe1cmDOX3Lp-Y0wWWSpSrwZtxo_ln4fjen1gF2gtHaCj7TDAbJx91iC0A_4M1Er21kFygBiQ9euhJTjWBmE5_6Sbk7v1hh282S-OKe4CxpO4/s1600/Screen+Shot+2014-01-08+at+10.43.48.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhVZPj8wE8dvsxSJrHhTJJYzrH_ZaR6xlnQe1cmDOX3Lp-Y0wWWSpSrwZtxo_ln4fjen1gF2gtHaCj7TDAbJx91iC0A_4M1Er21kFygBiQ9euhJTjWBmE5_6Sbk7v1hh282S-OKe4CxpO4/s1600/Screen+Shot+2014-01-08+at+10.43.48.png" /></a></div>
<span style="background-color: white; color: #333333; font-family: "helvetica neue light" , , "helvetica neue" , "helvetica" , "arial" , sans-serif; font-size: 14px; line-height: 19px; text-align: justify;"><br /></span>
Navigate to the Excel spreadsheet you created earlier and open it.<br />
<br />
Click 'OK' to the next two questions:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjxYaCuO4gfowrT8_9pwGq9q41cAd3EsdjB5xegVVoW3Rd0kLweudOxFgDkonJwRhE4q221aY0nxTnDAmexrw9rWpgylADL6GNVOPKpjFILkJmvBl0PQR4evU_NeDPf8ICQZhBY3-j17s8/s1600/Screen+Shot+2014-01-08+at+10.50.22.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="126" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjxYaCuO4gfowrT8_9pwGq9q41cAd3EsdjB5xegVVoW3Rd0kLweudOxFgDkonJwRhE4q221aY0nxTnDAmexrw9rWpgylADL6GNVOPKpjFILkJmvBl0PQR4evU_NeDPf8ICQZhBY3-j17s8/s1600/Screen+Shot+2014-01-08+at+10.50.22.png" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjiAZWdgRxkLb26I9LRgUf7Azc0W6QBGf3T9HA9pVfNjpOajQxcNpH5QiFQbUEboV8LM_sAv_ENxk0_Wu_USrh281l6VNJKhF4hSAPqe_gRWdfjOVvZ28zt8FsJK8x2S8eoVYrdd851DXE/s1600/Screen+Shot+2014-01-08+at+10.50.30.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjiAZWdgRxkLb26I9LRgUf7Azc0W6QBGf3T9HA9pVfNjpOajQxcNpH5QiFQbUEboV8LM_sAv_ENxk0_Wu_USrh281l6VNJKhF4hSAPqe_gRWdfjOVvZ28zt8FsJK8x2S8eoVYrdd851DXE/s1600/Screen+Shot+2014-01-08+at+10.50.30.png" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
Back in the little Mail Merge Manager box, drag the blue star which now appears under '3. Insert Placeholders' into your document, where you want the first ticket number to appear:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhqPhsODcWPR8tXHG7bsntJDaspbIc3vv0ByA1to5aW2K8JYB_ij2Mtd5tNg1uwkIm1_UjIY5BEvx-p0NTz_T6KbB17YfmwAT7H0jgGZtDHNgdZKpKkHgeMDMTg7Fq5mnIg-Vh38fSD5jY/s1600/Screen+Shot+2014-01-08+at+10.50.37.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhqPhsODcWPR8tXHG7bsntJDaspbIc3vv0ByA1to5aW2K8JYB_ij2Mtd5tNg1uwkIm1_UjIY5BEvx-p0NTz_T6KbB17YfmwAT7H0jgGZtDHNgdZKpKkHgeMDMTg7Fq5mnIg-Vh38fSD5jY/s1600/Screen+Shot+2014-01-08+at+10.50.37.png" width="210" /></a></div>
<br />
<br />
A placeholder like this will appear to show where the number will be:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzG0RSFQzQlwDT8TieMtP7zD8-dEqngAT7pESu0-APyWzSZ83j4EnDcS25rrSiyLDQZIYAjchdZirkHJvXv467daSBmiAvAqVDw8ix4H7AjmOBJpzEWWTlJWLGExPsfXl-s3vMZorUUuQ/s1600/Screen+Shot+2014-01-08+at+10.54.08.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="422" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzG0RSFQzQlwDT8TieMtP7zD8-dEqngAT7pESu0-APyWzSZ83j4EnDcS25rrSiyLDQZIYAjchdZirkHJvXv467daSBmiAvAqVDw8ix4H7AjmOBJpzEWWTlJWLGExPsfXl-s3vMZorUUuQ/s1600/Screen+Shot+2014-01-08+at+10.54.08.png" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
I've put it on the counterfoil part of the ticket first. Repeat for the main body of the ticket, and for each ticket:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizSX4NfmzEz-lczcMEg0BUK3WFF7OYBlEdUFE8bfwp-Is2PmKGpdUX0Dn_2qkX1_4fB_gqFAzfNSPns55SX71WuGUX7YiEs7atGlxBJGwQu-uxMsJe3ZJOt-nS0TRJxhA202Sh3zQGWMo/s1600/Screen+Shot+2014-01-08+at+10.56.16.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizSX4NfmzEz-lczcMEg0BUK3WFF7OYBlEdUFE8bfwp-Is2PmKGpdUX0Dn_2qkX1_4fB_gqFAzfNSPns55SX71WuGUX7YiEs7atGlxBJGwQu-uxMsJe3ZJOt-nS0TRJxhA202Sh3zQGWMo/s1600/Screen+Shot+2014-01-08+at+10.56.16.png" width="418" /></a></div>
<h2>
<b>Step 5: Force Word to put a different number on each ticket</b></h2>
<b>Now for the tricky bit.</b> 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.<br />
<br />
To get Word to change the number for each ticket, you need to insert a special field.<br />
<br />
Put your cursor just after the second <<M_1>> on the first ticket:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgAccQeV9Vh8cXhSwxJrvf8YFVlXHXAzqxSahljD5OnJjkX_A95ZCsxxViKr_M2rABCfbv9vCBoOL3-dzJf24zF4DaDI9EMcoO08HyY-qlCaCIWT0GB3N1sxtTGXShwAIZxbKX-Ee87RcM/s1600/Screen+Shot+2014-01-08+at+11.00.05.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="384" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgAccQeV9Vh8cXhSwxJrvf8YFVlXHXAzqxSahljD5OnJjkX_A95ZCsxxViKr_M2rABCfbv9vCBoOL3-dzJf24zF4DaDI9EMcoO08HyY-qlCaCIWT0GB3N1sxtTGXShwAIZxbKX-Ee87RcM/s1600/Screen+Shot+2014-01-08+at+11.00.05.png" width="640" /></a></div>
<br />
<br />
Then go to Insert > Field...<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisMFs0cAvHeA1542I-0ljP5VDLNdMqRJ_TXuL0Ptw51l4cFArZumMv-YYeMl0uGRuDnZTQjPdh0qZo5T0rMm1K7Y0YBD5uXTQcP9Ck40T70XzPtkrE6qKOLk6j6q-rpjVU_mIqUEwjcA0/s1600/Screen+Shot+2014-01-08+at+11.01.34.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisMFs0cAvHeA1542I-0ljP5VDLNdMqRJ_TXuL0Ptw51l4cFArZumMv-YYeMl0uGRuDnZTQjPdh0qZo5T0rMm1K7Y0YBD5uXTQcP9Ck40T70XzPtkrE6qKOLk6j6q-rpjVU_mIqUEwjcA0/s1600/Screen+Shot+2014-01-08+at+11.01.34.png" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
In the box that appears, under 'Category' select 'Mail Merge', and under 'Field names' select 'Next':</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiovMmNZoTjyJHcc7AWyZlD1AXPChgadKvh8dDTEnQ-5BnwBj_vMdGqMPDGOdJxnu5yzRl4-rKi3SoVuE6xFArp9cLdVrcdCp0jgwQDBgDo8DP9E3VydZIq-cLwhCxKExev3TEVKBQ_EQA/s1600/Screen+Shot+2014-01-08+at+11.01.49.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiovMmNZoTjyJHcc7AWyZlD1AXPChgadKvh8dDTEnQ-5BnwBj_vMdGqMPDGOdJxnu5yzRl4-rKi3SoVuE6xFArp9cLdVrcdCp0jgwQDBgDo8DP9E3VydZIq-cLwhCxKExev3TEVKBQ_EQA/s1600/Screen+Shot+2014-01-08+at+11.01.49.png" width="292" /></a></div>
<br />
<br />
This will insert a special field to force Word to go to the next number in your spreadsheet for the next ticket on the page. You can't see this special field, though, unless you click the little {a} button in the Mail Merge Manager box:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj89F_auxP4yMDifxf7hIzDcajVJnwKKl0Q7mSxiGfZ_JCX1uv-1G52b09_DqncOBY_PgdKRp9twEtKOc8v_Xmh3HMTH_7jwmyJsW1F0rHCv7a9ScQeyy_25eNp8Bucf4tfTMRCtGgg25Y/s1600/Screen+Shot+2014-01-08+at+11.04.07.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="386" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj89F_auxP4yMDifxf7hIzDcajVJnwKKl0Q7mSxiGfZ_JCX1uv-1G52b09_DqncOBY_PgdKRp9twEtKOc8v_Xmh3HMTH_7jwmyJsW1F0rHCv7a9ScQeyy_25eNp8Bucf4tfTMRCtGgg25Y/s1600/Screen+Shot+2014-01-08+at+11.04.07.png" width="640" /></a></div>
<br />
<br />
Click that little {a} again to hide the field. You don't need to see it, and it rather messes up the layout when the fields are shown in full on the screen.<br />
<br />
Now go the the next ticket and Insert another 'Next' field (by going to Insert > Field ... and selecting Mail Merge category and Next field).<br />
<br />
Do that again after the number on the third ticket on your page, BUT NOT THE FINAL TICKET ON THE PAGE. Because the final ticket is at the end of the page, and the number will increment automatically at the end of a page. If you put a 'Next' field there too, you'll jump two numbers.<br />
<br />
You can check you've got the fields in there by clicking that little {a} button again:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2zGpEY8BUNLyNrKGkyidEk-F38emEpOVl3BxbwBO8BmwJZ5BBpTFm3E1mm3_ohvoYBsmON93VaCGqTvGkvfazxKmF4eI4-7jG9AvrJMfojJ7puPZ8JP1HxeY9kfDbV0UxY0cvZYiQDVw/s1600/Screen+Shot+2014-01-08+at+11.08.45.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2zGpEY8BUNLyNrKGkyidEk-F38emEpOVl3BxbwBO8BmwJZ5BBpTFm3E1mm3_ohvoYBsmON93VaCGqTvGkvfazxKmF4eI4-7jG9AvrJMfojJ7puPZ8JP1HxeY9kfDbV0UxY0cvZYiQDVw/s1600/Screen+Shot+2014-01-08+at+11.08.45.png" width="616" /></a></div>
<br />
Don't worry that the formatting looks a bit messed up when you reveal those hidden fields. Just click the {a} button again and it'll jump back to how it was.<br />
<br />
<h2>
<b>Step 6 Create your printable document of numbered tickets</b></h2>
Final step, yay!<br />
<br />
In the Mail Merge Manager box, click the Merge to New Document icon:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEikfqt6l9QWH00vQSAYqpc6IP7uHs9GAKkELc0Vxqg2VWRB65aFH7PK5i7abLZLZS722_Cmvh-RMnq86thsFzpRLjRR2q1DfXyk6nK975G42m3u_kTn-JRfO_HUVcItNw2cY7iaJilVysM/s1600/Screen+Shot+2014-01-08+at+11.16.52.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEikfqt6l9QWH00vQSAYqpc6IP7uHs9GAKkELc0Vxqg2VWRB65aFH7PK5i7abLZLZS722_Cmvh-RMnq86thsFzpRLjRR2q1DfXyk6nK975G42m3u_kTn-JRfO_HUVcItNw2cY7iaJilVysM/s1600/Screen+Shot+2014-01-08+at+11.16.52.png" width="312" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Word will then create for you a new document, with several tickets per page, each ticket having a unique number:</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjJULkVGaTd-KjNE2XnarRyiXJgApk3h43k5KT_dWz9QKD25ZrU7cb9f2d9aw-iCZ9hhNJ765yxtEeWkgLcO58v2hB1WeWUIcGAJh8RXTxlqWd7C2HTgL3zts0LzNi5SJRZ9kaK9dSn_w8/s1600/Screen+Shot+2014-01-08+at+11.15.33.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjJULkVGaTd-KjNE2XnarRyiXJgApk3h43k5KT_dWz9QKD25ZrU7cb9f2d9aw-iCZ9hhNJ765yxtEeWkgLcO58v2hB1WeWUIcGAJh8RXTxlqWd7C2HTgL3zts0LzNi5SJRZ9kaK9dSn_w8/s1600/Screen+Shot+2014-01-08+at+11.15.33.png" width="430" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Print out that document, and you are done!</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Congratulations.</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Looking for an easier way? Use this simple online tool to create numbered raffle tickets and then print them at home from your own computer:</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://app.raffleticketcreator.com/"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj9rIzXyUQXvpGxVfMRMv4pj80Uz66lmm_coHobHhim-kixmHeD_LW-Ex6w3GxG-GXlEwFgDa1rt-xaXEzhlwPtRDR7AOdDZNClLzokH4_znfesVJ7nYHEw8NMzENBbkWpYAOU2ibhdydY/s1600/Numbered-raffle-tickets.png" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<br />
<br />Bruce Ghttp://www.blogger.com/profile/09056360686702009784noreply@blogger.com11tag:blogger.com,1999:blog-4708941817257238261.post-79289116009982400642012-02-21T03:03:00.001-08:002017-02-08T01:19:13.495-08:00Printable numbered raffle tickets on your own computer<i>(These instructions are for Microsoft Publisher. Instructions for printing raffle tickets using <a href="http://www.raffleticketcreator.com/2014/01/create-numbered-raffle-tickets-in-word.html">Microsoft Word are here</a>. Or use this <a href="http://app.raffleticketcreator.com/"><b>special online raffle ticket program</b></a> which is much easier than Word or Publisher!)</i><br />
<i><br /></i>
<i><a href="http://www.raffleticketcreator.com/2016/07/print-raffle-tickets-using-template-in.html"><b>Update: new instructions for printing from Word 2016 are here</b></a></i><br />
<br />
<h2>
This post will show you how to create printable numbered raffle tickets at home.</h2>
<br />
You've found this post, so you already know creating raffle tickets to print out yourself is harder than it sounds.<br />
<br />
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 <i>about to start typing a unique ticket number on every ticket. All 500 of them.</i><br />
<i><br /></i>
My first thought: <i>"Stop! Just do a quick mail merge, and Word will produce 500 tickets each with a unique ticket number."</i><br />
<br />
<b>"Honey, step aside, it'll take me about 10 minutes. Watch and learn."</b><br />
<br />
Turns out it took the best part of an afternoon.<br />
<br />
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. <b>UPDATE: I did figure it out. <a href="http://www.raffleticketcreator.com/2014/01/create-numbered-raffle-tickets-in-word.html">Instructions for printing raffle tickets using Microsoft Word are here.</a></b>). And you don't really want to have every raffle ticket use up a whole sheet of paper.<br />
<br />
But you can do it with Microsoft Publisher. Here are the step-by-step instructions:<br />
<br />
<div style="text-align: center;">
<br /></div>
<hr />
<div style="text-align: center;">
<b><i style="background-color: yellow;">> STOP PRESS: You can use <a href="http://app.raffleticketcreator.com/">this online tool to design and print your own raffle tickets</a> <</i></b></div>
<div style="text-align: center;">
<b><i style="background-color: yellow;">(Or read on to learn how to do it manually in Publisher!)</i></b></div>
<span style="background-color: yellow;"><br /></span>
<br />
<hr />
<div style="text-align: center;">
<br /></div>
<h2>
<b>1. Create your raffle ticket in Publisher</b></h2>
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.<br />
<br />
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, <b>not </b>the size of paper you are printing on. You probably want 4 raffle tickets per page, so <b>if you are printing on A4</b> then set the size to 20cm wide x 7cm high, with 1cm margins:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhO5Wyc1hClFyH4jJBwjuAo31L6U7NKoOZUJ3pWMP-sMp15aRoq7CLO25D1M_paUxotygITvu7H_lK9aR3VXyn9gkbUv0bCSkA1a8ZU2YSc2I9AF6Xjwy4Hm2Qp6H7Yu_mTtPfHEgBbur8/s1600/raffle-ticket-printing.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhO5Wyc1hClFyH4jJBwjuAo31L6U7NKoOZUJ3pWMP-sMp15aRoq7CLO25D1M_paUxotygITvu7H_lK9aR3VXyn9gkbUv0bCSkA1a8ZU2YSc2I9AF6Xjwy4Hm2Qp6H7Yu_mTtPfHEgBbur8/s1600/raffle-ticket-printing.png" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
If you are printing on Letter size paper, then use 7.5" wide, 2.5" high and margins of 0.5":<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjsUMbZNNOqqah2RvMJw07aIQm5prJe3lgrNrPdNBuZD8bpTDXaTTKOXUjspTIesGLLFiG4Mt28deR81gP57qSSyVECG0lKap9t-sncAOQ06sNQKy7ErPhKTXEcvnD7194i4Rx92pyek80/s1600/raffle-ticket-printing-on-letter-size-paper.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjsUMbZNNOqqah2RvMJw07aIQm5prJe3lgrNrPdNBuZD8bpTDXaTTKOXUjspTIesGLLFiG4Mt28deR81gP57qSSyVECG0lKap9t-sncAOQ06sNQKy7ErPhKTXEcvnD7194i4Rx92pyek80/s1600/raffle-ticket-printing-on-letter-size-paper.png" /></a></div>
<br />
Now add text and maybe a logo to create your raffle ticket. Remember to:<br />
<br />
- Include a ticket stub which you can tear off<br />
- Leave space for the raffle ticket number (we'll be adding that in a moment)<br />
- 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. <a href="http://www.direct.gov.uk/en/HomeAndCommunity/Gettinginvolvedinyourcommunity/DG_199132">More about that here.</a>)<br />
<b><br /></b>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZdT_k3HiO6VJVZ-MzY0whGP2UPCQAXkdlR0fyJ1PEh5exFqUKD9dhNcPBjA-zHFw2RxkQSQ9TBu9o_2-9IDMH6KZMm2qBTwq-JCT6RaYE_uOEXEP6kZeg53Us8IE6PRz2xKkaOva3Bi0/s1600/raffle-ticket-example.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZdT_k3HiO6VJVZ-MzY0whGP2UPCQAXkdlR0fyJ1PEh5exFqUKD9dhNcPBjA-zHFw2RxkQSQ9TBu9o_2-9IDMH6KZMm2qBTwq-JCT6RaYE_uOEXEP6kZeg53Us8IE6PRz2xKkaOva3Bi0/s1600/raffle-ticket-example.png" /></a></div>
<br />
<hr />
<div style="text-align: center;">
<b><i style="background-color: yellow;">Too much like hard work? Try <a href="http://app.raffleticketcreator.com/">this online tool to design and print your own raffle tickets</a> without battling with Excel and Publisher!</i></b></div>
<hr />
<b><br /></b>
<br />
<h2>
<b>2. Create a list of raffle ticket numbers in Excel (or another spreadsheet program).</b></h2>
<br />
<br />
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):<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjdznfbE8G4rvK_Ts4q92PLVCDISaKOaK77zWBhAXAiLQCq_rYk3J2CygUV-x9OX6blaxHaIi4VJ7HN7HeFJwu7jDmJ-H1atSFEdze_sTjrQtxf1CkzzoQ1GDGYPpI_Ckg7jGUB9-9l3V4/s1600/raffle-ticket-numbering.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjdznfbE8G4rvK_Ts4q92PLVCDISaKOaK77zWBhAXAiLQCq_rYk3J2CygUV-x9OX6blaxHaIi4VJ7HN7HeFJwu7jDmJ-H1atSFEdze_sTjrQtxf1CkzzoQ1GDGYPpI_Ckg7jGUB9-9l3V4/s1600/raffle-ticket-numbering.png" /></a></div>
<br />
In the cell below, type "=A1+1" (without quotes) and hit enter/return:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjdH2WPeHbq4cFausdtH_Wgfmv7R0H5MlHEeFVfb4m7KhIA0fFzkmd-iwz9xYSCQokUdvB_MGiJmMB-4lU6kb4aHjsfffr8kG6FXQY_ZYX1NJknDh4bx5FBGe6f-CqcxQxWOBJ0R69iYkc/s1600/raffle-ticket-unique-numbering.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjdH2WPeHbq4cFausdtH_Wgfmv7R0H5MlHEeFVfb4m7KhIA0fFzkmd-iwz9xYSCQokUdvB_MGiJmMB-4lU6kb4aHjsfffr8kG6FXQY_ZYX1NJknDh4bx5FBGe6f-CqcxQxWOBJ0R69iYkc/s1600/raffle-ticket-unique-numbering.png" /></a></div>
<br />
That'll put a 2 in that cell, like this:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgrXfkVZBv_k77MLgZOt4cIA9_OFUfSiN6QAyFmE84BP3e0wj3CJVyxz4eqpbVfoerJbhsTajMAmQ7uEmLy3rFskOVcNqUHGiyuKc9QOao70ridPFtkMrivPtJrt3vsi5b1dBeen-qfbAE/s1600/raffle-ticket-numbers.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgrXfkVZBv_k77MLgZOt4cIA9_OFUfSiN6QAyFmE84BP3e0wj3CJVyxz4eqpbVfoerJbhsTajMAmQ7uEmLy3rFskOVcNqUHGiyuKc9QOao70ridPFtkMrivPtJrt3vsi5b1dBeen-qfbAE/s320/raffle-ticket-numbers.png" width="225" /></a></div>
<br />
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:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhq3eId9R_Hr6pyCD1uPYN1ZQrG6FHgC1lwzAjRbnB_R-kOeJLqSLCgZqsinvUoKCt9lgqMDjpxMombXVBca1u8exkCwpl1PslHjfjvBW0aw5IvCfgfoEVvh2CdiN0E9PTMC4GDIWasqfc/s1600/raffle-ticket-add-unique-numbers.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhq3eId9R_Hr6pyCD1uPYN1ZQrG6FHgC1lwzAjRbnB_R-kOeJLqSLCgZqsinvUoKCt9lgqMDjpxMombXVBca1u8exkCwpl1PslHjfjvBW0aw5IvCfgfoEVvh2CdiN0E9PTMC4GDIWasqfc/s1600/raffle-ticket-add-unique-numbers.png" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
... all the way down to (say) 500 rows (to give you 500 unique ticket numbers):<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhno5DtVi00h7fAVYZSSBWwHaVJODy7wx5i_iYlbBdnYPruDFqxctmMqxuMUbIqAVsloRyzxBbb5Ptpa2u7grZn632nmhLi4hvfQzJvsLgxqcLP8qrUKjfVziSWdyeIM4LOZXJZvqdpdUk/s1600/raffle-ticket-500-unique-numbers.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhno5DtVi00h7fAVYZSSBWwHaVJODy7wx5i_iYlbBdnYPruDFqxctmMqxuMUbIqAVsloRyzxBbb5Ptpa2u7grZn632nmhLi4hvfQzJvsLgxqcLP8qrUKjfVziSWdyeIM4LOZXJZvqdpdUk/s1600/raffle-ticket-500-unique-numbers.png" /></a></div>
<br />
<i>(If you prefer using the keyboard, rather than the mouse, then do this instead of dragging down: select cell A2, hit CTRL+C to copy, then select cell A3 and use SHIFT+PgDn to select all the way down to row 500. Then hit CTRL+V to paste.)</i><br />
<br />
Now save your spreadsheet somewhere you can find it again, and close Excel.<br />
<br />
<h2>
<b>3. Add the numbers to your raffle tickets in Publisher</b></h2>
Return to Publisher and click on Tools > Mailings and Catalogs > Mail Merge...<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEinjerVjlmeabdd9dn9_8gvQW7-ymqN48y8-lQ2tjvJoJ7wD0ZdsBDu0LHDV8pyWDDsAjnH2hOktw_h-9vVD9axDiznTDkj2k-ZMFrFvFow0PxXuXYJoekcZca5mPK9S0orYaKJNMWgbiY/s1600/raffle-ticket-mail-merge.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEinjerVjlmeabdd9dn9_8gvQW7-ymqN48y8-lQ2tjvJoJ7wD0ZdsBDu0LHDV8pyWDDsAjnH2hOktw_h-9vVD9axDiznTDkj2k-ZMFrFvFow0PxXuXYJoekcZca5mPK9S0orYaKJNMWgbiY/s1600/raffle-ticket-mail-merge.png" /></a></div>
<div class="separator" style="clear: both; text-align: -webkit-auto;">
<br /></div>
<br />
A big panel should appear on the left hand side of the screen.<br />
<br />
Check that "Use an existing list" is selected, then click "Next: Create or connect to an existing list":<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6EE7r55GUHReXLxvmla2ryit8bS7pkHOtPuCQhMWLr0IrIg52d4n5FxI-L0jI2V2sI5r7cl27AnXslEWHIpUGGmwrFNwLfa1XWllHw6ZectHF2KspLFilYfKTziwcuWVgb_mCunwIfB4/s1600/raffle-ticket-mail-merge-step1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6EE7r55GUHReXLxvmla2ryit8bS7pkHOtPuCQhMWLr0IrIg52d4n5FxI-L0jI2V2sI5r7cl27AnXslEWHIpUGGmwrFNwLfa1XWllHw6ZectHF2KspLFilYfKTziwcuWVgb_mCunwIfB4/s1600/raffle-ticket-mail-merge-step1.png" /></a></div>
<br />
Navigate to where you earlier saved your raffle ticket numbers spreadsheet and click Open:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjmmTkvKs3SoW2NcIM4K518MVVLtewQgOqKtaK5jv0OvuOaQ4K7GO-XZ29WG_7ZixN7xjdWoTmyO-O5TkUvyWGQzY6ZNTgaoAlP9k5qmT3QBdUEWBFkiBV0NKZF7kJ25Ut_gMHYCOPhFxo/s1600/raffle-ticket-mail-merge-link-to-ticket-numbers.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjmmTkvKs3SoW2NcIM4K518MVVLtewQgOqKtaK5jv0OvuOaQ4K7GO-XZ29WG_7ZixN7xjdWoTmyO-O5TkUvyWGQzY6ZNTgaoAlP9k5qmT3QBdUEWBFkiBV0NKZF7kJ25Ut_gMHYCOPhFxo/s1600/raffle-ticket-mail-merge-link-to-ticket-numbers.png" /></a></div>
<br />
On the next screen, be sure to <b>uncheck the box "First row of data contains column headers"</b>, then click OK:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEggVP19YWwNyJTYQYNFLgmGbtxzvq2l5FA_Ua7w-I68cuHWt_0eQCGv_nKxd4La-w3zL_qMVHMsyXlBSt8rYjMkfocFf6cNiaHVdmReS2tLGMv0HIX3OCy9nCZh67JcmNQUNfcqNh_meFA/s1600/raffle-ticket-mail-merge-link-to-ticket-numbers2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEggVP19YWwNyJTYQYNFLgmGbtxzvq2l5FA_Ua7w-I68cuHWt_0eQCGv_nKxd4La-w3zL_qMVHMsyXlBSt8rYjMkfocFf6cNiaHVdmReS2tLGMv0HIX3OCy9nCZh67JcmNQUNfcqNh_meFA/s1600/raffle-ticket-mail-merge-link-to-ticket-numbers2.png" /></a></div>
<br />
Just click OK on the next screen:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQPpIzJyTqAQCOnx_AEn47FIQkLG9d_uCc_ZLsAwvQjR2DMUFq4-Ja_Q-CjAlAn6asY9KH9r3RdDrnLDYUQUaL1SUSL4SfLcDKyputRgaTaJ6ViqixAeI8BPqinhCDnqKHGo-v7vzHICs/s1600/raffle-ticket-mail-merge-link-to-ticket-numbers3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQPpIzJyTqAQCOnx_AEn47FIQkLG9d_uCc_ZLsAwvQjR2DMUFq4-Ja_Q-CjAlAn6asY9KH9r3RdDrnLDYUQUaL1SUSL4SfLcDKyputRgaTaJ6ViqixAeI8BPqinhCDnqKHGo-v7vzHICs/s1600/raffle-ticket-mail-merge-link-to-ticket-numbers3.png" /></a></div>
<br />
<br />
<br />
<br />
<hr />
<div style="text-align: center;">
<b><i style="background-color: yellow;">C'mon, this is crazy-complicated! Save yourself a few hours and try <a href="http://app.raffleticketcreator.com/">this tool which lets you to design and print your own raffle tickets online</a>. Print them at home, as many as you need.</i></b></div>
<div style="text-align: center;">
<b><i style="background-color: yellow;">Or, read on for the rest of the do-it-yourself-the-hard-way instructions. ;-)</i></b></div>
<hr />
<br />
<br />
<br />
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:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiPhA7MnQCuCFRqqsT5WEZFFIUb0tdtMm0dJIE2K7rk1dhwLqMtS7UGtl6HL7BfTbD1gafs1X05znirQ0nsR-kWTNJOjdQyMujaljzxKk1cdFSnBzA9wpm_SmdcJNNBwRaVw_sqaca19Q4/s1600/raffle-ticket-insert-ticket-numbers.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiPhA7MnQCuCFRqqsT5WEZFFIUb0tdtMm0dJIE2K7rk1dhwLqMtS7UGtl6HL7BfTbD1gafs1X05znirQ0nsR-kWTNJOjdQyMujaljzxKk1cdFSnBzA9wpm_SmdcJNNBwRaVw_sqaca19Q4/s1600/raffle-ticket-insert-ticket-numbers.png" /></a></div>
<br />
Repeat for the stub, to print the ticket number there also:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQfz3aKGEyk6_R-6kMsHSyEqwuxgOH88DCV3HdE7QzjMLmAfmcGfaCO-V4XOsTAwqrafgPNzcN8tBvcfqcnVo0e4nWUL1YKXQNB85eIBdfM_SP19Nt8tLezdkPqKkhIKo4ErgMyL2bPEM/s1600/raffle-ticket-insert-ticket-numbers-2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQfz3aKGEyk6_R-6kMsHSyEqwuxgOH88DCV3HdE7QzjMLmAfmcGfaCO-V4XOsTAwqrafgPNzcN8tBvcfqcnVo0e4nWUL1YKXQNB85eIBdfM_SP19Nt8tLezdkPqKkhIKo4ErgMyL2bPEM/s1600/raffle-ticket-insert-ticket-numbers-2.png" /></a></div>
<br />
Now, down the bottom of the lefthand panel, click "Next: Create merged publications":<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKwBCV4dpEvmKIZxNz6ZOjNn-psVJR-RODEx5isKCcl_rkg-cMeMJJjPMpE8nPN8L8agZjquiDC6wdIYnmiLvOnIoFUvyG6D6LhSprNTggs6x22oUPcWdEDStHuIplDV9dnzpx0lZx3s8/s1600/raffle-ticket-insert-ticket-numbers-3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKwBCV4dpEvmKIZxNz6ZOjNn-psVJR-RODEx5isKCcl_rkg-cMeMJJjPMpE8nPN8L8agZjquiDC6wdIYnmiLvOnIoFUvyG6D6LhSprNTggs6x22oUPcWdEDStHuIplDV9dnzpx0lZx3s8/s1600/raffle-ticket-insert-ticket-numbers-3.png" /></a></div>
<br />
Then, click "Print...":<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhaNTkWhRGpThDC22oB6-D8bJaXtZxXRT_6KZjdZmxpsTb-zpCV2KdMtCsBa4GHGoZiR8L_7Di0Qw3lqOwJXUFKY0onRJit1vv6uKSJHFe8Kd7qvn9Cwgrf470VT-GxV19a2h1lsKdHTKo/s1600/print-raffle-tickets.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhaNTkWhRGpThDC22oB6-D8bJaXtZxXRT_6KZjdZmxpsTb-zpCV2KdMtCsBa4GHGoZiR8L_7Di0Qw3lqOwJXUFKY0onRJit1vv6uKSJHFe8Kd7qvn9Cwgrf470VT-GxV19a2h1lsKdHTKo/s1600/print-raffle-tickets.png" /></a></div>
<br />
Now, pay attention for this last step. Check all of the following:<br />
<br />
1. Select "Multiple Pages per sheet" (<b>not </b>Multiple Copies per sheet)<br />
2. Choose the correct paper size for the paper you are actually printing on (A4 or Letter)<br />
3. Select "Portrait"<br />
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)<br />
5. Click "Print"<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhw4tMQ2er3oNs-5GoOwYKvIF0ICc8ndJjTTaZC1a3TR-Ew4R3UMvSvieioDWGxX-8ouGvoUYbbH2VXYOYlWffbEc3WE5jg1UWdf3ats6ZJyCumLdSQERIvhuQsSSuOB5gwf3jNMtfJB98/s1600/print-raffle-tickets-on-your-own-printer.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhw4tMQ2er3oNs-5GoOwYKvIF0ICc8ndJjTTaZC1a3TR-Ew4R3UMvSvieioDWGxX-8ouGvoUYbbH2VXYOYlWffbEc3WE5jg1UWdf3ats6ZJyCumLdSQERIvhuQsSSuOB5gwf3jNMtfJB98/s1600/print-raffle-tickets-on-your-own-printer.png" /></a></div>
<br />
Something like this should pop out of your printer. Four raffle tickets on a page, each with a different number:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgDecytkhdLI5OEoKNIHAD8B3mfnL52drZYKHPGOj-FsQkl3c_9IQPtV9SPYb2JlA9AwQ6T3yV4gezRf4kE-f1N6AKDAZApKHGL6ClanUPPZ3aVLmVZSU8JcVhy2bSPE8l8OCChjDDWtGQ/s1600/Untitled+Document+9_01.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgDecytkhdLI5OEoKNIHAD8B3mfnL52drZYKHPGOj-FsQkl3c_9IQPtV9SPYb2JlA9AwQ6T3yV4gezRf4kE-f1N6AKDAZApKHGL6ClanUPPZ3aVLmVZSU8JcVhy2bSPE8l8OCChjDDWtGQ/s640/Untitled+Document+9_01.jpg" width="451" /></a></div>
<br />
<br />
If you are happy with the results, click "Print..." again in the left hand panel:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhaNTkWhRGpThDC22oB6-D8bJaXtZxXRT_6KZjdZmxpsTb-zpCV2KdMtCsBa4GHGoZiR8L_7Di0Qw3lqOwJXUFKY0onRJit1vv6uKSJHFe8Kd7qvn9Cwgrf470VT-GxV19a2h1lsKdHTKo/s1600/print-raffle-tickets.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhaNTkWhRGpThDC22oB6-D8bJaXtZxXRT_6KZjdZmxpsTb-zpCV2KdMtCsBa4GHGoZiR8L_7Di0Qw3lqOwJXUFKY0onRJit1vv6uKSJHFe8Kd7qvn9Cwgrf470VT-GxV19a2h1lsKdHTKo/s320/print-raffle-tickets.png" width="297" /></a></div>
<br />
But this time set Page Range to "All entries":<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgb6rWO_vRIOdIQ5HOYhLgJoJjv62_A3RJOY_QjKvQajpPyNJrMJbPf8zNkOsa6vyigo6SmD8VULVEl5eKa3qvAFHd2vtVImyBouxIfMNXo_sIZGTBiiiQYQq1TtHk35hDL6tl0rIa7H0s/s1600/print-500-raffle-tickets-on-my-printer.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgb6rWO_vRIOdIQ5HOYhLgJoJjv62_A3RJOY_QjKvQajpPyNJrMJbPf8zNkOsa6vyigo6SmD8VULVEl5eKa3qvAFHd2vtVImyBouxIfMNXo_sIZGTBiiiQYQq1TtHk35hDL6tl0rIa7H0s/s1600/print-500-raffle-tickets-on-my-printer.png" /></a></div>
<br />
... and click the Print button, then all your raffle tickets will come out of the printer, each with a unique ticket number.<br />
<br />
Congratulations!<br />
<div style="text-align: center;">
<br /></div>
<hr />
<div style="text-align: center;">
<b><i style="background-color: yellow;">If you got to the end of these instructions, then well done you! If skipped to bottom, then maybe consider trying <a href="http://app.raffleticketcreator.com/">this online tool to design and print your own raffle tickets</a> 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:</i></b><br />
<b><i style="background-color: yellow;"><br /></i></b>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://app.raffleticketcreator.com/"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj9rIzXyUQXvpGxVfMRMv4pj80Uz66lmm_coHobHhim-kixmHeD_LW-Ex6w3GxG-GXlEwFgDa1rt-xaXEzhlwPtRDR7AOdDZNClLzokH4_znfesVJ7nYHEw8NMzENBbkWpYAOU2ibhdydY/s1600/Numbered-raffle-tickets.png" /></a></div>
<b><i style="background-color: yellow;"><br /></i></b>
<b><i style="background-color: yellow;"><br /></i></b></div>
<hr />
<br />
<br />Bruce Ghttp://www.blogger.com/profile/09056360686702009784noreply@blogger.com27