Word Special Formatting Needed for sequentially numbered tickets on Avery Business Card stock.

Anonymous
2022-03-01T02:35:16+00:00

I need some GUIDENCE with a project I’m trying to do, using “Microsoft Word 2016”.

My project requires printing on “Avery Clean Edge Business Card” stock.

I have prepared the document, designed to fit the format of 10-Card “Avery Clean Edge Business Card” stock.

The finished product will be used like tickets for an event.

What I need help with:

Since the cards are to be used like tickets, I need to be able to print each card with its own unique individual number in ascending order. For Example, #1500 to #2000

PROBLEM HERE IS: I don’t know how to get this done.

Any help is appreciated.

Respectfully

Sunlover 207802

Microsoft 365 and Office | Word | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

13 answers

Sort by: Most helpful
  1. Anonymous
    2022-03-01T14:14:06+00:00

    The methods recommended by Doug and Suzanne are far simpler for you to use. However, they will result in the tickets being numbered sequentially on each sheet so the first sheet, for instance, would have the numbers from 1501 to 1510 and so on. If you are trying to have sequentially numbered books of tickets to give to people to sell, you will need to separate the pages and stack by hand.

    The method that I give is more complex but will result it the tickets in each position on the page being sequentially numbered so that the top-right ticket will be 1501 on page 1 and 1502 on page 2, 1503 on page 4, etc. This makes it much easier to produce a ticket book once you've printed them. I assumed you wanted books, perhaps mistakenly.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments No comments
  2. Doug Robbins - MVP - Office Apps and Services 323.3K Reputation points MVP Volunteer Moderator
    2022-03-01T08:58:54+00:00

    Use a label type mail merge with a data source that contains a column of the numbers that you want to appear on the tickets and insert a mergefield in the appropriate place

    See the article “Mail Merge with Word 2007/2013” on fellow MVP Graham Mayor’s website at

    http://www.gmayor.com/merge\_labels\_with\_word\_2007.htm

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments No comments
  3. Doug Robbins - MVP - Office Apps and Services 323.3K Reputation points MVP Volunteer Moderator
    2022-03-08T22:57:46+00:00

    If you send me a copy of the mail merge main document and the data source that you are using, referencing this thread in the covering email message, I will help you.

    Do you want the tickets numbered as shown below

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  4. Doug Robbins - MVP - Office Apps and Services 323.3K Reputation points MVP Volunteer Moderator
    2022-03-01T23:34:45+00:00

    Easier to delete all but the first cell of the label table, change to two columns per sheet with no space between them and change the mail merge main document to a directory type.

    That will give labels numbered as:

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  5. Anonymous
    2022-03-01T05:35:27+00:00

    The question I answered originally had six tickets per page. You have ten so you would want to adjust the numbering accordingly.
    You want 500 tickets (10 per page).
    500/10 = 50 pages = space between numbers on each page

    So, you need to separate your sequences with 50 instead of 34 in on the answer.

    Use a page of labels with ten SEQ fields set for different sequences and with an interval of 50. The first page would be your initial set of fields with numbering 1501, 1551, 1601, 1651, 1701, 1751, 1801, 1851, 1901, and 1951,

    The first field would be { SEQ Ticket1 /r 1501/# "0000" }.   
    The second would be { SEQ Ticket2 /r 1551 /# "0000" } and so forth.   
    Each ticket on the page uses a different sequence label.   
    

    Once you have the base page set, copy and paste it to make the second page. In the second page, you remove the /r switch with the number leaving just /# 0000.
    Then you copy and paste from the revised Page 2 until you have a total of 50 pages with the last 49 being the same.
    Finally, Ctrl+A to select all and press F9 to update the field.
    If Field code are still showing, press Alt+F9 to toggle display of field codes.

    Print your tickets.

    When you cut or separate them, they should be neatly organized into sequential numbers.

    If you need more than 500, increase the number of pages and the starting separation between each of the ten sequences.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments