MORE ABOUT OUR EVENT TICKETS Browse the widest selection of ticket designs anywhere on the web. Choose from over 1,300 template designs for all types of events and fundraisers. Ticket Creator Template• 1.97' x 5.63' with 1.875' perforated stub and barcode • Printed on durable 100lb ticket stock with smooth brilliant finish • Advanced security options include hologram, glossmarks, and UV or heat-sensitive media • Optional CSV upload for reserved seating events • Budget black & white and full color ticket designs available • One business day processing on most orders • Unbeatable prices starting at $0.02 per ticket. You probably know about Word's mail merge feature, and you might even use it to print labels or other documents, where some of the information changes (such as form letters). You can use the same feature with Publisher. Although you might not think of Publisher as an Office app, it comes with several different versions of Office. In this article, I'll show you how to print sequentially numbered tickets using Publisher and Excel. This article provides instructions for Publisher 2007, 2010, and 2013. The Publisher document is a template, but you can download the Excel example file. Create the ticket in Publisher You'll need to merge two documents: the Publisher document, or ticket, and an Excel workbook that contains the numbers you want to use to number those tickets. Ticket Creator 5.8 Serial Numbers. Convert Ticket Creator 5.8 trail version to full software. Please don't let the term mail merge intimidate you. Merging a Publisher document to generate sequential numbers is easy. Now, let's create the Publisher document, or ticket, using a Publisher ticket template to simplify the example: • In Publisher, choose New from the File menu. • In the Search control, enter tickets. • Double-click one of the ticket templates ( Figure A). Figure A • Save the file. At this point, you'd start customizing the template's content, but we'll work with the template as-is. Create the ticket numbers in Excel 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. Enter tickets numbers into an Excel sheet. Merge the numbers with the tickets With the two pieces in place, you're ready to run the merge that generates the sequential numbered tickets. Return to the Publisher event ticket document and do the following: • From the Publisher 2007 Tools menu, choose Mailings and Catalogs ( Figure C). Figure C • Next, choose Mail Merge ( Figure D). Figure D • Near the bottom of the pane, click the Next: Create or connect to a recipient list link. In this case, the recipient list is the list of values in Excel. • Using the Select Data Source dialog, locate the Excel file. ![]() Ticket Creator FreeDouble-click it, or select it and click Open. • In the Select Table dialog, select the sheet that contains the values you want to merge. In this case, that's Sheet1 ( Figure E), the default. Figure E • In the Mail Merge Recipients dialog, you have the opportunity to customize the list. We want all the numbers ( Figure F), so don't uncheck anything before clicking OK. When applying this method to your own work, remember that you can exclude recipients at this point. Figure F • Now, you'll define the actual merge values. Printable Ticket CreatorIn this case, it's the Ticket Numbers field in the selected Excel workbook. Drag the Ticket Numbers field from the merge pane to the document ( Figure G). After dropping the field control, I pressed [Enter] to replace Microsoft with the > field. Figure G • Click the Next: Create merged publications link at the bottom of the pane. • For this merge, click the Merge to a new publication link ( Figure H). Merging is flexible enough to work with existing merge documents, but we need a new one. Figure H • Publisher will replace the > field with the values in the Excel sheet ( Figure I). Click any of the page numbers at the bottom of the screen to see the ticket numbers change. Figure I The process is the same in 2010 and 2013, but you'll be using the ribbon: • Click the Mailing tab. Then, choose Use Existing List from the Select Recipients option in the Start group. • Repeat steps 3, 4, and 5 from the 2007 instructions above. • After identifying the value source, you're ready to merge. Choose the Step by Step Mail Merge Wizard from the Mail Merge drop-down. • Repeat steps 6, 7, and 8 above. Print the numbered tickets At this point, you're ready to load your card stock into the printer and print the tickets. I recommend that you preview the print job before sending it to the printer to make sure everything's in order.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
November 2018
Categories |