¨ FrontPage ¨ Outlook ¨
¨ Miscellaneous ¨
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 here.
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.
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:
Some tips for creating your tickets.
Then do a print preview.
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.
OfficeArtilces.com debuted on May 26, 2005.
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.
All contents © 1998-2014 by MrExcel Consulting | All rights reserved