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.
You’ll need to decide on a selling price. You don’t want to price them too high so that many people would find it too expensive. The lower the price of each ticket, the more tickets you’ll sell. If you price your tickets at $1 each, expect each buyer to purchase from one to five tickets. If your tickets are $5-10 each, each buyer will likely purchase no more that two.
Regarding our full color items that we print: Please note due to the nature of our color printing process (CMYK), we cannot print every color available. Please note also that the color image that you view on your monitor is produced in a mode called RGB. All images we receive are automatically converted to the CMYK mode which may cause a shift in color. In addition, the same RGB color will show up differently from one computer monitor to another because of calibration differences between computer monitors. As such, we will not be responsible for any shift in any color printing and will not reprint any order that we feel is within our printing capability! Our prices are highly discounted because variations may occur. The color printing we produce is visually pleasing, but does not attempt to match exact color.
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.