You need to create a list of numbers using some method (maybe even through VBA) as a text file, database or other data source, then just insert merge field in the document and use Print Merge to generate multiple labels with different numbers in it. (just need to give it enough space to fit the longest string along as many lines as you think there could be) If I reserve space for 50 chars and the major strings are 25 chars, the result is not professional looking. My solution for all print merge for ID cards (and similarities, incl. Auto numbering) is to merging data BEFORE printing, in an CDR file with all pages. So, I check all the cards and I correct only on text object how need. I found an software with this capabilities, but 300 USD is excesive (not only for Est Europe) for one only week of working (yes, his UI is better than my). I found an software with this capabilities, but 300 USD is excesive (not only for Est Europe) for one only week of working (yes, his UI is better than my) And my script use photo also.
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.
Thank you for these clear instructions. I have had the same problem as Mommy Vaughan and followed the suggestion. However, on re-opening the Word document, I have the dialogue box Invalid Merge Field. I have to use Task Manager to close down Word. I am using Word 2010. Maybe that is part or all of the problem. Any ideas please? I need to sort this by tomorrow night to print them on Monday!
The script sets the numbering of multiple gang up tickets so that after cutting the tickets do not need recollating to put back into order (like the CS2 script) but also does counterfoil numbers, prefixes, suffixes, leading zeros and output of pages in reverse order for ‘face up’ printing. The script is. Now I’m feeling rather dumb and frustrated. I just spent the last couple of hour numbering the tickets using keyboard shortcuts to detach the master and substitute numbers. Did 500 tickets this way. Corel crashed repeatedly on my production person today while he was trying to number them using the plug-in. I couldn’t figure out how to make Mike’s script work.

Change all other existing text to reflect the correct date and prizes by highlighting the words and either editing or deleting the existing text. Font size and style can be adjusted using the font toolbar above the document. Images can be added by using the Insert menu in the toolbar and following the same process as inserting images to a Word document.

Number Pro does not create your raffle ticket or document it just allows an easy way to  number them. Check out Number Pro, take a look at the demo videos and even try the demo of Number Pro to see how it works. Number Pro is a cloud based application meaning there is no download of the application. We access the application online in the members area. They offer a three year membership with unlimited use.
OfficeArticles.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.

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.


It depends what the design is for the tickets. But if you set up primary text frames, linked for the area for the numbers, you can create a numbered list with the numbering format you want. Then, just pour in a whole load of paragraph returns that have that numbered list applied. And make sure each numbered paragraph is set to start in the next column.
Getting Word to put a unique number on each raffle ticket is easy enough, but persuading Word to print out several uniquely-numbered raffle tickets per sheet of paper is very hard (I think it is impossible, actually. At least I couldn't figure it out. UPDATE: I did figure it out. Instructions for printing raffle tickets using Microsoft Word are here.). And you don't really want to have every raffle ticket use up a whole sheet of paper.

It depends what the design is for the tickets. But if you set up primary text frames, linked for the area for the numbers, you can create a numbered list with the numbering format you want. Then, just pour in a whole load of paragraph returns that have that numbered list applied. And make sure each numbered paragraph is set to start in the next column.
I to, have read through your directions while using both mac & pc platforms. I fail to find the “standard features” screen shots that you show above in either program. I too have spent several hours trying to get the sequential 3-up numbering as described. In trying to produce 300 tickets, I can get all of the first numbered position to be sequential over 100 pages. But, when moving down to the second or third ticket position on the page and setting up the numbering, I repeatedly find that I get a repeat of the first 100 numbers. I am lost as to how to proceed. Is there any other missing step or info that I am assumed to have knowledge about that was not mentioned above? If you know of some other site that might explain this process any better, please post. Thanks for your help.
I answer readers' questions about Microsoft Office when I can, but there's no guarantee. When contacting me, be as specific as possible. For example, "Please troubleshoot my workbook and fix what's wrong" probably won't get a response, but "Can you tell me why this formula isn't returning the expected results?" might. Please mention the app and version that you're using. I'm not reimbursed by TechRepublic for my time or expertise, nor do I ask for a fee from readers. You can contact me at susansalesharkins@gmail.com.
Whether they're getting ready to win or ready to enter your big event, your guests will love the thrill of entering with our raffle tickets. Each ticket comes with a twin ticket, which means you get to keep one while they keep the other – there's no memorizing of entry numbers with these ticket! Also the number of the ticket remains with your patrons as long as the ticket does! Plus, with the great selection of colors we offer, the ticket isn't going to get lost any time soon.
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.
Create a master frame in ID to hold the number and if I have more than one ticket on a page just link the frames. Apply a paragraph style that starts in a new frame for the numbers. Place the text file with a shift click and the numbers are formatted and the new pages are autoflowed. The number list is very easy to create in Excel with the auto fill feature for that type of thing.
Am I the only individual here who is using CS3, and trying the method described, only to find that my version (5.0.2) for the mac doesn’t have the options anywhere that the author suggests? I have spent the past 2 hours trying to find the same screenshots the author has, only to become reall discouraged. Perhaps he is using a windows version that is setup differently? raffle ticket numbering using indesign
×