Erica Gamet has been involved in the graphics industry for an unbelievable 30 years! She is a speaker, writer, and trainer, focusing on Adobe InDesign and Illustrator, Apple Keynote and iBooks Author, and other print- and production-related topics. She is a regular presence at CreativePro Week’s PePcon and InDesign Conferences, and has spoken at ebookcraft in Canada and Making Design in Norway. You can find Erica’s online tutorials at CreativeLive and through her YouTube channel. When she isn’t at her computer, she can be found exploring her new homebase of Seattle and the greater Pacific Northwest.
If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.
Add specific codes to coupons to track customer responses     Use different codes for your different marketing messages, advertisements, or promotions. These codes will enable you to keep track of how customers learned about your offer. The more you learn about who is drawn to your business and what attracts customers' attention, the better you can focus future marketing efforts.
I'm producing gift certificates for a restaurant and they need to be numbered sequentially from 0001 to 0250. Is there any way to do this easily as opposed to numbering each manually? I'm sure I could probably work it out with a print shop, but the job was thrust on me last minute and my options are limited by the short turn around time. Any help would be appreciated. Thanks!...

Adobe’s 2018 update for InDesign includes a great new feature for book designers—live InDesign endnotes. Until now, footnotes and endnotes could be imported from Word to InDesign, but only footnotes continued to be live and linked, allowing us to insert and delete them without messing up the numbering system. Now we have the same flexibility with endnotes!

When generating invoice numbers based on the customer number, you can choose whether or not to include any date information. Either way, the number will begin with the customer number and then be followed by the date (if desired) and the sequence number. No matter how you decide to structure your invoice number, the sequence number always needs to come at the end. This makes it easiest to find and to differentiate from the others in its sequence.


Tip  Follow the same steps (above) to create Request for Production or Request for Admissions. The only difference would be in Step 3, you would change the "rog" to "rpf" or "rfa". This will keep unique numbering schemes running in the same document. Therefore, you could have an Interrogatory No.1 as well as Request for Production No.1. Keep in mind that if you cut, copy or paste sequence codes, you'll need to select them and press F9 to update the field codes. They do not update automatically.
If the list you want is as simple as "1", "2", "3", you'll appreciate how easy it is to apply this type of numbering in legal documents. Simple numbered lists are different in Word 2000 than they were in Word 97. In Word 2000, the default for even the most basic list is multi-level. For example, if you number an item and press Enter and then press the TAB key, Word automatically formats this number as the second level in an outline numbered list format. Single and multi-level numbering are explained later in this chapter.
An overwhelming majority of companies use designation-based part-numbering systems. A Design Management Procedure, for example, may be numbered as SOP 4.4-1. With the previous revision of the ISO 9001 standard, it meant that this document related to the element 4.4, design management. Well, it does not mean the same with the new ISO 9001 revision, simply because design management clause now has a different number: 7.3. What is the solution? The solution is simple: no part numbers, and no designators!
So if you encountered this problem, then you didn’t follow the instructions completely (which is OK) and appear to be automatically generating the number whenever the record is accessed. If that’s the case, then you are risking duplication because you are not saving the generated number immediately. Rather then try to test if a number already exists as you seem to be doing, you should not automatically generate the number, but trigger the generation from some action in the form.
There are also other problems – for one thing, it’s not a very generic solution. You must customize several parts to work for different queries. If the set of tables used in the outermost FROM clause are different, to be the innermost FROM clause, you have to adjust the WHERE clause to reference the correct primary key (or some combination thereof). Then you have to also keep the ORDER BY in sync. That’s a lot of tweaks if you want to use it for different queries. That is why this is the last method listed here but it is one possible solution.
i have used batch process to make a whole bunch of photos one size.  I need to create a single 'photo wall' jpg out of them in which they're all tiled, the long way of doing this is to obv open them all and copy, paste into the psd, then flatten, but thats really, really time consuming.  If photoshop had any type of auto import & tile feature?  I may have to do this a 2nd time with 1000's of images.

If you use the Form Wizard, controls will be named with the field name the control is bound to. But that name can be changed. This trips up a lot of people because my code samples use a naming convention that is not what is automatically generated. So you just need to make sure you use the correct name for the object. The name is shown in the Name property on the Other tab (Not the Caption property). To determine what field in your table the control is bound to check the ControlSource property. It should be bound to the PONum field.


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...)

Yes, I have used this system in a multi-user setting. As noted, the key is to commit the record immediately after generating the sequence. However, if the application is one where there is very heavy transaction processing. In other words dozens of users creating records simultaneously, you might want to guard further against duplication. At the speeds computers process, it is not impossible that multiple users will grab the max value before it can be incremented and saved.
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.

Perhaps your explanation already addresses this, but I can’t see it. Is there any way this script can be used for printing multiple-up in numeric sequence? For example, if I’m running 1000 postcards 4-up (on 250 sheets). I need the 4 cards on page 1 to be numbered 1, 251, 501, 751; then the 4 cards on page 2 numbered 2, 252, 502, 752; etc., so that when the sheets come out of the printer and are cut into 4, I have a stack of 1-250, a stack of 251-500, a stack of 501-750 and a stack of 751-1000.
2. Yes, The code should be entered using CodeBuilder. Where you enter it depends on how and when you want to trigger the generation of the next number. If you want to use a button, that works. And no, you don’t use 000 in the NZ() function. If you want to DISPLAY at least 3 digits with leading zeros, then you do that in the Format function. Note, though, you will need to change that when you hit 1000 POs.
I am printing many pages of tickets. Each page has 5 tickets and I would like to sequentially put a number on each ticket. I have tried to use the auto page numbering feature but that is putting the same number on each of the 5 tickets and then increments for the next page -- not what I need. Also, can the numbering not suppress the leading zeroes? Thanks.
A quick way to create a bulleted or numbered list is to type the list, select it, and then click the Bulleted List or Numbered List button in the Control panel. These buttons let you turn the list on or off and switch between bullets and numbers. You can also make bullets and numbering part of a paragraph style and construct lists by assigning styles to paragraphs.

I am curently working on a larger projekt, where we have aprox. 4500 pcs.of furnituer designed in 4 different kind of families, generic, furnituer, furnituer systems and specialty equipment. We need to be able to asign every  pcs.of funituer a seqventual serial number, we have tried to do this using an extension with a funktion called element positionerning, but we have had no success with this tool, apparently it is taking up to much memory.


Thank you for these instructions!! I’m using them to auto number my son’s baseball team raffle tickets which we hand numbered last year (UGH!). I followed the instructions exactly but for some reason the numbering is starting at 2 every time. I did deselect the checkbox about the column headers which seems the obvious culprit. Any ideas? I’m using Word on a PC. Thanks!!

A few days ago I updated Lightroom to version 4.3. Since then, the "auto save to xmp" doesn't work. It is checked, but I keep finding files that "have been changed recently". So not only that it's not auto-saving them, but it is also finding "new images" that "have been recently changed" even though I didn't open or edited them in the past several months..

If your document has one page to start with, InDesign will place the endnotes text frame on a new page 2; if your document starts with three pages (following our example on page 34, BDMS), then InDesign will place the endnotes text frame on a new page 4. Before flowing the rest of your manuscript into your pages, drag your endnotes text frame onto the pasteboard for now. You’ll be able to position it appropriately in your book later on.
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.
×