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 »
If the second number on your raffle ticket is one higher than the first number, you must have accidentally put the <> tag after the first number (causing the next number, on the same ticket, to increase by one). You only need the <> after the second number on each ticket, so the next ticket gets a new number. (But you don’t need it on the final ticket on the **page**, because the next **page** automatically gets a new number)
WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (1492) applies to Microsoft Word 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Word (Word 2007 and later) here: Sequentially Numbered Labels.
Note The following examples are based on the pubs database. By default, the Northwind sample database and the pubs sample database are not installed in SQL Server 2005. These databases can be downloaded from the Microsoft Download Center. For more information, visit the following Microsoft Web site:
If you work in a business where you need to sequentially number items, you might be wondering if there is a way you can use Word to create the labels for you. Word has many ways you can implement some type of numbering in your documents. For instance, you can use different fields for numbering, or use numbered lists, the captioning feature, or you can use mail merging. While all of these features (and more) use some type of numbering in them, they are not all well suited to creating labels.
I have tried creating a new style to apply to this cell (which is linked to a multilevel list so that it increments sequentially), so that whenever a new issue is created, users can apply the style to this particular cell. In the end, sequential numbering in coreldraw generate the custom TOC with just this style to get the list of issues.
I am on a project of making 12,500 tickets and so far, I’m at 500 out of 12,500 .. I was just wondering if Photoshop or other Adobe programs can Add Sequential Numbers on a particular area ON a picture,
Please Note: This article is written for users of the following Microsoft Word versions: 2007, 2010, and 2013. If you are using an earlier version (Word 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Word, click here: Sequentially Numbered Labels.
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.
Click Customize. Level 1 should be selected. If not, select level 1 from the Level area. Figure 4 shows the Customize Outline Numbered List that is used to change number formatting, such as indents, tabs, and numbering styles.
This is a discussion on Sequential Numbering in a Word document within the Microsoft Office support forums, part of the Tech Support Forum category. I would like to add a field in a word document that will start at a certain number and count
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.
Warning Some people like to use BACKSPACE to remove numbering. This method does remove the number but leaves the cursor indented to whichever level you happened to be in, especially in Outline Numbered paragraphs. The two methods mentioned above will remove the number and restore your cursor to the left margin.
If you don’t want to use one of the existing bullet characters, you can add other bullet characters to the Bullet Character grid. A bullet character that is available in one font may not be available in another font. You can choose whether the font is remembered with any bullet character you add.
Your selection is already displayed in the text box on the right and Formatted text is already selected. In the Replace text box, type 1] (Why ‘1]’? Because you’re unlikely to use this sequence of characters in normal writing, and because it’s what David Knopf suggested back in his original article — and why change something that works?)
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.
John, Sorry for the delay, but I was away last week with limited Internet access. I assumed if you had a Save button, you would know how to put code behind it. To see the code behind a button, Select the button in Form Design Mode and open the Properties Dialog (Right click and select properties), on the Events tab there should be something in the On Click event of the button. If you click the Ellipses […] next to the event, it will open Code Builder where you can enter the code.
The Insert Sequence Number utility of Kutools for Excel can help you customize and insert sequence numbers in contiguous cells, non-contiguous ranges of active worksheet, different worksheets, and different workbooks.
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.”
Indeed, CorelDRAW’s Printmerge will do exactly what you want without an external data file. Tell it to start at 65 and end @ 131 (no I didn’t misread your example, that’s a tiny “gotcha” in the Printmerge function that has been there since Corel 10 and never fixed).
After doing all the post processing of my RAW file and saving as JPEG, the dialog changes the file number to one that has been used before and asks if I want to replace it. It is usually a number a few back. I have to manually change the number to match the original. Sure slows things down and if I’m not vigilant could end up overighting a file.
I’m struggling with this as well. I tried creating a .txt file of sequential numbers 1-99 from Excel and brought it in as a datamerge. My tickets are 8″x3″, 3-up, but when I did the merge, InDesign added 3,416 pages. Where the Hell is THAT coming from?? Any clue what I’m doing wrong? I’m using a tutorial that is using CS5, but I don’t see how that has anything to do with all those bloody pages.
Daniel: InDesign doesn’t really do sequential numbering by itself… well, it does, but only through the paragraph numbering feature. You might be able to get it to work for serial numbers: http://indesignsecrets.com/figure-numbering-in-indesign-and-cross-references-to-them.php
I have been generating 150-400 page reports with multiple lists in tables. Word’s auto numbering would only go so far in applying sequential numbering but then it just stops and I could not use it any more. I had to manually type in the numbered list which was quite annoying and very time consuming. Then I came across your Word Tip. Awesome! It worked. Thanks so very much.
There is very simple solution that we use and that is to lay out the sheet say 6 up on a A4 sheet as a master page and in document setup set the number of pages to 1,000 if that is the amount you require. Put a page number on each ticket on the page and although they will all have the same number on each page, we put the the first two letters of the customers business name before each number followed by the letters of the alphabet so it then reads for example BT1A, BT2A, BT3A, BT1B, BT2B, BT2C and so on as each page is printed.
Unlike other Microsoft Office programs, Excel does not provide a button to number data automatically. But, you can easily add sequential numbers to rows of data by dragging the fill handle to fill a column with a series of numbers or by using the ROW function.
Numbering in Microsoft Word is broken, sort of. It has been for many years. (It is actually better now than it has been.) By attaching it to Styles, you can tame it. This is not fair; it is not easy; but, it isn’t rocket science and it can be done.
Note All of the controls in the dialog box are either blank or grayed out because by default, the font formatting of the number follows the font formatting of the text that comes after-unless you explicitly declare exceptions as in the next step.