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.
In Excel, I created a file with columns A-H labeled: ticket 1, stub 1; ticket2, stub2; ticket3, stub3; ticket4, stub4. I then numbered two rows across 1 -4, then 5 -8. Then I dropped down to A – H in row 260. (I did this to give 1,000+ numbered tickets.) I then used the Excel fill function chosing series and told the program to skip by 4. It filled the rows. I then saved as a tab delimited text file.
You don’t have to be a born salesperson to move all your tickets, but the better your sales tactics, the more successful you’ll probably be. Peter Kajanzy teaches how to crush a sale with pro techniques. One bit of advice he offers: When people ask for the price, instead of doing a complex breakdown of one for $2, three for $5, and so on, go straight to “You can buy five tickets for $8.”
Thank you again for your assistance. I took care of the text boxes and everything works quite well. I had some aggravating moments trying to figure out where the \* MERGEFORMAT switch was coming from; I kept deleting it and it kept coming back like a mosquito. I assume it had something to do with the text boxes. Anyway, the document is now a thing of beauty. Thank you.
The trick is this: I creat an 'template' of the card, somewhere outside of the page. All object for data are text object, with all the formating needed. In place of the photo is an rectangle. The script read an text file (CSV) with the database, duplicate all template object, one by one and replace string in text object with the string from DB and import photo in place of the rectangle, redimension and convert to RGB or CMYK, acording to the initial data (atach.) When the page is full, create another one.
My script looks for the object-name and replaces all the numbers at the end of the text-string. Example: TEST010111 start: 9 how long is the number-string? 5 > TEST00009,TEST00010 and so on every marked object with the specified objectname will get the new string. I have another script that places the marked object(s) in a user-sized sheet after editing the quantity X and Y and the space between the objects.
The event will set up certain prizes. Raffle tickets are then sold, and the people told to hold them until the raffle is held. Raffle tickets are then drawn randomly, and the holders of the winning tickets get a prize. While organizers can be as creative as they wish, offering bulk purchases of tickets and discounts, the basic rules stay the same. The benefit of holding raffles is that donors enjoy the anticipation of possibly winning a prize, while donating to a charity. This makes raffle tickets one of the most popular ways to earn for a nonprofit.
There is very simple solution that we use and that is to lay out the sheet say 6 up on a A4 sheet as a master page and in document setup set the number of pages to 1,000 if that is the amount you require. Put a page number on each ticket on the page and although they will all have the same number on each page, we put the the first two letters of the customers business name before each number followed by the letters of the alphabet so it then reads for example BT1A, BT2A, BT3A, BT1B, BT2B, BT2C and so on as each page is printed.
Simply copy the second page of the template by highlighting that page and pressing CTRL + C. Windows shortcut keys Windows Keyboard Shortcuts 101: The Ultimate Guide Windows Keyboard Shortcuts 101: The Ultimate Guide Keyboard shortcuts can save you hours of time. Master the universal Windows keyboard shortcuts, keyboard tricks for specific programs, and a few other tips to speed up your work. Read More are wonderful things. Then create a new blank page by pressing CTRL + Enter. Then paste the copied page using CTRL + V. Create a new blank page, and paste again. Keep doing this until you have the desired number of pages that you will need.
 Does anybody have an easy way to set up sequential numbering in Coreldraw? Our shop has to lay out unit number plaques for vinyl cutting and sometimes my employee has to manually type in hundreds of numbers. I've read all the print merge suggestions for raffle tickets and such but I need the numbers entered into an object and not during the print process. 
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.
I came across this website that explained how to do it using Microsoft's "Raffle Ticket" template (https://www.techwalla.com/articles/how-to-create-numbered-tickets-in-word). However, when I tried to update the sequences as the article said, I could not find the option to update the field (I think they were referring to the option "edit field"), after copying and pasting the template onto a second page.
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.
Below, we have a small and easy to follow tutorial on how to create sequentially numbered raffle tickets using Microsoft Word and Microsoft Excel. Simply choose one of our 30 raffle ticket templates and download it to your computer. Next, begin the following tutorial. This tutorial will take you through the process of using Excel to create the numbering sequence, which you will then save, and import into Microsoft Word.

In the example I explained, I was using a list, but did it with un-linked text boxes using “continue from previous number” and “continue numbers across stories.” I’m guessing that there is no way to tell InDesign that even though there are 4 text boxes on the page, that there are two different lists? I’d probably have to just create two threaded stories for that scenario to work.


Thank you for the explanation. Yes, our digital machine (Minolta Bizhub) does have a variable data module, however the support folks do not seem to be able to successfully get it to number in the correct order for output to print and stack properly for our needs. Indesign works great in this manor but with the quirps we are discussing here. Anyway your assumption that I do not understand threads is true. I have never done "threading". I am going to focus on this next as you mentioned it is easier than data merge. We do numbering of carbonless forms, raffle and event tickets often here and so the "smoother" the better. Apparently my supervisor requires that I make it work with the tools at hand and will not "invest" in any "pricey" new programs.
When you have Microsoft Publisher at your hand, you need not worry about running to stores to explore and buy tickets for organizing company day outs, vacation give away or a business board meeting. Microsoft Publisher provides you with several Word templates from which you can create event tickets with ease and skill. It even includes the fundamental chronological ordering required for raffles .once you get the ruse of setting up numbers in the ticket series, you can commence numbering in your own style.
I am getting my tickets to number on one side of it. However, I am needing my tickets to have the number on each side, but one side will not number. I have tried several times and it will not number on both sides. I am using an avery template that is printing 10 tickets per page, stub and tearable ticket. But the stub will not number while the tearable ticket will.
×