An easier way is to setup the table in Excel and use the Excel features to create sequential numbering. The cells making up the whole table can then be selected and copied into a Word document using CTRL/C and CTRL/V which will create a table in Word. Column widths and borders can be set up in Excel and cells can be filled in before copying to the Word document.

An InDesign document can only have one chapter, and these chapters are typically combined in an InDesign book. To insert a chapter number, create a text frame where you want the chapter number to appear on either a document or master page. Click on the "Type" menu, then "Text Variables," "Insert Text Variable" and then "Chapter Number." Update the chapter number if necessary to keep your chapter numbers consecutive by clicking on "Numbering & Section Options" in the Layout menu.


An invoice number is simply a way to uniquely mark an invoice to help keep track of your business transactions. Consecutive or sequential invoice numbers help to ensure that each invoice is unique and each business transaction can be clearly and comprehensively organized and referenced – for accounting reasons as well as customer support. While a receipt is generally used as proof of payment and therefore documents a finalized sale, an invoice is a request for payment that includes more detailed payment or contact information in addition to pricing information for the goods or services rendered. Having a proper invoice numbering system helps you avoid duplicate payments that can amount to large losses for your company.
A note about link exchanges. This site does not participate in link exchanges to build web presence. If you have a link that you think would be of use to people reading this page, please send it to the webmaster with the url of the page where you think it should appear and it will be considered. Your placing a link to this site will not affect the decision on whether to add your link, though.

Step 4: Go to your coupons, page 1. Select the first text box (Command + Shift + Click to release from master page) and paste. The numbers will populate all of the boxes on that page (0001-0008). Now, here's where I'm not sure if I have a plugin doing this or not. The document should add pages to correspond to all of the numbers you have. If it doesn't (and it's doing it on mine because of a plugin), you can select the little red plus in the bottom right text box, add a page and hold down the shift key when pasting into the top left text box of page 2. That will add pages as needed.


No matter how light the file might be, if you need 1000 units, that means you send a 1000-page file to the printer if you use Data Merge, that is not as efficient as sending one page and 1000 numbers to insert in the print stream, but to do that you need a plugin, which is what that page Bob directed you is leading up to. I've never used the program Harbs has mentioned, but he's a pretty smart guy and if he says it works well, I'd take a look.
Hi, As a new user to excel I am thinking of setting up a data base of my music. The total number of tracks is in excess of 70,000. I have seen a simple solution using excel which would be ok but I'm not sure if I can have 70,000 rows in one work sheet. A friend has suggested access which I am not familiar with and don't know if this will allow 70,000 entries. Can anyone please tell me what the maximum numbers are in both access and excel 2003. Cheers Glinty Max in Excel 2003 is 65536 (in one sheet) whereas Access only limit is your memory -- Regards, Peo Sjoblom ...

Is there a way to do this: I have a form called "List of Proposals Written" that is listed by th Proposal number. Is there a way to display on another excel spreadsheet, the mos current Proposal number? I know Access you use something like Dmax(ProposalID)+1 What should I do in Excel:confused: Any help would be greatly appreciated! Michae -- Message posted from http://www.ExcelForum.com "daniels012 >" < wrote > I have a form called "List of Proposals Written" that is listed by the > Propos...
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.
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.

Using this script… no. While I use the data merge feature of InDesign often, I avoid the “multiple records” feature, but I typically prepare one record on one page, output the resulting file to PDF and then let the imposing software take care of the page imposition. If page imposition software is something that you don’t have, there is an alternate technique that requires preparing one record on a page, and then using the multipageimporter2.5 script to import them onto a larger sheet. Here is the link to that article: http://colecandoo.com/2011/10/28/theres-more-than-one-way-to-cut-and-stack/

Defined lists are often used to track paragraphs for numbering purposes. When you create a paragraph style for numbering, you can assign the style to a defined list, and paragraphs are numbered in that style according to where they appear in the defined list. The first paragraph to appear is given number 1 (“Table 1”), for example, and the next paragraph is given number 2 (“Table 2”), even if it appears several pages later. Because both paragraphs belong to the same defined list, they can be numbered consecutively no matter how far apart they are in the document or book.
You may wonder whether typing 1, 2, and 3 would be easier than using the ListNum field. Although doing that may be easier initially, the value of using the ListNum field becomes apparent when you cut and paste. When a paragraph contains multiple numbered items that you move or delete, Word automatically updates the ListNum fields. Using ListNum fields assures you of accurate numbering within a paragraph throughout the document.
I thought I'd try and just create one decal and use the print merge feature but I don't print from my workstation. I create the design in X7 then export it to a RIP Station for print. I thought I'd just do the print merge and print as pdf just to get the numbers without typing them. That gets me all the numbers in sequence but all on 500 separate pages.
Typos can easily occur, and spelling errors in the company name or other more trivial information on the invoice doesn’t necessarily require correcting. If the invoice number contains an error, though, failing to correct it may prove painful. A general rule of thumb in accounting is that finalized invoices should never be deleted, so when correcting an error it’s recommended to create a new invoice with the correct information and send that to your customer along with a note of correction, so that evidence of the correction can accompany all of the evidence in both your books and the books of your customer, therefore avoiding any future confusion. If the customer has already paid, make a correction adjustment on a future invoice, or issue another invoice or credit correcting the mistake.
Basically, the only difference is that we now maintain a VBA.Collection, and this time we do make use of the UniqueKeyVariant parameter, using it as a key to locate the previously assigned number. If we don’t find it, we add to the VBA.Collection. The SQL to use those 2 functions remains identical. The downside is that if the query generates millions worth of rows, the memory may run out due to a large VBA.Collection. However, if a form is bound to that large dataset, it will likely have several other problems anyway so VBA.Collection should not be a problem for forms that loads a few hundred rows. The other downside is that VBA.Collection will persist indefinitely even long after the query has “finished.” Back to form example, you might need to remember to call the ResetRowNumber() function on a form’s close to ensure that you dispose of the VBA.Collection and free up the memory.
To design a certificate from scratch, you can either start with a completely blank publication or adapt an existing publication. Small-sized publication types, such as business cards, postcards, and labels can be adapted to serve as coupons. Flyers or brochures can be adapted for use as gift certificates. For more information, see Create a publication in Publisher.
Hello, I'm looking for a way to quickly find what numbers are missing in column B. I can sort them ascending, but how do I find if there are missing numbers? 1 2 3 5 6 7 9 I need to know 4 and 8 are missing. Thank you. One way: select B2:Bx. Choose Format/Conditional Formatting... CF1: Formula is =(B2-B1)>1 Format1: / or, without sorting, select column B (with B1 active): CF1: Formula is =AND(B1>MIN(B:B),COUNTIF(B:B,B1-1)=0) Both CF's will activate if there are missing numbers before them. In article <28706E9E-2624...
With this expression we check only for records that are in the same year as the Inquiry date to increment the sequence. Again, the NZ function will automatically restart the sequence with each year. Cleary, though, we cannot generate this number until the InquiryDate has been entered. Is this value is a user entry, then you may want to check that it’s filled in before generating the number. Something like:
I have screen shots of what I have in my db, where can I send it to you (it is in word format) so that you can take a look at it to see what I am doing wrong. I took a screen shot of what is listed for the button and I took a screen shot of the text box Job No. I don’t know how to bound anything other than put the code behind the button and putting the Job_No in the code as you stated. I understand what you are saying, but I thought if I put the text box name Job No in the code behind the button then it would be bound to my table with the Job No field. Heeeelllllppppp!!!! I am sorry that I can’t seem to grasp this….but appreciate all of your help!
Endnote numbering is sequential through the entirety of the linked text frames, treating them as one frame. When you add a new text frame that isn’t linked containing an endnote (such as a break-out or call-out box), InDesign will use an endnote number following the last number in the linked text frames. So if the endnotes in your linked text frames are numbered 1 to 50 and you add a break-out box on page 6, any endnotes in the break-out box will begin with number 51 (and appear totally out of sequence!).
we have printed AP checks using the check number from 0000000001 to 0000000006, but we havent posted those batches. we have only one checbook. Now can we restart the check number from 000001. Then do we need to delete the previous batches for checks printed. What is the best approach in this regard. Thanks in Advance, Arun. In the Post Payables Checks batch window (Transactions > Purchasing > Post Checks), choose the batch in question, then select Reprint Checks from the drop-down list. Enter 000001 for your starting check number. You will also need to go ...

