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. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |