There is very simple solution that we use and that is to lay out the sheet say 6 up on a A4 sheet as a master page and in document setup set the number of pages to 1,000 if that is the amount you require. Put a page number on each ticket on the page and although they will all have the same number on each page, we put the the first two letters of the customers business name before each number followed by the letters of the alphabet so it then reads for example BT1A, BT2A, BT3A, BT1B, BT2B, BT2C and so on as each page is printed.
I had wanted to create a file that didn't require Excel as the data source, so I created one using SEQ fields. It was terrible and too huge to mention (thanks Doug Robbins), so I recreated it using Word as the data source so that people who only have Word can use it. You can create up to 5,000 tickets without changing the data file. If you only have Word and need to create more than 5,000 tickets, please don't type the ticket numbers. Just drop me an email and I'll create another data file for you with the required numbers.
I think the conclusion of all these Rube Goldberg approaches is that InDesign still isn’t ready for handling what is really a head-smacking-stupid-simple kind of numbering job — the kind of jobs computers were created for in the first place. My DOS word processor XyWrite — from AD 1987! — could do numbering stuff like this in no time and with no trouble. Quite ridiculous, really, when you consider the staggering graphics and typography capabilities inside InDesign — but the poor thing cannot really count.
You probably know about Word's mail merge feature, and you might even use it to print labels or other documents, where some of the information changes (such as form letters). You can use the same feature with Publisher. Although you might not think of Publisher as an Office app, it comes with several different versions of Office. In this article, I'll show you how to print sequentially numbered tickets using Publisher and Excel. This article provides instructions for Publisher 2007, 2010, and 2013.