To design a certificate from scratch, you can either start with a completely blank publication or adapt an existing publication. Small-sized publication types, such as business cards, postcards, and labels can be adapted to serve as coupons. Flyers or brochures can be adapted for use as gift certificates. For more information, see Create a publication in Publisher.
Subsequently you have to select the template named Raffle tickets 6 per page. Microsoft Word will make available a preview of the chosen template and then inquires whether you wish to download the particular template. Now choose the option to download. Consequently your current word document gets replaced with the template of raffle ticket which is ready to undergo editing in your hand.
Number-Pro makes numbering raffle tickets and forms easy using your desktop publishing software like Indesign, Microsoft Word and Publisher and Corel Draw. Number Pro creates a data merge file based on your numbering requirements that can easily be integrated into the desktop publishing software that allows for printing directly to your small business or home printer.
Gift certificates and promotional coupons can play an important role in your marketing strategy by drawing new and repeat customers to your business. However, how can you tell if they are really working to help you develop your business? To make the most of your time and your marketing budget, you need to track the success of your marketing efforts so that you can determine what marketing tactics are effective for which customers.
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 email@example.com.
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.
One of the most profitable products a small print shop can produce is Raffle Tickets. But the trouble is most small to medium sized print shops either don't have a numbering unit or it is not setup to number multiple documents on a single sheet of paper. Most print shops do however have a laserjet or multi purpose printer. Combine that with some graphic software like Publisher and and easy to use numbering software program and you can capture the raffle ticket business and not let it slip away from you.
Our raffle ticket templates have a placeholder for a ticket number, usually “xxx” to remind you it needs to be replaced. Select it, click Insert Merge Field > Ticket. Do the same for the second ticket number placeholder. Most tickets will have two number placeholders because one part of the ticket is for the raffle host (you) and the other is for the purchaser.
data merge can be a little tricky for this. Try making a single ticket at the top of your page (not on the master page). Put your merge fields into this ticket. Then when using data merge click the option to put more then one per a page, preview and see if this does what you want it to do. Granted if you have double sided printing, data merge gets very tricky, but can be done.
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 using your instructions to create a page of tickets - the design has been created as a picture so I added a text box to "hold" the mail merge instructions but I keep getting the error message "You cannot include DATA, NEXT, NEXTIF, or SKIPIF fields in comments, headers, footers, footnotes or endnotes." I have not included any of these but I'm wondering if it's because I've attempted to insert it in a text box. Is there an easy way to do this? TIA