![]() Click Close to return to the ticket document (not necessary in 20).Publisher will generate enough pages to accommodate your entire list of values in Excel. (Publisher 20 does this automatically.) The ticket numbers should increase by one ( Figure K) as they do in the Excel sheet. Click Print Preview to check the settings. ![]() If you want to print multiple tickets on one sheet, click the Multiple pages per sheet option ( Figure J). If the ticket is a single page, accept the default setting of 1 sheet.In Publisher 20, choose Print from the File tab. I recommend that you preview the print job before sending it to the printer to make sure everything’s in order. Choose the Step by Step Mail Merge Wizard from the Mail Merge drop-down.Īt this point, you’re ready to load your card stock into the printer and print the tickets. After identifying the value source, you’re ready to merge.Repeat steps 3, 4, and 5 from the 2007 instructions above.Then, choose Use Existing List from the Select Recipients option in the Start group. The process is the same in 20, but you’ll be using the ribbon: Click any of the page numbers at the bottom of the screen to see the ticket numbers change. Publisher will replace the > field with the values in the Excel sheet ( Figure I).Merging is flexible enough to work with existing merge documents, but we need a new one. For this merge, click the Merge to a new publication link ( Figure H).Click the Next: Create merged publications link at the bottom of the pane.After dropping the field control, I pressed to replace Microsoft with the > field. Drag the Ticket Numbers field from the merge pane to the document ( Figure G). In this case, it’s the Ticket Numbers field in the selected Excel workbook. Now, you’ll define the actual merge values.When applying this method to your own work, remember that you can exclude recipients at this point. We want all the numbers ( Figure F), so don’t uncheck anything before clicking OK. In the Mail Merge Recipients dialog, you have the opportunity to customize the list.In this case, that’s Sheet1 ( Figure E), the default. In the Select Table dialog, select the sheet that contains the values you want to merge.Double-click it, or select it and click Open. Using the Select Data Source dialog, locate the Excel file.In this case, the recipient list is the list of values in Excel. Near the bottom of the pane, click the Next: Create or connect to a recipient list link.From the Publisher 2007 Tools menu, choose Mailings and Catalogs ( Figure C).Return to the Publisher event ticket document and do the following: ![]() With the two pieces in place, you’re ready to run the merge that generates the sequential numbered tickets. You’ll need to update the ticket values for each merge.įigure B Enter tickets numbers into an Excel sheet. ![]() In this example, we’ll create 11 tickets numbered 100 through 110. As we discussed earlier, the Excel workbook stores the ticket numbers. 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. The next step is to create the simple Excel workbook that contains the ticket numbers. Double-click one of the ticket templates ( Figure A).Īt this point, you’d start customizing the template’s content, but we’ll work with the template as-is.In Publisher, choose New from the File menu.Now, let’s create the Publisher document, or ticket, using a Publisher ticket template to simplify the example: Merging a Publisher document to generate sequential numbers is easy. Please don’t let the term mail merge intimidate you. 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. The Publisher document is a template, but you can download the Excel. This article provides instructions for Publisher 2007, 2010, and 2013. In this article, I’ll show you how to print sequentially numbered tickets using Publisher and Excel. Although you might not think of Publisher as an Office app, it comes with several different versions of Office. You can use the same feature with Publisher. 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).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |