sequential numbering

Enter the value you want to start with, and when you click OK, Word updates the numbers in the cells. You’ll also note that if you insert any rows in the middle of your numbered sequence, Word automatically adds a number to that inserted row.

We’re a friendly discussion community for Microsoft Office help and support. All of the individual suite applications are supported here, so please post your question in the relevant section for help. More About Us…

This video gives an overview of how to use Corel Draw and layout and number raffle tickets using Number Pro to create the data file for the numbers needed. This video covers how to import a data file previously created with number pro and positioning the numbers on the raffle ticket file that was also created prior and imported as an image file. To learn how to create a data file with the raffle ticket numbers you want to use – check out http://www.number-pro.com or search for How To Use Number-Pro here on youtube. As always more info can be found at http://www.number-pro.com

Open Publisher and click the “More Categories” file folder in the bottom right of the “Available Templates” screen. Scroll to the bottom of the list and double-click one of the options in the “Tickets” section. After a few moments, a sheet of tickets will open in the Publisher workspace.

Thanks, Scott. I made the changes you suggested, but it’s still not working. Nothing is being populated in the Sequence control on the form. If I manually enter a # in the Sequence field, the RecordNumber displays correctly. Here is my code for the SaveRecordButton and the controlsource expression for the RecordNumber.

Note The values in the Qty column are incorrect. However, the ranking of stores based on the quantity of books sold is correct. This is a defect of this method. You can use this method to return the ranking of stores if you do not care about the wrong quantity in the result.

The SEQ or Sequential Numbering Function in Word is the best and quickest way to number your tickets. Many raffle ticket templates use them, yet few sites explain how it works. To see if it uses the SEQ function, you need to download the template first. Then, open it in Word, click right in the middle of where a serial number is, and then right-click.

No, Since you will be starting with a 3 digit number initially, then you don’t need to use the Format function to pad with leading zeros. And since you won’t be using the sequential numbering in coreldraw function, then there will be no problem when the number goes to 4 digits.

My solution for this when trying to add a number on a page between already existing numbers where to usa a current text frame of the previous number and create a new list object from there. And then I would overset that text and press the overset +-sign to place it on the page. Works perfect.

