I make the design with as many up as I need on the master page, linking the frames where the numbers will go. Then I make the list using Excel, copy paste to ID and apply a paragraph style with “start in next frame” option. Click the outbox on the pasted text to get a loaded cursor and delete the frame. Then just shift-click over the first textframe on a live page to have as many “tickets” added as needed automatically.
An awesome new feature to has been introduced to Microsoft Publisher 2010 is the ability to use Data Sources to create “Catalogue Pages”. This is like a Mail Merge for design documents. Now, I would have to agree that Publisher isn’t the best graphic design program in the market. But it’s certainly adequate for simple ticket designs — for example, for a school social. Let’s say we want each ticket to have a unique number and an inspiration quote. This is all possible through Publisher and a data source, e.g. an Excel Spreadsheet.
If you ever end up formatting a large book or magazine, then knowing the trick to adding page numbers is a blessing you will be thankful for. You’ll save hours of copy-pasting, and your designs will look sharp, attractive, well thought out, and uniformly excellent. Hopefully this tutorial passed on to you something that you will use many times over.
To enter specific sequential number codes, such as purchase order numbers, you can use the ROW function together with the TEXT function. For example, to start a numbered list by using 000-001, you enter the formula =TEXT(ROW(A1),”000-000″) in the first cell of the range that you want to number, and then drag the fill handle to the end of the range.
After years in the graphic design and art industry, there’s one thing that I can’t understand: why designers try to get along without Adobe InDesign. I’ve been using this program for many years, and it’s helped me work efficiently and productively. I’ve created this website to show everyone that InDesign is a program that you can and should learn, and the best program for layout and desktop publishing. If you’re interested, check out my book on creating an ePub with InDesign. It’s got all you need to know in order to take your eBook from the final draft to an interesting and well-formatted ePub book.
Normally it is easy to insert sequence numbers in contiguous cells of Excel by dragging mouse, after you enter two numbers, such as 1 and 2. However, if you want to insert customized sequential numbers in Excel, such as 000 – 001, 000 – 002, … 000 -020, it is quite hard because you cannot add 0 at beginning of cells unless you convert numbers to text. Now, with the Insert Sequence Number utility of Kutools for Excel, you can create any customizing sequence numbers and insert them quickly. With this handy utility, you can:
So, if you wanted to use this idea in a form or datasheet, let me stop and first remind you – if this is going to be non-updatable, you can just embed a report as a subreport within a form and thus use Running Sum. But let’s discuss the case where you need to be able to edit data in the forms, even with sequential numbering generated for the data you are viewing. This means we need to be able to tie a sequential number to a specific row.
The benefit to this is that you are not limited in the layout and font used, however the file size can often be too large to upload to our website. If supplying your artwork this way, it must a press-ready PDF file – our prepress team will not be able to make any adjustments to the file.
there.. i’ve tried using recording Action. How to use script, (if i have to use script, can you instruct me on a step-by-step procedure or atleast pinpoint me to a thread that explains it, because the ticket’s deadline is on May 4th, and again i have 12,500 tickets to make)
To use mail merge to create a batch of gift certificates or coupons with tracking numbers, you need to set up a data source that contains a column listing the tracking numbers. If you plan to add only the tracking numbers to your publications, create a data source for the tracking numbers. If you also plan to use mail merge to insert additional information into your publications, such as customer names or addresses, you can add the column of tracking numbers to a data source that also lists the name and address data that you want to use.
This does not work well with duplicate values. When you compare duplicate values, discontinuous row numbering occurs. If this is not the behavior that you want, you can avoid it by hiding the rank column when you insert the result in a spreadsheet; use the spreadsheet numbering instead.
Tip If you would like to create a numbered list that is not attached to the current numbering scheme in your document, you can use the SEQ field to insert numbers. This is discussed near the end of this chapter.
It depends what the design is for the tickets. But if you set up primary text frames, linked for the area for the numbers, you can create a numbered list with the numbering format you want. Then, just pour in a whole load of paragraph returns that have that numbered list applied. And make sure each numbered paragraph is set to start in the next column.
We require at least 20% extra numbers for overs (extra numbers in-case some are discarded due to quality control – for example: if you order 100 cards, you will receive at least 100 finished product, but the sequential numbering might go up to 120 because 20 of the cards had to be discarded during quality control).
Word includes a special sequencing field that you can use to do all sorts of numbering. You can even use the SEQ field to help create broken numbered lists. (A broken numbered list is one in which the flow of the list is interrupted by paragraphs of a different format.) This approach to creating numbered lists is particularly helpful and much less prone to the problems inherent in Word’s built-in list numbering. For the purposes of this tip, the format of the sequence field is as follows:
Ok, so what don’t you understand in the blog? You will need to create a new field for the sequence number. But the blog explains how to set this all up. If there is anything specific you are having trouble with, feel free to ask.
simple programme for consecutive numbering of forms while digitally printing? e.g. adding consecutive numbers to a batch of pre-printed invoice sets. One original, but numbers on it http://ringringpromotions.org or decreasing as they are printed.
indicating the tenth inquiry of 2009. You can use that as the Controlsource of a control on a form or report. In a query you would preface with an Alias rather than the equals sign (i.e.; Inquiry Code:).
You cannot specify when a section ends. Rather, sections always continue until the next section starts. Each section can have entirely unique page numbering. It can be based on the section that preceded it, or it can arbitrarily start at any number you choose.
I haven’t tried this… But according to the Microsoft instructions about field switches (http://office.microsoft.com/en-us/word-help/insert-and-format-field-codes-HA010338798.aspx), you can add text to a field code. The text must be in single quote marks, and displays as a constant for the field. The examples on that web page show the text at the end of the field, but you could try it earlier in the field by testing putting ‘120/’ in front of where the SEQ number will go.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!
In the Replace control, enter the keys you’ll press to insert the field. You’ll want to choose a key sequence you won’t use (or seldom use). I used 1} as shown in Figure H. Those two keys might be easy to remember when linked to a reset SEQ field. (At least, I think so.)
CK Note: I strongly recommend reading the following article. It may save your sanity (or at least your job). See Word’s Numbering Explained by John McGhie. Somewhat easier reading and still very useful are Shauna Kelly’s articles (see above) on outline numbering and bullets.
The following screen shots are from Word 2010 but this applies to all versions of Word. (Here is the same question and answer using Word 2003 screen shots.) This is CK’s response to a question on the Microsoft Answers site.
I have to print a 1 page pdf document. But I want there to be on top of the page a sequential number that would appear when I print for example 500 copies. There would be 001 on the first, 002 on the second, etc…
You lost me by step 14. I couldn’t understand where to create the no. 2… onwards, and how to save this label file, (which gets saved as a separate word file) and how to bring it in my table that I created in my original file.
One thing so far is if I change say 1000 in the first field to 999, I can’t figure out how to get all the other fields to update. I can right click each one individually and choose update field, but that could take for ever once there are a lot of fields.
Number Position This affects how numbers line up in a document, whether they are right, left, or center aligned. For example, you may want decimals to align for lists with double-digit numbering and thus would choose Right alignment. Settings in this area do not affect the text however.
I am trying to use mailmerge to print tickets. I tried using a column of sequential numbers on a spreadsheet and inserting that as a field into the mailmerge, but oddly, it used number 8 eight times on the first page, number 16 eight times on the second page, etc. So, I tried using a sequencing field as you describe. It worked great for the first page (numbers 1-8) but when I completed the mailmerge, it repeated numbers 1-8 on each successive sheet. What do I have to do to make this work in a mailmerge?
I have the page numbering macro. It works on new files; however, it doesn’t work on specific saved files. What could be wrong with those files? Is there any way to enable the page numbering macro in those files?
See attached. I’ve replaced your manual numbering with Word’s Heading Styles using multi-level list numbering. Adding a new row to the table will result in that row’s numbering incrementing. Changing the heading level will re-set the numbering accordingly.
4. With that, your page numbers are added and formatted. Go to any one of your other pages and see how they contain the correct page numbers, and how the page numbers are formatted just as you wanted them to be.
Select Continue Numbers From Previous Document In Book to resume numbering the list from the previous document (you must choose Continue Numbers Across Stories to activate this option), or deselect this option to start the list in the current document at 1 (or A).
1. Yes, after you click the output box of the frame with the pasted text you delete that frame while the cursor is still loaded. That is to make sure you got all the text loaded for the automatic adding of pages as needed. If you leave some of the pasted text in its frame, and delete it afterwards, you will not get new pages added automatically.