5/16/2023 0 Comments Numbered tickets swift publisherPublisher 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. |