Of course, there are third-party solutions that are available for creating sequentially numbered labels. One that comes highly recommended by several WordTips subscribers is Bates Labels from Payne Consulting (http://www.payneconsulting.com). This free Word template allows you to easily create as many labels as you need for a specific purpose.

In this example, I will create a set of plates that will be put on each classroom door in a local high school. All plates will have the same logo, but each plate will have a different classroom number and subject.

It makes me think there’s an issue with the spaces I have used in my field names but I have been trying every combination of double quotes and square brackets and when writing the code in the Event Procedure I don’t get any error messages.

I had the same problem and found out the same thing, that it’s the order of creation that seem to govern the lists numerical order. It felt intuitive that the order in the layer-panel should be where this could be managed, although perhaps there’s some reason for why that isn’t a good idea that I havn’t thought of.

Inside the field braces, type SEQ followed by a space, then a name you want used for this particular sequence, then another space, then \r, then the number you want the sequence to start with. Here’s an example of how the field code would appear if you wanted to start counting with the number 4:

Hi Scott, Thank you for a very informative Blog. I am however stuck. I need to create a sequence for patient record cards based on their LastName. ie For names beginning with “A” =A001, then A002, For names beginning with “B =”B001, then B002 etc.

Thanks for this tip, it is close to what I need in my requirement specification – but my problem is that I need the (requirement-)numbers to be allocated once a requirement is defined, and then stay with that value ‘forever’, and at the same time be sure to have unique (requirement-)numbers.

The SeqField List Numbering Add-In provides a toolbar and keyboard shortcut to quickly create, expand, or refresh numbered list using SEQ fields. The following paragraphs and illustrations provide an introduction to using the SeqField List Numbering add-in.

I am using your instructions to create a page of tickets – the design has been created as a picture so I added a text box to “hold” the mail merge instructions but I keep getting the error message “You cannot include DATA, NEXT, NEXTIF, or SKIPIF fields in comments, headers, footers, footnotes or endnotes.” I have not included any of these but I’m wondering if it’s because I’ve attempted to insert it in a text box. Is there an easy way to do this? TIA

The addition of the \r1 switch causes Word to start the sequence counter over at 1. You would use this whenever you wanted to start a new list, and use the regular field for the rest of your numbered items. (If you want to start the list over at a number other than 1, use the starting number right after \r.)

Is it possible to create a document with a number in the top corner that will auto number every time the document is opened, e.g the first time it is opened thw number could be 10 then the next time it is opened the number would be 11 and so on

If list items appear in unthreaded frames on the same page, items are numbered in the order in which the text frames are added to the page. To reorder the items, cut and paste the text frames one by one in the order in which you want them to be listed.

Scott, I had posted on Microsoft and you sent me to your blog to have the numbering system (similar to APEX example) explained. I am not a programmer and I don’t understand where these codes and expressions are even suppose to go in access. When I do try to implement the little I do know I continue to get errors. I am not sure if I am putting the information in the wrong place or if I am way off. Do you know of any youtube videos that could walk me through it step by step? Or if you have the time could you help walk me through the steps.

We created a spreadsheet with numbers running in one column in 4-out number groups: 1, 251, 501, 751, etc. and use the multiple records set-up. Our recent challenge was to take that spread sheet and do the 4-out number groupings in threes for reverse collate 3-part NCR on a copier. Takes a bit of time to set up but worth it in the long run.

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

The Nz function will return 0 if there are no records so this expression will return a 1 the first time and then increment the highest number each additional time. The key is where to put this line of code. As I said it needs to be generated immediately prior to saving the record so that another user does not get the same number. So generally I would put this behind a Save button or a button to specifically generate the number. I would then add a second line to commit the records. Either:

Just struggled through exactly the same issue. Copy the 1st page onto the second, right click on the each inserted number, and click update field, then select that page, copy and then paste for as many pages as you need. Select all these pages and hit F9, and as if by magic, all the number will fill in.

The SeqField List Numbering Add-In provides a toolbar and keyboard shortcut to quickly create, expand, or refresh numbered list using SEQ fields. The following paragraphs and illustrations provide an introduction to using the SeqField List Numbering add-in.

Sequential/Serial numbering is available on many products such as business cards, flyers, and posters (at an additional cost) but can only be done with our Digital Output printing service (not available with Offset Output). This service is not included as standard on our products and requires a Custom Print Quote.

I’m using Column A of a spreadsheet to number some items in Column B. I’ve been using Excel’s automatic series-filling function, where you drag down from the lower right corner of a cell. However, since some of http://ringringpromotions.org rows in Column B are empty, and I don’t want them numbered, I have to stop numbering and manually “jump” over the blanks in Column A. Is there a way to automatically number down in Column A, while skipping over the blanks and continuing where I left off? I.e. 1 2 3 4 5 ? Thanks much. Try this in A1: =IF(B1<>“”,COUNTA($B$1:B1),”…

also the way that i print this is first as you can see saving it one by one as .jpeg and selecting 9 of the .jpeg files, right click, then print as wallet size, for it to fit in a 8.5 / 11 paper.. there..

You should understand that the sequence field can be much more powerful than implied in this tip. If you want additional information on how it can be used, you should refer to the on-line help for the SEQ field.

These numbers are updated when you sort them with your data. The sequence may be interrupted if you add, move, or delete rows. You can manually update the numbering by selecting two numbers that are in the right sequence, and then dragging the fill handle to the end of the numbered range.

See how easy it is to add sequential numbering to Avery products using Avery Design & Print Online at avery.com/print. Great for adding tracking numbers to items like Avery Tickets with Tear-Away Stubs.

I\’m new to access with that being said where do I put the code Me.txtSequence = Nz(DMax(“[Sequence]”,”tblInquiry”,”Year([InquiryDate]) = “ & Year(Me.[txtInquiryDate])),0)+1when I try to build an expression code I receive an invalid syntax error message.

Their is a mail merge feature that allows creation of a data file that can be used with that , but I’m not sure that will do what you want. Corel is basically a graphics and illustration program, not an engraving application. I have a rotary engraver that runs Vision Pro engraving software that has a feature called Badges, it it will do about the same thing as merge in Corel.

Thank you for your prompt response, Deborah. However, I don’t believe I explained myself in the detail required. To reiterate: My autonumbering example is FORM INTERROGATORY NO. 1.1. The next interrogatory would be numbered 1.2, then 1.3, etc.–automatically and sequentially numbered. Next would be FORM INTERROGATORY NO. 2.1 (see example 1.1 above). Please understand that the interrogatory must be auto-numbered–both the 1 and the 1, both the 1 and the 2, etc.; both the 2 and the 1, both the 2 and the 2; both the 3 and the 1; both the 3 and the 2. That is my dilemma.

2. In Excel first type a 1 in the top cell and a 2 in the cell below that, than select both cells and grab the very small handle in the bottom right part of cell 2, and then just drag downwards to have Excel fill in the numbers.

When the context menu opens, look for the choice Edit Field…. If it doesn’t exist, then your template doesn’t use the SEQ function. If it does exist, click on it. When sequential numbering in coreldraw next window opens, you should see SEQ in the Advance field properties box. That template definitely uses SEQ.

I am trying to automatically print sequential numbers on individual cards on 8.5″ x 11″ business card stock (to create tickets) using MS Publisher and cannot figure out how to get it to do this. Does anyone know the secret? Thanks. Hi Scott (scottmarsh@excite.com), in the newsgroups you posted: || I am trying to automatically print sequential numbers on individual || cards on 8.5″ x 11″ business card stock (to create tickets) using MS || Publisher and cannot figure out how to get it to do this. Does || anyone know the secret? Thanks. Check out the following tutorial:…

How can I remove number from the first page in İnDesign CS6? Update … If the question is how do I start numbering pages so that I start a new sequence …Save 20% on InDesign as part of the Creative Cloud All Apps Plan. Ends Dec. 1!InDesign numbers pages consecutively when you add a page number marker to your documents master pages. … Can You Do Consecutive Numbering in InDesign?InDesign automatically numbers pages of your document in the style you designate when the proper page numbering … How to Insert Page Numbers on …How to Format Bullets in InDesign CS5 … Set the List Type drop-down menu of the Bullets & Numbering … This text field shows the same form of coded sequence …Adding and Formatting Bullets and Numbering in … Adding bullets and numbered lists into your InDesign CS5 … The Bullets and Numbering dialog box will let …Adobe InDesign CS6 What’s New Adapt InDesign page layouts for different page sizes, devices, and orientations more efficiently—without sacrificing pixel-perfect …In this tutorial we’ll show you how to data merge from a spreadsheet into a document with the data merge feature in Indesign InDesign CS6 … Sequential Numbers …Data Merge and Styles for Adobe InDesign CC 2018 PDF Free Download, … Working with Paragraph Styles to Create Sequential Numbering … ePublishing with InDesign CS6.sequential numbering indesign cs6 For 1 PC (Windows 7 or later, home use) Fully installed versions of Word, Excel, PowerPoint, and OneNote For one time puchase For 1 PC (Windows 7 or later, home…

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.

In any event, this is a conversation that needs to include your IT group. (I know, easier said than done.) If they’re out there doing stuff that disrupts your work, they need to make some adjustments to their workflow.

I have a file that displays the text “Page 1” in the center of the worksheet. I have not been able to find a way to stop the page number from displaying. There is no header/footer, no “background”, no other special items that I could find that would force the display of this. It does not appear during the printing so it’s not a “watermark”. It merely displays in my view when I’m working in the worksheet. Help… Hi you’re in page break preview view … choose view / normal from the menu Cheers JulieD “whalenohana”

We also want to setup right away the crop marks for the tickets. Create another layer and call it “crop marks & score marks.” We will place the crop marks and the score line onto this layer. Start placing crop marks that you create with the Pen Tool (P) around the ticket.

I’m trying to skip a couple numbers in the sequence. Is there an easy way to do that? I’m building an auction catalog with over 830 items but some of them aren’t going to be listed in the catalog. Is it just easier to restart numbering at that point? Thank you!

First, create a numbering “list” by choosing Type > Bulleted & Numbered Lists > Define Lists. Then click New to create a new list. You can name it anything you want, but make sure the Continued Numbers across Stories is enabled:

Click within a text box on a PowerPoint slide. If the slide’s layout does not include a text box, click the “Insert” tab and click “Text Box.” Drag your cursor to draw a text box on the desired part on the slide.

Toggle field codes again and with your AutoText entries defined you can easily start new lists or continue with your next number in the sequence by typing the keywords newlist or next and invoking the AutoText entry using F3.

IF a document is part of a book and the previous document ended on a right-hand page, AND if your book options are set to allow documents to start on left or right pages, AND if you choose “Automatic Page Numbering,” THEN the document will be allowed to automatically start on the left page. This is great if you need to break a document up in a spot where it’s not necessary for the next document to start on the right.

I’m also concerned about your table design. You mentioned entering a First name. But I don’t really see that people names belong in a transaction record. Can you explain more about what you are tracking in your app and what these transactions are.

On my website below (link at bottom), I have all my photos watermarked for obvious reasons,this is done by a normal batch convert action using CS2,the gallery is actually a modified Photoshop “Simple” type of thing.

If you make a list of things you need to do, starting with number 1 and continuing until all your tasks are accounted for, then you’ve made a sequential list. Something that is sequential often follows a numerical or alphabetical order, but it can also describe things that aren’t numbered but still need to take place in a logical order, such as the sequential steps you follow for running a program on your computer.

Member separator – when using this for data merge, I would always leave this as paragraph. There are options such as new line (a soft return) but when using this script as a tool for Data Merge, there is no reason to change the default “paragraph”.

17. On the Print Preview screen, click the Imposition Layout tool, and type values for the number of rows and columns on the property bar, depending on how many images horizontally and vertically you want to have on the page. In this example, there are two columns and three rows.

Now repeat for the second and third tickets. But not the fourth, because that’s at the end of the page, so Word will skip to the next number anyway, because the next page always gets the next item in your merge list. Your document should look like this:

What is the max number of records that can be put into a table in Microsoft Access? Does it vary from version to version? Thanks in advance. “Mike C” wrote in message news:BC4F1F10-A96C-4EC7-9E33-670828E53A0A@microsoft.com… > What is the max number of records that can be put into a table in > Microsoft > Access? Does it vary from version to version? Thanks in advance. Google or the online help would be your friend on this one. There’s no fixed limit, there’s only the limit on the overall size of the database file…

Open Word and create a new document and create one raffle ticket. You want to make it about the right size so that you can fit four tickets on the page. Leave space for the ticket numbers, which you’ll add in a minute. Something like this:

A sequence is created independently of the tables by using the CREATE SEQUENCE statement. Options enable you to control the increment, maximum and minimum values, starting point, automatic restarting http://ringringpromotions.org and caching to improve performance. For information about the options, see CREATE SEQUENCE.

Click Print Preview to check the settings. (Publisher 2010 and 2013 does this automatically.) The ticket numbers should increase by one (Figure K) as they do in the Excel sheet. Publisher will generate enough pages to accommodate your entire list of values in Excel.

Since Word 2000 applies outline numbering by default, as you press TAB or SHIFT+TAB in a numbered list, you are moved to the next or previous outline level. If you are in a numbered list that has outline numbering generated by the method described in the previous exercise, when you choose Bullets and Numbering from the Format menu (or alternate-click a portion of the numbered list), the Numbered tab appears on the Bullets and Numbering dialog box. However, if you first select the entire list and choose Bullets and Numbering from the Format menu, the Outline Numbered tab from the Bullets and Numbering dialog box is selected.

Type “seq ” followed by the name of the element. This name is up to you, but should be the same for each item in this sequence. For instance, you could type “seq figures” or “seq tables” (without the quote marks).

You can automatically number items in your document. Most of you already know this. You can also automatically number figures, tables, illustrations, etc. If you decide to reorder those items, Word will automatically update the numbers so that the are in the correct order.

Make sure that you are viewing non-printing characters by clicking the Show/Hide button on the toolbar (the button with on it). You should see paragraph marks next to the word Agreement if you are viewing these characters.

Hi Scott, Thank you for a very informative Blog. I am however stuck. I need to create a sequence for patient record cards based on their LastName. ie For names beginning with “A” =A001, then A002, For names beginning with “B =”B001, then B002 etc.

You have a field in your table named sequence? But what is the controlsource of sequence control on the form? It sounds like you didn’t assign that. Also, if this is going to be your transactionID, you shouldn’t have a field in your table as you will be using the expression to display it. Use an AutoNumber for you PK.

Yes, it is certainly possible to do it without VBA at all. One possible method is to write a subquery that counts all rows up to this row. This also assumes there is a primary key that you can use and you can define a sort order. Here’s a sample SQL:

Good morning! Directions are clear for sure but when i go to merge the first ticket is one but the second number on the raffle ticket is two. i have four raffle tickets per page the first three are messed up but the forth is correct all the way down to 500. Any ideas? i have tried with a header and without a header. i even made the first number with a formula. it does work with out putting next record but like you said it is four tickets with the same number and that would use a ton of ink. Any help would be greatly appreciated.

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.

The general answer is to generate your sequence of numbers using a spreadsheet, and then merge them in to InDesign with Data Merge. See these two example threads from Peter Spier, “Trying to create hang tags, 6-up, 8.5 x 11 with vdp” and “is it possible to autonumber, 3 to a sheet? (1,2,3-4,5,6-7,8,9)”.

You’ve got some tips to help make your raffle more successful. You’ve got several free Word ticket templates to choose from. You know how to sequentially number tickets in two different ways. All that is left for you to do is go sell those tickets, have the draw, and then feel good about helping someone out. All for pennies on the dollar over ordering custom made tickets.

there.. i’ve tried using recording Action but it didn’t help me.. T.T also i don’t have any idea on 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)

I am trying to implement scenario 3 and can not get it to work. I created a button and put the code in the “on click” event procedure. I modified the code to work with my fields and tables. I also added the me.dirty = False and Me.Requery in an attempt to get things to work.

Learning Made Easy! Quickly teach yourself how to format, publish, and share your content using Word 2013. With Step by Step, you set the pace, building and practicing the skills you need, just when you need them! Check out Microsoft Word 2013 Step by Step today!

When I create a new layer, Photoshop automatically assigns a number to that layer (i.e. Layer 51). Is there a way I can reset this numbering system? When I start a new folder with a new set of layers, I want it to begin on #1 again. How do I do this?

I’m getting the following Runtime error msg: Method “PrivateProfileString” of object “System” failed. Can you tell me what I did wrong? Here’s the code I inserted in macro below (its for a House Roster, not an invoice,so I changed text accordingly): Sub CreateHouseRosterNumber() HouseRoster = System.PrivateProfileString(“C:UsersuserDocumentsa” & _ “HouseRoster-number.docx”, “HouseRoster”, “Roster”) If HouseRoster = “” Then HouseRoster = 1 Else HouseRoster = HouseRoster + 1 End If System.PrivateProfileString(“C:UsersJennifer BaumannDocumentsa” & _ “HouseRoster-number.docx”, “HouseRoster”, “Roster”) = HouseRoster ‘ Insert the number in the document ActiveDocument.Range.InsertBefore Format(HouseRoster, “#”) ActiveDocument.SaveAs2 FileName:= _ “C:UsersJennifer BaumannDocumentsaHouseRoster” & Format(HouseRoster, “#”) & “.docx” _ , FileFormat:=wdFormatXMLDocument, LockComments:=False,… Read more »

I’ve just took photos of a wedding, and i have 180 photos that need numbering so i can put on to CD for the bride and groom to choose from. I will make a checklist on paper and they can check off the number of the photo.

How do I set up the basic template for text numbering in Word 2008 for the Mac? Here is what is driving me nuts: I want to generate numbered lists – lots and lots of them. The first level numbered lines will have second level under them in many cases, also numbered and indented below the first level. The second level will also have third level under them, intended some more and also numbered. This “sort-of” works fine. It USED to work excellently. Here is what I do. I click the Numbering button in the Bullets and Numbering palette. The line indents and a 1) is aut…

Each circle will need to have a number. They will be numbered sequentially from 4000 – 4499.  This should work out to a total of 41.6 (42) pages. 4000 – 4011 on page 1, 4012 – 4023 on page 2, etc. etc.  

2. In the Insert Sequence Number dialog box, please click New button to expand this dialog box. In the lower left panel, create your own sequential numbers, at the same time, you can preview the result of your customized sequence in the lower right list box, see screenshot:

– For instance, let’s assume that one of the cells in the table has a content description (It’s really an issue, described elaborately in at least a long sentence). The issues are different, across rows and tables and so this content changes across tables.

Because we need three different sequence numbers to cover interrogatories, requests for production, and requests for admission, we’ll need to repeat the sequence above two more times, each time using a different http://mywebspider.com as the Sequence Identifier (instead of using “int,” use “rfp” and “rfa,” for example).

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 want to make 300 numbered tickets for an event. The number on one side must match the number on the stub end that is given to the ticket holder. What is the best way to set up a document to do this without having to manually enter 300 numbers?

I could be totally off base here, but I seem to recall that the print merge feature (used it many times and it worked well on the Epilog) may or may not work on the driver for other lasers. I could almost be certain that someone mentioned that ability was removed from some manufacturers driver and that there is talk about fixing the issue so it can be back.

Does anyone know whether its possible to make Coreldraw (11) number objects within a file with consecutive numbers. It gets a bit tedious placing text and renumbering it incrementally manually when you’ve got 500 items to label!! I was looking for a shortcut, or perhaps a macro which can take the boredom out of the process. Any ideas?

I need 2 copies to be printed each time I print from a certain file. Is there any way to save this command so I don’t have to change the number of copies each time I print? Hi you could record a macro while doing this manually and assign a shortcut or button to this recorded macro — Regards Frank Kabel Frankfurt, Germany Hebert45 wrote: > I need 2 copies to be printed each time I print from a certain file. > Is there any way to save this command so I don’t have to change the > number of copies each time I print? …

I used multi-level lists for this sort of thing. When defining my list, I type “Interrogatory No.” before the number field in the number format definition, link it to a list style, 2nd level I type “Request for Production No”, link it to another list style. I’ll use “Answer” with no number as another level of the list. Then I modify the linked styles so the paragraphs are formatted how I need. In the styles linked to request for production and interrogatories, I will use the style linked to “Answer” as the style for the following paragraph. In the “answer” style, I’ll use Interrogatory as the style for following paragraph.

I’ve been given the task of numbering our blueprint files (.tif format). I need to add around 800 ballooned numbers to each drawing at specific locations. These are just numbers with a circle around it.

I have several xml files (SMS backup files) I am editing where I want to insert sequential numbering. The number in the id field shown in bold italics below has been replaced with a unique string to allow for a find and replace to be done sequentially giving, e.g. xml a) containing id’s 1 to 25, xml b) containing id’s 26 to 50, xml c) containing id’s 51 to 75 and so on.

Scott, I was able to try this as I assumed that is what I needed to do. It does not work. First, the current macro for that button is a Save Record, Close Window operation. How could I keep this and also add Code? If I just add a new button to the form and under the On Click Event put the code you suggested, I get a compile error of “method or data member not found” and ” .txtPROJECT” is highlighted. The actual field is “PROJECT ID#” and it is a long integer number. Entry I have is: Private Sub Command88_Click()

Hi Scott, Thank you for a very informative Blog. I am however stuck. I need to create a sequence for patient record cards based on their LastName. ie For names beginning with “A” =A001, then A002, For names beginning with “B =”B001, then B002 etc.

Please Note: This article is written for users of the following Microsoft Word versions: 97, 2000, 2002, and 2003. If you are using a later version (Word 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Word, click here: Sequentially Numbering Elements in Your Document.

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.

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.

For example, in our law practice, we submit briefs with hundreds of attachments. Those attachments are constantly being reorganized (thus renumbered) and we had to develop a scheme to keep each attachment (and reference to each attachment) organized and accurate. We created a master list of attachments, and captured the dynamic field code in a bookmark. We can then cross-reference to that bookmark (which will return a number) through our documents. Example Public Attachment 68 (where 68 represents a field sequence code, is captured in a bookmark we will call SR_112). The bookmark name is a code name supplied by the drafting lawyer. That way, when the lawyer refers throughout the document to Public Attachment ___, we insert a cross reference to bookmark SR_112, and it always returns an accurate number, even if we reorganize the order of our attachments.

You’ll need to merge two documents: the Publisher document, or ticket, and an Excel workbook that contains the numbers you want to use to number those tickets. Please don’t let the term mail merge intimidate you. Merging a Publisher document to generate sequential numbers is easy.

Is there any way I can get PS to do this automatically for me,so I either specify the starting number,or it actually takes the file name (minus the extension,so no JPEG etc after it)and adds this text to the watermark layer while I put the kettle on?

Use the Bullet or Number Position section of the New Paragraph Style dialog box to change the indent spacing. For example, to create a hanging indent, type 2p for Left Indent and ‑2p for First Line Indent.

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.

Scott, you’ll need to be more specific to help me. When you say “put this code behind a save button” what exactly does that mean – where do I type the code you provided? Yes, I do have a Save Button, which saves the record and closes the form (but currently has no way to save the next sequential Project ID). I want show this next Project ID (number on the entry form) and have that new number flow to the table along with the other data on the form.

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 strongly recommend that you read both of these before doing anything with the contents of this chapter.

Contributing author Mary Lester leverages her deep experience with storytelling, design excellence, multi-platform publishing, and technology-focused content to help leading-edge businesses meet the challenges of today’s rapidly changing media industry.

The first page of the index in my InDesign file (page “a”) begins on a left facing page in the document – but prints as a right facing page  (starts a new piece of paper).  This leaves a blank left-facing page before  Page A – and the rest of the index prints with odd pages on right and even pages on left.

“But what if I already have a long list of items that I want numbered.” OK, thanks to the power of Word macros, Word MVP Graham Mayor and I have put together a Word add-in that makes SEQ field list numbering as simple as ABC.

While I’m commenting, let me ask something…I have the pdf of the InDesgin Help on my computer and I adore the formatting. The whitespace and fonts are perfect and so eacy on the eye. Would it be possible for someone to please send me exactly what’s in that template so I don’t have to figure it out myself? Please pass on my compliments to the designer!

This application creates a data file that can be used with Indesigns Mail/data merge feature that easily allows for numbering raffle tickets and documents and even allows for numbering in multiple locations that is often needed on raffle tickets that require a numbered stud.

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/

Business Card Creator Mini Square Card Creator Tear Off Flyer Creator Greeting Card Creator Gift Certificates Brochure Creator Mini Brochure Creator Flyer/Postcard Creator Poster Creator 2016 Calendar Creator Letterhead Creator Circular Sticker Creator Notepad Creator Luggage Tag Creator Wedding Invitations

ULS X-2 660, Corel X3, Haas VF4, Graphtec vinyl cutter, Xenetech rotaries (3), Dahlgren Tables, Gorton P2-3, New Hermes pantographs (2), and recently, 24″ x 36″ chinese router. Also do sublimation, sand blasting, & metal photo. Engraver since 1975.

I’m making a research report on landscape design. The final document would have perhaps pages like 80-90 or so. Earlier I used to make reports and multipage documents on MS Word. While making the contents page, I would have to look at each and every chapter’s name, subheading and then add the page number manually. Is there any automatic system in InDesign?

However, there is a property we can use to get ourselves out of this problem and that is the AbsolutePosition property of the recordset. We can create a textbox, bind it to expression “=RowNumber()” and then create a function on the module behind the form that references the recordset:

Typically the second option of saving as a CSV file is the one to choose for use with Data Merge. Click the create button to choose a file name and location, make sure that a header has been assigned and click OK. This creates the CSV file that contains the sequential numbers that can then be used in a Data Merge by opening the Data Merge palette, clicking the flyout and clicking Select Data Source…

This plugin works equally well for new and established stores: if your WooCommerce site already has orders placed, the sequential order numbers will pick up from the last order number, or begin with the starting number you configure. It’s your choice!

That would be a job for Cross-References and Bookmarks. You would need to create a Bookmark containing the SEQ number, then reference it elsewhere with a Cross-Reference. See “Type Once, Repeat Many” for more details.

Not a chance—InDesign offers a number of improvements and surprises in the area of typesetting. It’s an evolutionary product—not a revolutionary one, but, on its release, InDesign became the best desktop typesetting program, and raised the bar for its competition.

Some drawbacks to this feature are that you lose a little control when you are typing. Word formats for you and some users do not like this. Also, on certain items, you will get a number when you do not expect or need one. For example, you have an attorney whose name begins with an initial (A. George Smith). When you type the name and press ENTER, the first initial “A.” converts to an automatic number.

I work with CorelDraw X5 and I wonder if there is a way to insert an application of page numbering that is automatic, which automatically update the page when I add or remove a page, as in the word.I got a number through the macros but the problem is the numbers are fixed and not change. And numeracy not appear on new pages.

The four templates with automatic serial numbering are quite nice and one of them will most likely be suitable for your needs. You can edit them as well. If you’re going to sequential numbering that, save the original template separately. Doing so will give you a fresh template, in case you need one.

On my website below (link at bottom), I have all my photos watermarked for obvious reasons,this is done by a normal batch convert action using CS2,the gallery is actually a modified Photoshop “Simple” type of thing.

I’ve described how to do this using Data Merge a number of times, including in post # 6 at I need to number 20,000 tickets in InDesign and have them in order when I cut them where I describe how to do it for stack-cut imposition without a plugin.

Well, you could do it with two lists (using the List feature). Or perhaps you could do it with cross-references, like this: http://indesignsecrets.com/synchronize-text-in-more-than-one-place-in-an-indesign-document.php

The script does have a list of its features on its website but unfortunately doesn’t feature a written how-to, and understanding some of the features can be a little confusing. So I’m taking it upon myself to explain it a bit.

If you’ve never used macros before, your copy of Excel may have macros turned off, even for .xlsm file types. To check, use the keyboard sequence ALT+T, M, S to get to macro settings in the Trust Center dialog box. If Disable All Macros without Notification is selected, choose Disable All Macros with Notification instead. If you use this option, Excel prompts you to enable macros each time you open a file that has them.

Patient number format is >L-999/99999 where L is the first letter of the last name, next 3 digits is the count of number of patients with the same first letter of last name and the last 5 digits is the total count of all patients at the time the patient was entered in the system.

Once you’ve gotten through all that (and, yes, I know, that was a lot of work) you can look forward to being able to simply type four letters and have Word automagically offer to do the rest of the typing for you:

In bulleted lists, each paragraph begins with a bullet character. In numbered lists, each paragraph begins with an expression that includes a number or letter and a separator such as a period or parenthesis. The numbers in a numbered list are updated automatically when you add or remove paragraphs in the list. You can change the type of bullet or numbering style, the separator, the font attributes and character styles, and the type and amount of indent spacing.

To recap, you use a DMax function to return the highest number in the Sequence and increment it by 1. You assign the incremented number to a control on your form and then immediately save the record. If your identifier includes additional information from the record, you use an expression that concatenates that information with the sequence number to display the full identifier.

You can use the same technique to restart a numbered list back at the first number as you did to continue with the previous list. In the Bullets and Numbering dialog box, choose Restart numbering, and then click OK.

I’m also concerned about your table design. You mentioned entering a First name. But I don’t really see that people names belong in a transaction record. Can you explain more about what you are tracking in your app and what these transactions are.

Enter the value you want to start with, and when you click OK, Word updates the numbers in the cells. You’ll also note that if you insert any rows in the middle of your numbered sequence, Word automatically adds a number to that inserted row.

Does anybody have a way of formatting the phone numbers in Outlook 2003 so that they appear as xxx yyy zzzz that is no dashes, no parentheses? If I am going to synch to my PDA I want the numbers as short as possible and, to me, as readable as possible. Steve No. Masking of phone numbers is hard coded and based on your default dialing location. — Russ Valentine [MVP-Outlook] “Steve E.” wrote in message news:2dd601c48eb8$3ff4a1e0$a601280a@phx.gbl… > Does anybody have a way of formatting the phone numbers in > Outlook 2003 so that they appear as x…

Scott can I please get more detail on how to do what you are talking about in the scenario 3 you described above as this is exactly what I am basically trying to do. I would like to explain in more detail what I have accomplished so far and what I am trying to do.

I have designed and printed a BLURB book in LR4 beta successfully. Although the color was somewhat streaked and blotchy, it wasn’t a bad effort, but it does need refinements. How I might add page numbers? Without page numbering, making a book greater than a few pages is not really acceptable.

A Sequence field tracks differently numbered lists within a document. Using different sequence fields can give you the ability to print a number of tickets on a page, make a stack of pages, cut the stack into tickets and have the tickets numbered sequentially.

The standard method for displaying a page number in InDesign is to insert an Automatic Page Number Marker into a text frame (Text menu: Insert Special Character: Marker: Current Page Number). This is typically done on your master page(s) so that the page number will appear on every page using that master. If you wish to hide the page number on pages in your document, just use a different master that does not include the marker (or use the “None” master if you do not wish to display any master page items).

3. Define Document Sequences: You enter a sequence Name and enter Oracle Cash Management as the Application that “owns” the sequence. You can also specify Effective From and To dates and the sequence numbering Type (Automatic, Gapless, or Manual).

3D Advisor Android Advisor Apple Advisor Broadband Advisor Business Advisor Laptops Advisor Photo & Video Advisor Printing Advisor Security Advisor Smart Home Advisor Smartphones Advisor Tablets Advisor Windows Advisor

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.

After the { SEQ € \r68}, insert just the { SEQ € } fields where you need them for the sequential numbering. If you copy and paste one of these fields, you’ll probably need to select in and press F9 to update it, or you could press Ctrl-A, F9 to update all fields in the document – useful if you’ve added/deleted one in an existing sequence or if you’re adding multiple such fields.

The problem here is that, when a user adds a new row/issue (in an existing or a new-similar table in the middle of the document), the numbering changes. and the following issues are then assigned n+1 http://mywebspider.com respectively. This is not expected and each issue, once assigned a number, should retain it irrelevant of row addition/deletion.

Under Advanced field properties, you should see the values highlighted below: the SEQ code, “int” as the Sequence Identifier, “* Arabic” for Arabic numerals, and “\n” to increment the numbers. Click OK to finish.

Thanks everyone for your time and comments. What I was hoping to avoid was having to render out every ticket inDesign before printing. Seems like that is unavoidable. I’ll try the way you folks have suggested, thanks again.

I have a large job for a client who uses antique computers. They are so old that he can’t run Lightroom. As a workaround, I posted the images I wanted him to look at on SmugMug and we had a disaster. Their sequencing on screen does not match my “as shot” sorting on my Lightroom (4). Is there a way I can print sequential serial numbers/ids on my images before I upload them to SmugMug so we are always talking about the same image?

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.

You may be tempted to place this number on a master page. That would make sense, but there’s a catch: Autonumbered paragraphs on a master page don’t update until you override them. That is, you have to Command/Ctrl-Shift-click on them to make them “kick in” and update to the correct number.

The data member not found message indicates you are using an invalid control name. This is what I was referring to before about making sure you use the correct object names. So you probably don’t have a control named txtPONum.

I replied to you on the Answers forum. Let’s continue there, but I need to know what you have done and what about is not working. Please reply there with details. But the blog instructions are pretty specific, if you follow them with the only changes substituting your actual field and control names, then it should work.

I don’t see how to start the numbering though. Say I want it to start at 1000 and count up from there. Then I don’t see what field I would put to continue to count up each time I place it in my document.

Of course, there are third-party solutions that are available for creating sequentially numbered labels. One that comes highly recommended by several WordTips subscribers is Bates Labels from Payne Consulting (http://www.thepaynegroup.com/products/bateslabel/). This product allows you to easily create as many labels as you need for a specific purpose.

If there are multiple instances of the NEXT VALUE FOR function specifying the same sequence http://mywebspider.com within a single Transact-SQL statement, all those instances return the same value for a given row processed by that Transact-SQL statement. This behavior is consistent with the ANSI standard.

Thank you so much for this! These instructions were perfect and clear, and I got it all done, except when I go to print. It prints out 1 per page. I have Word 2007, and tried printing out on letter size with 4 per page, but then it prints them all very tiny in the corners. Can you help me? Thanks 🙂

In the other tab for the PONum field, I typed in txtPONum as you had mentioned earlier. It is just not generating a number. I don’t even know what question to ask now, ’cause I do not know where this is going wrong. I’ll keep trying something…

Customize any level that you’d like and click OK to apply the numbering within your document. Article I should appear within the document since you added the word article before level 1 through customization.

I would like to set up a table of style numbers that starts at 1000 and continues on.  I don’t want to have to type each number in but would like for the number to automatically generate like a page number.  Is there a way to do this?

If you are thinking of using sequential numbering, please give our printing experts a call for helpful advice on how to best set up your artwork. We offer ready to use templates for the most common types of forms including invoice templates, statement templates, work order templates and purchase order templates. Just upload your logo and contact information and let us know how you would like to number your forms.

6. Set the Sequential Numbering System Profile Option: You or your System Administrator must enable sequential numbering for Cash Management. Use the System Profile Values window to set the Sequential Numbering profile option at the Application level. Choose Cash Management as the Application. Query the Sequential Numbering profile name. You can select from Always Used, Partially Used, or Not Used.

From the Type menu, select Insert Special Character>Markers>Current Page Number. On your Master Page, the numbering character will be the page prefix; A, B, C, etc. Style the character any way you like, including adding color or knocking it out of a shape. Add any other folio language you need, like an issue date, document name, or corporate URL.

Someone can correct me if I’m wrong, but I don’t think Illustrator is meant for that sort of thing. But, as someone who likes to use Illustrator all the time, it’s good to see if we can find a solution in it!

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

This requires no pre-knowledge of a primary key and only assumes that when you load the form initially, it is already sorted. Any records newly inserted will get the next bigger number. However, if you requery and it causes the newly inserted rows to be re-sorted, they will be now given a new number that relates to their actual position within the set, which can be either good or bad, depending on your specific requirements.

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.

This tip is great but it doesn’t tell me how to start w/a number other than 1. I need to create a sheet of numbered labels starting w/1702. No matter how I enter it the only number that changes sequentially is the 1st number so my second label is 2702

What I need the new LISP to do is append a space and then a number to the existing tag value in the block, so that the result would look like “ADDRESS: 1”, “ADDRESS: 2”, “ADDRESS 3” or “ELEVATION: 1″, ELEVATION: 2”, etc. depending on whatever the default value for the tag “ID” is.