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.
In traditional spreadsheets, the semantic value of the numbers is lost. The number in cell B2 is not “the number of cars sold in the month of January”, but simply “the value in cell B2”. The formula for calculating the average is based on the manipulation of the cells, in the form =C2/B2. As the spreadsheet is unaware of the user’s desire for D to be an output column, the user copies that formula into all of the cells in D. However, as the formula refers to data on different rows, it must be modified as it is copied into the cells in D, changing it to refer to the correct row. For instance, the formula in D4 would read =C4/B4. Excel automates this later task by using a relative referencing system that works as long as the cells retain their location relative to the formula. However, this system requires Excel to track any changes to the layout of the sheet and adjust the formulas, a process that is far from foolproof.
You’re selling raffle tickets to make money, so why buy the tickets pre-printed? Using Microsoft Word’s mail merge function, you can create your own raffle tickets and design them any way you please. A mail merge doesn’t have to make mail; it is simply a way to define certainly elements of a document, then automatically insert variable elements, such as raffle ticket numbers. The most important thing to remember is that each ticket needs a mate–you don’t want to pull winning ticket number 81018 only to find that no one bought that one.
To use mail merge to create a batch of gift certificates or coupons with tracking numbers, you need to set up a data source that contains a column listing the tracking numbers. If you plan to add only the tracking numbers to your publications, create a data source for the tracking numbers. If you also plan to use mail merge to insert additional information into your publications, such as customer names or addresses, you can add the column of tracking numbers to a data source that also lists the name and address data that you want to use.
Raffle Ticket is an extremely easy-to-use program which allows you to print and number tickets in just minutes, right from your own PC and desktop printer. This program makes 8 tickets per 8-1/2" x 11" page and each ticket will have a unique number on the body with a matching number on the stub. You can quickly add photos or clipart, and you can select from a huge variety of fonts, colors and sizes for your text. A live preview automatically appears in the background as you create your ticket in the design window. What could be easier? This easy to use software for Windows XP/Vista/7 guides you through the whole ticket making process in just minutes. Handy reminders help you fill in the ticket body without leaving out any important information. The live preview shows you text and image changes as you make them. The Stub Design tab sets up the stub for optimal writing space. The Number Specification tab walks you through placing matching numbers on the stub and body for extra security in your drawings.
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.
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.