You don’t need to be so much worried about how you will get the prizes to award the winners. In each community there are certain organizations or businesses that recognize the importance and the hustle that one goes through in selling the raffle tickets, these businesses or organizations will be quite instrumental in catering for the prizes. Alternatively you could choose to have a 50/50 raffle which implies that half of the donations or cash will have to be given to the winner of the chosen raffle ticket and the remaining amount will be retained by the organization or group which was responsible for the sale of the raffle tickets. This kind of arrangement is common among the youth and the surrounding community is mostly receptive and helpful to those raising the funds.
My quick process involves setting up a row of plaques with a01, a02, a03, thru a09. Then copy the plaques to the clipboard. Run the REPLACE TEXT feature to replace "a" with "1". Move row down and paste clipboard back into page. Run REPLACE TEXT to replace "a" with "2". Repeat until I get all the numbers. It's faster than manually typing the numbers in but I know there's go to be someway of automating the process.
There’s an old Steve Martin joke about how to make a million dollars which starts, “First, get a million dollars…” That’s the key to this trick, too: First, get a bunch of numbers. Here’s a file with 1,197 numbers in it. Now import or paste those numbers into a thread so that the numbers appear in the right place. If you need two matching numbers, just import it twice.
If you’re producing any kind of numbered items in-house that are multiple-up on a sheet where you need to control all the variables to meet your production needs, the autonumbering feature through numbered lists is the way to go! Just step and repeat away & InDesign will do all the work. No need to fool with a seperate “numbers” file or deal with a data merged document. I think it’s by far the best option for basic numbering.
I’d like to share my solution. It came to me partially in my sleep, I tried refining it this morning but because of time, finally had my production person print the manually numbered tickets so that we could deliver them to the customer who needed them today. Here is my solution. I deduced that it would be better to let a program designed to count, do the counting. I used Excel. I then let InDesign CS4 do the merging. Here’s the formula.
A raffle refers to a way of generating money by selling numbered tickets, then one or some of the sold tickets are drawn at random and the holder or holders of these tickets get to win a prize. This method of raising cash has been employed by many people especially groups which want to acquire an asset or start a certain project. It is thus not surprising when your child approaches you on how to come up with raffle to help his/her club raise some cash.
Nowadays when you explore the internet you will be bewildered by the number of Word templates which has in itself several varieties of event tickets for you to use conveniently. Microsoft Word gives you options to avail those tickets as they appear on the template or you can make it creative, artistic and alluring at your wits’ imaginative power. You can even slot in images for a better appeal!
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.
I am using your instructions to create a page of tickets - the design has been created as a picture so I added a text box to "hold" the mail merge instructions but I keep getting the error message "You cannot include DATA, NEXT, NEXTIF, or SKIPIF fields in comments, headers, footers, footnotes or endnotes." I have not included any of these but I'm wondering if it's because I've attempted to insert it in a text box. Is there an easy way to do this? TIA