Microsoft doesn't appear to provide a raffle tickets template and I'd seen
several requests, to I decided to create one.
I had wanted to create a file that didn't require Excel as the data source,
so I created one using SEQ fields. It was terrible and too huge to mention
(thanks Doug Robbins), so I recreated it using Word as the data source so that
people who only have Word can use it. You can create up to 5,000 tickets without
changing the data file. If you only have Word and need to create more than 5,000
tickets, please don't type the ticket numbers. Just
drop me an email and I'll create
another data file for you with the required numbers.
You can download the required files by clicking
There are two files in the Zip file. Both files must be removed from the zip
file and placed in the same folder on your PC or on your Desktop.
raffletickets.doc contains the raffle ticket layout
raffleticketsdata.doc contains the numbers that will print on the raffle
ticket and the ticket stub
Design the Ticket
Open raffletickets.doc. You'll be prompted with the following if you are
running Word 2002 or higher:
If you are comfortable with Word's tables, you should have no problem. Just
insert graphics and text. Don't forget:
You must use Ctrl+Tab if you want to tab within table cells.
I prefer using Inline with Text when I place graphics.
The left-most and right-most columns are NOT part of the ticket. I
inserted those so I could create "crop marks" to cutting the tickets apart
Don't let the row height or column width increase.
You can create one "master", and then copy and paste into the others.
if you're not really used to working with tables.
After your ticket is completely designed, save the file.
Turn on the Mail Merge toolbar and hit the preview button to see what your
tickets will look like.
Then do a print preview.
Merge With Ticket Numbers
Hit the Merge to New Document button on the Mail Merge toolbar.
(I don't advise merging right to the printer. Most of you that are selling
raffle tickets don't want to waste the paper to print them wrong.)
At this time, decide how many tickets you want to print. You can
choose All and print 5,000 or you can choose to print only a certain amount. For
instance, you may want to print records 1 to 500 to print only 500 tickets. If
you need to print more tickets later, you'll want to print records 501 to 1,000
to print another 500 tickets.
MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures
for illustration only, without warranty either expressed or implied, including
but not limited to the implied warranties of merchantability and/or fitness for
a particular purpose. The Formulas, Functions and Visual Basic procedures on
this web site are provided "as is" and we do not guarantee that they can be used
in all situations.
Access®, Excel®, FrontPage®, Outlook®, PowerPoint®, Word® are registered
trademarks of the Microsoft Corporation.
MrExcel® TM is a registered trademark of Tickling Keys, Inc.