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.