How to Make Raffle Tickets With Mail Merge

You’re selling raffle tickets to make money, so why buy the tickets pre-printed? Using Microsoft Word’s mail merge function, you can create your own raffle tickets and design them any way you please. A mail merge doesn’t have to make mail; it is simply a way to define certainly elements of a document, then automatically insert variable elements, such as raffle ticket numbers. The most important thing to remember is that each ticket needs a mate–you don’t want to pull winning ticket number 81018 only to find that no one bought that one.

Things You’ll Need:

  • Microsoft Word 2007 or higher
  • Microsoft Excel 2007 or higher
  • Printer
  • Sturdy paper
  • Paper cutter or scissors

You can use previous versions of Microsoft Excel and Word to make mail merge raffle tickets; the process is similar. For example, in Word 2003, you’ll find Mail Merge under Tools|Letters and Mailings.

Using Excel

  1. Create a new Excel spreadsheet.
  2. Based loosely on how many tickets you hope to sell, enter a number in cell A1. Standard raffle practice tends toward numbers with at least a few digits, so instead of starting with 1 you might start with 10001.
  3. In cell A2 enter the next number. If you started with 10001, enter 10002.
  4. Fill out the series by bringing your mouse cursor over to hover at the lower right corner of cell A2. When the cursor changes from a large outlined plus symbol to a smaller, plain plus symbol, click and hold the left mouse button, then drag the mouse straight down to select more cells in column A.
  5. Stop dragging when you’ve selected enough numbers. Note that while you’re holding the mouse button down, a tool tip will appear nearby displaying the number you’re up to. If you’ve gone too far, simply mouse back up.
  6. Save and close the spreadsheet.

Using Word

  1. Open a new blank document in Word. Create two raffle ticket designs, one for the person who buys the ticket and one for the organization selling them. Make sure to connect the two tickets, for example by making them in two-cell tables, side-by-side. Include the name of the organization, perhaps the first prize, and any other information you want on the buyer’s ticket. You might, for example, include spaces for the buyer’s name (“Name__________”) and phone number on the organization’s ticket. On both tickets, enter a dummy number for the raffle ticket number as a placeholder.
  2. Click on the Mailings tab. Click on “Start Mail Merge,” then “Directory.” Nothing will happen, but all is well.
  3. Click on “Select Recipients.” Choose “Use Existing List.” Navigate to the spreadsheet file you saved in step 5 and click “Open.”
  4. In the “Select Table” dialog box that opens, choose the first worksheet and uncheck the box labeled “First row of data contains column headers.” Click “OK.”
  5. Back in the document, select your dummy number in the first ticket. Click the button “Insert Merge Field,” then select the one entry in the drop-down menu, which will be the first number from your spreadsheet.
  6. Repeat step 9 in the second ticket.
  7. Check your work by clicking on the “Preview Results” button.
  8. Click “Finish & Merge.” Choose “Edit Individual Documents,” then select “All” in the “Merge to New Document” box.
  9. A new document will open showing every single set of raffle tickets, each with its own number. Check over the document to be sure everything looks right. Alter the page margins if necessary.

Finishing Up

  1. Print the document on sturdy paper.
  2. Use scissors or a paper cutter to cut the tickets, leaving each set intact. When a person buys a ticket, the seller should separate the tickets right then, giving one ticket to the buyer and dropping the other ticket into the receptacle from which the winning ticket will be drawn.
Published in: on November 23, 2010 at 5:07 pm  Comments (14)  

The URI to TrackBack this entry is: https://blackbeltreview.wordpress.com/2010/11/23/how-to-make-raffle-tickets-with-mail-merge/trackback/

RSS feed for comments on this post.

14 CommentsLeave a comment

  1. I love your site, it looks amazing !

  2. Thanks for your kind words, Georgina. Be sure to follow us on http://twitter.com/#!/blackbeltreview

  3. It is very interesting for me to read the blog. Thanx for it. I like such themes and everything connected to them. I definitely want to read a bit more on that site soon.

    Sara Kripke

  4. It was very interesting for me to read this post. Thanx for it. I like such topics and everything connected to this matter. I would like to read more on this blog soon.

    Sara Flouee

  5. It is very interesting for me to read this blog. Thanks for it. I like such topics and everything connected to them. I would like to read more on this site soon.

    Mary Smith

  6. It was very interesting for me to read the article. Thank author for it. I like such themes and anything that is connected to this matter. I definitely want to read more on that blog soon.

    Natasha Smith

  7. It is certainly interesting for me to read this article. Thanx for it. I like such themes and anything that is connected to them. I would like to read more soon.

    Natasha Stone

  8. It was certainly interesting for me to read the post. Thanks for it. I like such themes and anything that is connected to this matter. I would like to read more soon.

  9. I found your blog on google and read a few of your other posts. I just added you to my Google News Reader. Keep up the good work Look forward to reading more from you in the future.

  10. It is certainly interesting for me to read the blog. Thanx for it. I like such themes and everything connected to this matter. I would like to read a bit more soon.

  11. Very nice information.

  12. thank your for your post

  13. Im speechless. This is a superb blog and very enticing too. Great work! Thats not in point of fact so much coming from an amateur publisher like me, however its all I may say after diving into your posts. Nice grammar and vocabulary. No longer like other blogs. You really recognize what you?re speaking approximately too. So much that you just made me want to explore more. Your weblog has grow to be a stepping stone for me, my friend.

  14. How do you print more than one page? I need 200 raffle tickets and all I can get is the first page. How do I get more than one page?


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 32 other followers

%d bloggers like this: