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.
The auto-indenting feature of bullets and lists has always frustrated me. EVERY time you apply a numbered or bulleted list, you've got to set the indents. I want my lists to be indented at the very left of the page, flush with the rest of the paragraphs. But no, Microsoft insists that you want them indented by 0.63cm and hanging at 1.27cm (WHY 0.63? Why not 0.7? Or 1.0cm? But that's a question for a different session.) (I know, it's because MS is American and still uses inches etc...)
Like Microsoft Word, Publisher also lets you add page numbers to your document. This is a special element of the document, as the page number function is smart enough to manually adjust itself in the event that something changes the number of pages in the document. This makes it (typically) preferable to a manual page numbering system that could become incorrect if the number or order of pages changes. Our tutorial below will show you how to insert page numbers in Publisher 2013.

You can insert page numbers on the current page, all pages, all odd pages, or all even pages. When you insert page numbers on multiple pages, a new master layer is automatically created, and the page number is placed on it. The master layer can be an all-page master layer, an odd-page master layer, or an even-page master layer. For more information about master layers, see Creating layers.


There’s an old Steve Martin joke about how to make a million dollars which starts, “First, get a million dollars…” That’s the key to this trick, too: First, get a bunch of numbers. Here’s a file with 1,197 numbers in it. Now import or paste those numbers into a thread so that the numbers appear in the right place. If you need two matching numbers, just import it twice.
Thanks for asking, but if you haven't done the Google search I suggested in post 1 of this thread and practiced with any of the tutorials at the linked resources there, or those recommended in posts 2 and 6, please do. Perhaps someone on the list will do the work you're requesting. As a trainer I feel my best value is to offer paths to solutions so folks can learn to use the tools. Some tools require more practice, but those are the ones that give the most pleasure of discovery at the "Aha!" moment that comes when one "gets it."

CK Note: Word 2007 - 2013 interface has an different automatic numbering scheme which I have been told is much less subject to corruption. Microsoft Word 2010 Bible by Herb Tyson, MVP. However numbering is still very imperfect in these later versions. I still recommend following Shauna Kelly's step-by-step instructions (see above) if setting up numbering in a template or in a document likely to be heavily edited. If you start without doing this and end up with "spaghetti numbering," fixing it will be a very large chore!
There may be instances in your Adobe InDesign documents that you want to change the start page, by default the numbering starts at page one on the first page of your document but if you right click on for example page 2 you can select ‘Numbering and section options’ then you can click the button ‘Start page numbering at’ then type ‘2’ in to the box. this will snow start a new section on page two which will make page 2’s page number actually page 1. You can start new page numbering sections anywhere in your Adobe InDesign document. 
Help! Having a problem. I realize this is for CS5, which may be the issue. I’m working in CS6, and when I do this, it changes page 1 to a right-side page, completely affecting all of the spreads. I’ve tried to go into Document Setup to force it back, but it ends up making TWO right side pages for the first two pages! Perhaps a difference in versions, or maybe a bug?
InDesign allows you to add a page number marker to a master page within the document. The master page functions as a template for every page it's applied to, so the consecutive page numbers appear on every page. InDesign updates the page number automatically as you insert, delete and move pages. To add a page number marker to a master page, create a text box on the master page by going to the Type menu and choosing "Insert Special Character," "Markers" and then "Current Page Number."

While InDesign veterans may assume everyone already knows this, I can assure you I have worked with very sophisticated documents from designers who did not take advantage of this basic feature. A good rule of thumb to keep in mind as you tackle InDesign challenges is this: If it’s repetitious, tedious, or time-consuming, there’s probably a built-in solution right there in the program. You just need to go look for it.
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.
×