The Artifact ID should NOT be your PK. There is no reason for it to be and to try and use it as such will be a headache. A primary key is simply a unique identifier for a record. Many purists will tell you that users should never see the PK and in your case, I would recommend that. Use an Autonumber as you PK and you can use that as your corresponding Foreign Key in related records. To prevent duplication you can make the combination of Collection Point ID and Artifact ID a unique, multi-field index. Then display the combination as I indicated where you need to show the user a record ID. This is all explained int he blog.


The Renumber/Refresh List toolbar command is used to renumber an existing numbered list or to refresh a list after editing. For example if item 3. is deleted from a list by editing then you can use this tool to refresh the list. You can also use the Renumber/Refresh command to number or renumber a selection of list paragraphs with any chosen starting number.
Typos can easily occur, and spelling errors in the company name or other more trivial information on the invoice doesn’t necessarily require correcting. If the invoice number contains an error, though, failing to correct it may prove painful. A general rule of thumb in accounting is that finalized invoices should never be deleted, so when correcting an error it’s recommended to create a new invoice with the correct information and send that to your customer along with a note of correction, so that evidence of the correction can accompany all of the evidence in both your books and the books of your customer, therefore avoiding any future confusion. If the customer has already paid, make a correction adjustment on a future invoice, or issue another invoice or credit correcting the mistake.
Hi Jason! Hard to say when I’m not sure which part isn’t working for you. If the numbering isn’t continuing across separate frames, you need to make sure you’re using a list. If they are in the wrong order, remember it uses the paste/creation order to number them. If neither of those fix it, let me know what specific issue you’re having. Good luck!
See Word's Numbering Explained by John McGhie, MVP - comprehensive and not pretty (Downloadable pdf file in letter size) - Reading this is vital to anyone attempting to use automatic numbering or bullets in a law office setting or other places where the documents are likely to be reused or heavily edited. See also How to Create a Template with a downloadable template with style-based numbering.
I am having trouble with this procedure. My situation is almost identical to example #2. I want to populate RecordNumber on my form with a date number like “130001, 130002, etc.” where “13” is the year based on a date automatically generated in the OpenDate field in tblLogRecords. OpenDate is a date/time type field that has a default value of the date the record is created and is not editable. I have added a field called Sequence to tblLogRecords and it is a Number, Long Integer type. I also created a bound control for Sequence on my form. I have a completely separate autonumber field as the PK.
Hi Tara, Thanks for sharing your observations! I agree that breaking your chapters into separate text frames is not the ideal way to go, but is only useful if you must have live endnotes at the end of each chapter rather than at the back of the book. One alternative in this scenario is to create a separate InDesign document for each chapter, then use the Book feature to tie them all together. Whether your chapters are in separate text frames or in separate documents, you’ll still need to be very vigilant with any changes to the flow of text to make sure the pagination is okay.
I have a document where in I have to make two kinds of page numbering, A catalog (individually made) which should always start at page 1, and the other is a compiled version where the pages should be a continuous page. They both have the same content but with different output so I tried using layers, but fail to set the page numbering to auto. because setting them would affect both layers.

© Corel Corporation. All rights reserved. The content herein is in the form of a personal web log ("Blog") or forum posting. As such, the views expressed in this site are those of the participants and do not necessarily reflect the views of Corel Corporation, or its affiliates and their respective officers, directors, employees and agents. Terms of Use / Privacy​ ​/ ​Cookies / Terms and Conditions / User Guidelines.


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.


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