Printing Problems

How to Create Sequentially Numbered Tickets on Avery Cards in Word

Camila MilosovichCamila Milosovich Nov 3, 2026 870 views

Question details

The user needs to print uniquely numbered tickets on Avery Clean Edge Business Card stock using Microsoft Word.

How to Create Sequentially Numbered Tickets on Avery Business Cards in Word
Product
Word
Device & OS
not provided
Scenario
Designing layouts with ten tickets per sheet and numbering them sequentially (e.g., 1500 through 2000) for event ticketing or raffles.
Observed behavior
Requires a method to automatically generate and arrange sequential numbers on specific Avery card layouts without manual typing.
Before you start

Create a spreadsheet in Excel containing a single column with your desired sequential numbers (e.g., 1500 to 2000) and save it. Also, locate the exact product number on your Avery business card packaging.

Solution 1Recommended

Use Label-Style Mail Merge

Utilizing the Mail Merge feature with a label layout allows you to automatically populate sequential numbers across Avery card templates.

Mail Merge is the most efficient way to generate sequential numbers across multiple labels or cards. By linking Word to an Excel spreadsheet, you can automatically distribute unique numbers to each ticket on the sheet without manually typing each one.

1
Start a Label Mail Merge

Open a blank Word document, navigate to the 'Mailings' tab, click 'Start Mail Merge', and select 'Labels'. Choose 'Avery US Letter' as the vendor and select your specific business card product number.

2
Connect the Data Source

Click 'Select Recipients', choose 'Use an Existing List', and browse for the Excel spreadsheet containing your sequential numbers to link it to the document.

3
Insert Merge Fields

Place your cursor in the first ticket layout. Click 'Insert Merge Field' and select the column header representing your numbers. You can also format the font and add static text like 'Ticket No.'.

4
Update All Labels

Once the first ticket is fully designed, click 'Update Labels' in the Mailings tab. This copies your design and the essential 'Next Record' rule to all other tickets on the sheet.

5
Complete the Merge

Click 'Finish & Merge' and select 'Edit Individual Documents' to generate a new document containing all your sequentially numbered tickets ready for printing.

Use Label-Style Mail Merge
Ticket Assembly: If you are assembling ticket books, standard mail merge numbers them horizontally across the sheet. You may need to manually stack and cut the sheets, or restructure your Excel data to print vertically for easier sorting.
Efficiently create numbered tickets

Create Numbered Tickets Effortlessly with WPS Writer

WPS Office provides a highly compatible Mail Merge feature that makes creating sequentially numbered tickets on Avery card stock fast and straightforward.

  1. 1. Prepare Data: Open WPS Spreadsheets, create a single-column list of your sequential numbers, and save the file.
  2. 2. Select Avery Layout: Open WPS Writer, go to the 'Mailings' tab, click 'Mail Merge', then select 'Labels' to find your specific Avery card layout.
  3. 3. Link and Merge: Click 'Open Data Source' to import your spreadsheet, insert the number field onto the first card, click 'Update Labels', and select 'Merge to New Document'.
Fully compatible with Microsoft Word (.docx) and Excel (.xlsx) formatsIntuitive Mail Merge wizard for labels, envelopes, and ticketsFree, lightweight, and easy to navigate for professional document creation
microsoft office alternative - wps office

Frequently Asked Questions

How do I quickly generate sequential numbers for my data source?

Open Excel or WPS Spreadsheets, type the first two numbers of your sequence (e.g., 1500 and 1501) in adjacent vertical cells. Highlight both cells, then click and drag the small fill handle at the bottom right corner of the selection down to automatically populate the rest of the numbers.

Why is the same number repeating on all my tickets?

This happens if the 'Next Record' rule is missing. Ensure you click 'Update Labels' on the Mailings tab after designing your first ticket. This command tells the software to pull the next number from your spreadsheet for each subsequent card rather than duplicating the first record.

Can I add static text around the sequential numbers on the tickets?

Yes. On your first label, you can type any static text (like 'Raffle Ticket No.' or event details) around the merge field. When you click 'Update Labels', that static text and the ticket design will be automatically copied to all other tickets on the page alongside the dynamic numbers.