Use Microsoft Word and Microsoft Excel together to print raffle tickets. Whereas Excel handles the ticket numbers, Word handles the ticket design and the final print order. Hloom offers free ticket design templates.Continue Reading
You must first create a small database that contains the ticket numbers. To do so, enter a random number in the cell A2, select the cell, and then drag down the box on the bottom right of the cell. Cover as many cells as you have tickets. For instance, you should drag down to A41 to have enough numbers for 40 tickets. Select the cells, and Fill Series under Auto-Fill Options to have Excel make the numbers sequential. Save the file.
Download a raffle ticket design from Hloom, and change the design as you see fit. Once done, open the Mailing tab, click Start Mail Merge, choose Labels from the list, and click cancel. Then click Select Recipients, choose Use Existing list, and open the Excel file that contains the ticket numbers. Select the ticket number place holder on the ticket design, click Insert Merge Field, choose the Excel file, and click Update Labels.
With both the design and the database ready, click the P key while holding down CTRL to start printing. Alternatively, you can open the File tab, and then click Print. You can see a preview of the tickets on the right side of the Print screen.Learn more about Software