View Single Post
 
Old 07-02-2019, 12:44 PM
Moonshine Moonshine is offline Windows 10 Office 2016
______________
 
Join Date: Apr 2018
Posts: 302
Moonshine is just really niceMoonshine is just really niceMoonshine is just really niceMoonshine is just really nice
Default

For me, the easiest way to achieve what you want is to use a two-stage process involving Excel along with Publisher.
First create a simple Excel Workbook that contains the ticket numbers 1 – 220 in this instance.
To do this, open Excel and in Column A/Row 1, input 1.
Input 2 in Column A, Row 2.
Highlight column A Rows 1 & 2 and when you see a small black square, drag it down to your chosen amount (220) to automatically populate the cells.
Save the Workbook with an appropriate name in a location of your choice. Folks often use a folder call My Data Sources in the Documents folder.

In Publisher, create/resize one page with the correct dimensions for your ticket.
In the Page Setup, check the page margins and adjust as required for your chosen amount of tickets per page. The preview should guide you.
Make sure the Layout type is set to Multiple pages per sheet.
Add content including a space for a number(s).

Now the numbering part:
Click the Mailings tab, then Select Recipients.
Opt to Use an existing list.
Navigate to new Excel 1 - 220 list and once located, D/click.
Uncheck First row of data contains column headers > OK.
Click OK to Mail Merge Recipients.
Now click the Insert Merge Field tab, then the F1Merge Field option.
Click the inserted F1 Merge Field and resize/change colour/font size etc, then position as required.
An easy way to copy an object (F1 Mail merge Field) is to press the Ctrl key, then click the perimeter and when you see a small plus / + sign, drag the ‘copied’ object to a position if required.
My, 10 tickets per sheet, example below uses two sets of numbers to identify it (2 part raffle ticket).

Now click the Preview Results tab to see actual numbering, then use the Left/Right arrow tabs to see additional numbers of ‘ticket numbers’.
Now click the Finish & Merge tab and opt to Merge to Printer.

The Print Preview will open where you can zoom in to see results.
The numbering is likely to be all the same – not what we want, so click the Multiple copies per sheet entry and change it to Multiple pages per sheet.
This will change the numbering for each ticket in a sequential manner as required.

Print when ready.
Click the image below to see a short video of how I have first created the Excel data file, then in Publisher see how I have used it to number the tickets.

Reply With Quote