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?
automatic sequential ticket numbering
-
- 5StarLounger
- Posts: 889
- Joined: 25 Jan 2010, 16:26
- Location: Garden Grove, CA 92844 USA
automatic sequential ticket numbering
You do not have the required permissions to view the files attached to this post.
Don
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: automatic sequential ticket numbering
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
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.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- Microsoft MVP
- Posts: 1318
- Joined: 24 May 2013, 15:33
- Location: Warminster, PA
Re: automatic sequential ticket numbering
For an exhaustive (!) treatment of the topic and an add-in, read http://www.gmayor.com/Numbered_labels.htm.
-
- 5StarLounger
- Posts: 889
- Joined: 25 Jan 2010, 16:26
- Location: Garden Grove, CA 92844 USA