i’ve had to do tons of this lately and found that for the amounts of tickets being done (e.g. 7000 x 10 tickets + cover & mailer) that chuckT’s solution almost 2 years ago is similar to what i use. would be interested to know if others doing similar VDP are using a wholly indesign/excel solution, or if specific VDP software such as XMPie are being used.
Starting an auto-numbered paragraph is deceptively simple. See those buttons on the top row of the Paragraph section of the Home tab? The left-most one is for bullets; the next two to its right are for numbering and multi-level numbering, respectively. Simply click the button to toggle the feature on, or click on the drop-down arrow on each button to select a specific style. If you don’t like any of the delivered choices, you can click Define New to set your own.

So now on the A master page in your Adobe InDesign document you should have a capital A in the text frame that we created. This is more than just a capital A though, this represents the A master in your Adobe Indesign document and it means that on every page that is attached to your A master the corresponding page number will appear in that position on your page.
First thing we need to do, is we need to jump to page 1. So double click page 1, so we know we're on it. Right click page no.1, and we need to go to this option that says 'Numbering & Section Options'. Click on him. And what we do is, we say, I want to switch it from style 1, 2, 3 to A, B, C. Actually you pick any of these in here. It's really typical to use A, B, C, but you can use any of these other numbers, just click 'OK'. You'll notice that A, B, C, D, E is being replaced out. Now what we want to do is go to our first page that we want. In our case it's E. So I don't want this. Let's get rid of our Spreads. I don't want page 1, page C, or B. I don't want this to be page1, I want this to be page 1. So I'm going to double click page E. Right click it, go to 'Numbering & Sectioning'. And just say, I'd like to start at page no. 1 using this format. Click 'OK'. What will happen is, you can see, page 1 starts here, 2, 3, 4. You see, the numbering starts here as well. All the way through, to the end of our document.
If you want to use a bullet found in a specific font (such as the pointing hand from Dingbats), be sure to set the bullet to remember that font. If you use a basic bullet character, it’s probably best not to remember the font, because most fonts have their own version of that bullet character. Depending on whether you select the Remember Font With Bullet option, a bullet you add can reference either a Unicode value and a specific font family and style, or just a Unicode value.
My quick process involves setting up a row of plaques with a01, a02, a03, thru a09. Then copy the plaques to the clipboard. Run the REPLACE TEXT feature to replace "a" with "1". Move row down and paste clipboard back into page. Run REPLACE TEXT to replace "a" with "2". Repeat until I get all the numbers. It's faster than manually typing the numbers in but I know there's go to be someway of automating the process.
This is ideal if use certain tools with the same settings every time. SignTools Quick Palette Complete list of tools Shades & Decorations - SignTools 4 contains 13 quick and easy to use shades and decorations. Included are Outline, Relief Outline, Outline & Shade, Relief Outline & Shade, Drop Shade, Relief Drop Shade, Relief Effect, Inline, Cast Shade, Relief Cast Shade, Highlight, Emboss and Highlight & Sink.
Place the insertion point in the paragraph and choose Restart Numbering from the context menu or choose Type > Bulleted And Numbered Lists > Restart Numbering. In normal lists, this command assigns the number 1 (or letter A) to a paragraph and makes it the first paragraph in a list. In multi-level lists, this command assigns the first lower-level number to a nested paragraph.

Thank you for your reply.  It reassured me that I was on the right path. From having read other Help texts, I guessed that I would have to use good ole mail-merge and set up a numbers list in Excel. Luckily my knowledge of Excel was good enough to know about the drag&drop for sequential immediate numbering. When it came to the crunch, it was this particular type of mail merge which gave me a bit of initial difficulty. Despite my having used it happily and often in Word, for labels in Publisher, it was - not surprisingly - different in certain respects; principally the crucial point of the Print stage, which necessitated finding the option Publications & Paper Settings, and selecting 2 specific parameters, namely (1) Multiple pages per sheet,  (2) Single-sided printing (my default double printing had appeared). Once I'd sussed this, it was plain sailing.  Thanks again.


The steps in this article are going to show you how to add page numbers to the pages of your Publisher document. The page number will appear on every page of your document, at the location that you choose. Note that page numbers will also be included on any new pages that you add after inserting the page numbers, and they will update automatically if you delete any of the existing pages from the document.
In this situation I would suggest using an Alternate Layout. Once the content is final, choose Create Alternate Layout from the Pages panel menu. Make sure to create the new layout the same size and orientation as the original and then use the Numbering and Section Options dialog to specify the numbering required for the second catalog. The Print dialog will then let you select which layout to print.
All of this happens in the Bullets & Numbering dialog box, shown below. You will definitely want to use paragraph styles for this. My first one is called Chapter title. You will need to begin by changing the List Type to Numbers for all of the levels, and you must both name the List and use the same named list for all Levels. You do this by selecting the List > New List.

You can control whether your next paragraph number continues the current sequence or starts again at 1 within that same right-click menu. If one of your numbers gets out of sequence, simply right-click and choose Continue Numbering. If you want to force the number back to the beginning (say, you’re switching from interrogatories to requests for production), choose Set Numbering Value (which will also give you the option of continuing the previous list).

You can exclude the first page(s) from numbering. This may be needed if page 1 follows after pages that have no numbers, or have individual numbering as the table of contents in large books. To show number 1 on page 2, double-click on its page number field and set First page to 2. Note that to have the correct page numbers on the following pages, you need either place the page number field on a master page, or set the same First page value on all pages.
When you are ready to restart numbering, you can use the technique above, or you can place your cursor inside a numbered paragraph above, click the Format Painter (the paintbrush icon on the Home tab under Clipboard), then click on the line where you want to restart numbering. Using Format Painter this way solves several paragraph numbering problems (the number sequence, indents, and inter-paragraph spacing) simultaneously.
The creator of ShaunaKelly.com, Shauna Kelly, passed away peacefully on Wednesday November 16, 2011 after a long battle with ovarian cancer. If you are requesting permission to re-use any information on this site, then you may do so with appropriate acknowledgement of her work. If her words, thoughts or pictures have helped you, or made money for you, then please consider making a donation in her name to the Women's Cancer Foundation.
So I spent some time trying to figure it out, playing with Normal.dotm and the various styles (List paragraph, List Number, List Bullet etc etc). And finally, when I've got Normal.dotm open (i.e. I'm editing that template file), I get my result: I apply a standard numbered list, and it comes up flush left (i.e. not indented) and hanging at 1.0cm (cos I don't use inches...) and with a tab stop applied at 1.0cm as well - funky stuff!
Remember that you must update the values in the sheet if you want to continue the numbering series with the next batch of tickets. For instance, if you want your next batch of tickets to start with 112, you'd open the workbook and change the value 100 to 112, and update the remaining values accordingly. Don't forget to save the workbook after updating the values.
×