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.
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.
I am trying to create raffle tickets, 4 on a page with only a number on the stub. My problem is when I get to the print preview and change it to "multiple pages per sheet" it is just changing the number on the next page and not on the next ticket. I followed all the directions on adding the number to each ticket from the merge document (of course all the step by step information I can find is only for 2007 and NOT 2013 so guessing there is something wrong with what I am doing). When I go into the print screen it is also changing my paper from 8 1/2 x 11 to 11 x 17 and putting 8 on the page.
Click "Save File" at the Opening Raffle Ticket Setup prompt. Go to your downloads folder and open the "Raffle Ticket" .exe file. Click "Run" at the security prompt. Click "Next" twice at the installation wizard prompt. Select "I accept" at the software terms. Enter your "User Name" and "Organization" details. Click "Next" twice and select "Install." The software loads on your computer. Click "Finish" to complete the installation.
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.
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.
Now for the slightly hard bit. If you just try and complete your merge now, you'll get several pages of tickets. Each page will have four tickets on it. But all tickets on any page will have the same number. Each page will have a different number, but all the tickets on that page will have the same number. That's no good. You need each ticket to have a different number.