automatic sequential ticket numbering

dasadler
5StarLounger
Posts: 889
Joined: 25 Jan 2010, 16:26
Location: Garden Grove, CA 92844 USA

automatic sequential ticket numbering

Post by dasadler »

I need to print some tickets for an alumni event and I am wondering the what is the best way to do it. I have Office 2007 and can easily make ticket templates in any of the applications however I need to have automatic sequential numbering appear on each ticket. In fact, the same number needs to print twice on the ticket - the main ticket and the ticket stub. There will be several hundred tickets.

The ticket template will be something similar to one of the images below:

Any suggestions for the best approach?
507050-wht.jpg
8121cf5d-9cab-46ef-a2ab-4cad37f08e17_1.86e1f309ede02baf6875c2675fb3efb2.jpeg
You do not have the required permissions to view the files attached to this post.
Don

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: automatic sequential ticket numbering

Post by Rudi »

Others might suggest other options, but from my perspective, you can use the mail merge feature in Word.

If you set up the list in Excel (the source info to merge to the labels), doing a simple mail merge should produce the results you need. In the Excel list, you can have two sequential number columns, one column for the ticket and a second identical column for the ticket stub. The other columns will contain the name, surname and other details for the ticket.

In Word, simply set up a label page with the ticket design, and then you can add the fields into the first label and once you have the first label designed, just click the "Update Label" button.

Complete the mail merge as required.

- See here for a web tutorial step by step.

See here for a 4 step video tutorial:
- Word 2007 Label Mail Merge Demo Part 1
- Word 2007 Label Mail Merge Demo Part 2
- Word 2007 Label Mail Merge Demo Part 3
- Word 2007 Label Mail Merge Demo Part 4
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.

User avatar
Jay Freedman
Microsoft MVP
Posts: 1312
Joined: 24 May 2013, 15:33
Location: Warminster, PA

Re: automatic sequential ticket numbering

Post by Jay Freedman »

For an exhaustive (!) treatment of the topic and an add-in, read http://www.gmayor.com/Numbered_labels.htm.

dasadler
5StarLounger
Posts: 889
Joined: 25 Jan 2010, 16:26
Location: Garden Grove, CA 92844 USA

Re: automatic sequential ticket numbering

Post by dasadler »

Thank you both for such good and helpful information.
Don