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.

Given that Word can support 2,147,483,647 SEQ fields, the whole job could be done in a single document containing 30,000 tickets. On my system, creating such a document took only a few minutes and, once created took about two minutes to update the fields - and that was with about 40,000 pairs of SEQ fields coded as {SEQ Ticket \# 00000} and {SEQ Ticket \c \# 00000}. This number formatting is enough to go to 99,999 tickets.
I'm struggling with this as well. I tried creating a .txt file of sequential numbers 1-99 from Excel and brought it in as a datamerge. My tickets are 8"x3", 3-up, but when I did the merge, InDesign added 3,416 pages. Where the Hell is THAT coming from?? Any clue what I'm doing wrong? I'm using a tutorial that is using CS5, but I don't see how that has anything to do with all those bloody pages.
White Birch White Sunfish Yellow Canary Acid Green Flame Orange Hellfire Red Sulphur Yellow Hunters' Orange Robin Egg Blue Sumac Red Blue Green Gray Ivory Goldenrod Plasma Pink Pink Lavender Lemon Drop Spring Green Violet Manilla Dark Green Red Yellow Dusk Pink Evergreen Ocean Blue Cherry Hunters Orange Dark Blue Orange White / Ivory
I'm struggling with this as well. I tried creating a .txt file of sequential numbers 1-99 from Excel and brought it in as a datamerge. My tickets are 8"x3", 3-up, but when I did the merge, InDesign added 3,416 pages. Where the Hell is THAT coming from?? Any clue what I'm doing wrong? I'm using a tutorial that is using CS5, but I don't see how that has anything to do with all those bloody pages.
More often it’s used to play on an association with high technology, and doesn’t literally indicate a ‘version’ (e.g., Tron 2.0, a video game followup to the film Tron, or the television series The IT Crowd, which refers to the second season as Version 2.0). A particularly notable usage is Web 2.0, referring to websites from the early 2000s that emphasized user-generated content, usability and interoperability.
Word templates are wonderful things. Microsoft, and hundreds of other people, have created some great free templates for almost everything. With these free templates you can make meeting agendas The 15 Best Meeting Agenda Templates for Microsoft Word The 15 Best Meeting Agenda Templates for Microsoft Word These meeting agenda templates for Microsoft Word can get you off to a great start for any type of meeting. Read More , beautiful flowcharts How to Create Stunning Flowcharts With Microsoft Word How to Create Stunning Flowcharts With Microsoft Word Used with imagination, flowcharts can simplify both your work or life. Why not try out a few flowcharts with one of the easiest tools on hand – Microsoft Word. Read More , professional resumes How to Create a Resume Template with Microsoft Word How to Create a Resume Template with Microsoft Word Your resume could be the difference between interviewing for the job of your dreams or never hearing back from the employer — use these tips to make sure it's the best it can be. Read More , and custom calendars 10+ Sites to Find the Perfect Free Printable Calendar Template All Year Long 10+ Sites to Find the Perfect Free Printable Calendar Template All Year Long You can never have enough reminders that your most valuable personal resource is limited. Our selection of printable weekly, monthly, and yearly calendars will help you manage your time wisely. Read More in minutes. A custom calendar might be a good fundraiser, too!

I also use InDesign. An Excel file for numbering is easy to create. Then find DataMerge under Automate to link the data file. When you are ready to export, use the create PDF right on the Datamerge window. You can print as cut / stack on the Fiery (or CREO). REMEMBER - if your customer wants them stapled into books of 6 (for example) each stack has to be divisible by 6 if you are going to staple then cut into individual books.
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.
As far as threading the frames, is it that you don't understand threading? You accomplish that by using the selection tool to click in the outport box (the larger square near the lower right corner of the text frame), then clicking inside the frame you want to be next in the thread. Repeat as often as required, selecting the outport of the last frame you threaded each time. Text will now flow automatically from the first frame to the end of the thread. You can work backwards, too, if you wish, by selecting the inport (upper left) instead of the outport.
The next step is to create the simple Excel workbook that contains the ticket numbers. Open a blank Excel sheet. Using Figure B as a guide, create the ticket numbering sheet and save it, making sure to note the new workbook's name and location. As we discussed earlier, the Excel workbook stores the ticket numbers. In this example, we'll create 11 tickets numbered 100 through 110. You'll need to update the ticket values for each merge.

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.
I know that PrintShopMail will do it, but I was wandering if there was a less expensive solution out there so that I could get numbered tickets (usually 4-up) right off the Xerox. I just want to avoid having to go the the Windmill after trimming and doing it the old fashion way. There is a tiny little copy shop here in town that is doing it, and am willing to bet that they are not using PrintShopMail, but I'm also not going to ask them to share their methods with a competitor. There has to be cheaper solution. I know that I can do it with auto page numbering in Indesign, but that means I can only print raffle tickets 1-up which wont work.
An awesome new feature to has been introduced to Microsoft Publisher 2010 is the ability to use Data Sources to create "Catalogue Pages". This is like a Mail Merge for design documents. Now, I would have to agree that Publisher isn't the best graphic design program in the market. But it's certainly adequate for simple ticket designs — for example, for a school social. Let's say we want each ticket to have a unique number and an inspiration quote. This is all possible through Publisher and a data source, e.g. an Excel Spreadsheet.
Remember that you must update the values in the sheet if you want to continue the numbering series with the next batch of tickets. For instance, if you want your next batch of tickets to start with 112, you'd open the workbook and change the value 100 to 112, and update the remaining values accordingly. Don't forget to save the workbook after updating the values.

Given that Word can support 2,147,483,647 SEQ fields, the whole job could be done in a single document containing 30,000 tickets. On my system, creating such a document took only a few minutes and, once created took about two minutes to update the fields - and that was with about 40,000 pairs of SEQ fields coded as {SEQ Ticket \# 00000} and {SEQ Ticket \c \# 00000}. This number formatting is enough to go to 99,999 tickets.

    Numbering raffle tickets can be a rough project to tackle without the right tools. Luckily you can number raffle tickets or any other document or form with a desktop publishing software program you may already own like Microsoft Word, Publisher, Adobe Indesign or CorelDraw or any desktop publishing software that has a mail merge function.  Then all that is needed is a program that can create the mail merge file you need to number your tickets like starting number, ending number, prefix and so on. And for that program we suggest Number-Pro.
×