Another fan of Fusion Pro Desktop here. This is exactly what you need. We have sold both PrintShop Mail and Fusion Pro Desktop for this very application (numbering) and other VDP applications. Fusion Pro Desktop easily beats PrintShop Mail from both a price and performance viewpoint. You could also try Printer's Bench http://www.elkriversystems.com/ProductsList.aspx for a good entry level package
Thanks very much for your prompt reply, which reassured me that I was on the right path. From having read various Help topics, I suspected that I'd have to use an Excel data source for the numbers. Fortunately, my knowledge of Excel was good enough to know about the drag and drop facility to create automatic sequential numbering, so the data source creation was easy. In the end, it was the mail merge (no surprises?) which proved a tad tricky, but I got there in the end. I've used MM many times and quite happily in Word documents, but for Publisher label format, it was of course a bit different. The important bit that I had to discover for myself was the significance of, after getting to the Print stage, going into Print options, to Publication & Paper Settings, and selecting Multiple Pages per Sheet (& in my case, also "Single-sided" cos my default of duplex printing had come up). But TA-DA! All is fine now. Thanks very much again.
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.
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.
The SEQ or Sequential Numbering Function in Word is the best and quickest way to number your tickets. Many raffle ticket templates use them, yet few sites explain how it works. To see if it uses the SEQ function, you need to download the template first. Then, open it in Word, click right in the middle of where a serial number is, and then right-click.
Before selling, try to raise as much awareness about your raffle as you can. Flyers are easy to distribute and display – download yours from our free raffle flyer template page. Choose places where you expect a lot of foot traffic. Not only can you hand them out to passersby, but with the right permissions, you can display flyers in store windows and other prominent locations.
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.
I would like to number a voucher book, i have place 4 vouchers on a page, the thing is that i want each of these vouchers to start with different number, 100, 200, 300, 400, and then i want to number them 99 times. The problem is that they have to be numbered only 1 per page, so that when i have printed them all i can easily crop them and staple them right up with having to go through it all.
Just download the Raffle tickets with consecutive numbering and matching stubs from the Microsoft Office website. It is a 2003 version and I have Office 2010. The template has sequential numbering and displays 8 tickets on 2 pages, but I need 3000 tickets. How do I add more tickets to this document. I have looked online for tutorials, but most are for starting a ticket from scratch. Please help!!
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.
I basically used Bob Levine’s method (thanks) but wanted to add some extra detail – am using CS2 which is somewhat behind CS3 in this area. David, I was very discouraged to read your response to Josh on April 28th 2008. It seems your comment was quite dismissive to him with exactly no feedback help. He seemed to be looking for some more help trying to work through what you and the other InDesign gurus discuss as a “simple process”. 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.
i’ve had to do tons of this lately and found that for the amounts of tickets being done (e.g. 7000 x 10 tickets + cover & mailer) that chuckT’s solution almost 2 years ago is similar to what i use. would be interested to know if others doing similar VDP are using a wholly indesign/excel solution, or if specific VDP software such as XMPie are being used.
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.
I'm trying to number some custom raffle tickets, 10-up on a 12x18 document. I thought surely there's a way InDesign can do that through a master page or something like that but a good google search isn't really producing any conclusive results. I've seen talks here and there about data merge with a .txt that has the numbers on it but haven't seen much on doing this with tickets that are X-UP on a page. Any help would be great.
We have a 700. In Indesign I design raffle tickets 5 up. You have to create an excel file with your numbering 5 up or 5 columns, save as a text file. Use your data merge in Indesign. If your file is too large your Indesign will crash. So keep the placement of your number and delete all other copy on the page. Then do a data merge. It will create just the numbered pages. Send that to your Fierty command workstation as process and hold. Go back and send original file with just your copy layout as a process and hold job. In your command workstation open copy file
10 Pt. Cast Coat, C1S 80 Lb. Smooth Cover 67 Lb. Bristol Cover 65 Lb. TimberLine Cover 10 Pt. Hot Stock 13 Pt. Tag Stock 24 Lb. Bond 80 Lb. Digital Gloss Cover 80 Lb. Digital Matte Cover 90 Lb. Index 10 Pt. Manilla 110 Lb. Index 100 Lb. Gloss Text 11 Pt. Cast Coat, C1S 12 Pt. Smooth Cover 12 Pt. Cast Coat, C1S 2 Part Carbonless
But it’s not hard to duplicate and reduplicate until you have a thousand or more numbered tickets. I think the conclusion of all these Rube Goldberg approaches is that InDesign still isn’t ready for handling what is really a head-smacking-stupid-simple kind of numbering job — the kind of jobs computers were created for in the first place. My DOS word processor XyWrite — from AD 1987! — could do numbering stuff like this in no time and with no trouble. Quite ridiculous, really, when you consider the staggering graphics and typography capabilities inside InDesign — but the poor thing cannot really count. I handle this much differently. I create a number list in Excel and save as a txt file.
Hello Bruce, I seem to be having a different problem altogether. I created my ticket in word using logos and text boxes as needed, ticket looks great. I followed your very clear instructions but when I did the Finish & Merge I got this message, "You cannot include DATA, NEXT, NEXTIF, or SKIPIF fields in comments, headers, footers, footnotes or endnotes." I then click on OK and get this, "A field calculation error occurred in record 1. Bruce any help would be much appreciated. Thank you!!