Comments on Helen Bradley - MS Office Tips, Tricks and Tutorials: Autonumber a series of Word documents

I tried your macro for automatically numbering a d...

2009-01-24T17:42:00.000-08:00

I tried your macro for automatically numbering a document. However, each time I try to use it, I get an error message and the macro comes up to debug. What am I doing wrong?

Jerry

I am trying to create a sequential numbering macro...

2008-10-13T14:51:00.000-07:00

I am trying to create a sequential numbering macro for a work order form. I want it to display the document number but I don't want anyone to be able to edit the number itself. If I try and protect the document every vb code I have used will not run the macro. It tells me that it can't run in a protected area of the document. Any help on this would be greatly appreciated.

Excellent documentation!!!Keep on going :)

2008-09-18T15:17:00.000-07:00

Excellent documentation!!!
Keep on going :)

Thanks for the great tip! I was able to create my ...

2008-04-17T07:35:00.000-07:00

Thanks for the great tip! I was able to create my autonumbering document with your directions. But, you have typed "docnumb", which should be "docNum" correct?. Also, for those not familiar with visual basic, it would be helpful to show the entire final programming script, as I had difficulty figuring out how that last bit of programing fit into the final script. It was hit and miss for a bit. Thanks again!

I would like to make a Purchase Order form with tw...

2008-01-24T06:57:00.000-08:00

I would like to make a Purchase Order form with two copies per page that both have different numbers. How can I make two different macros that run similar functions on the page?

Thanks for the autonumber, but have one request. H...

2007-11-29T10:56:00.000-08:00

Thanks for the autonumber, but have one request. How can I add to the macro a style change (the numbers need to be style as page number)

thanks

In this case Microsoft Word is probably your best ...

2007-04-16T20:36:00.000-07:00

In this case Microsoft Word is probably your best option as it has a built in tool for creating labels. To do this, launch Word and choose Tools, Letters and Mailings, Envelopes and Labels and click the Labels tab. Click Options to open the Label Options dialog and select the label type to use. Click Ok. Enable the full page of the same label option and click New Document to create a set of labels in a brand new document.

To add your numbers type the word Label and space, and then choose Insert, Field, from the Categories list choose Numbering and from the Field Name list choose SEQ. After the field code SEQ type mynum (or a single word identifier for your sequence). Press the spacebar once, click Options, click the Field Specific Switches tab, select the \r switch and click Add to Field. After the \r entry in the Field Codes area type the number 1 as the starting number for your sequence and click Ok and Ok again.

Back in the document select the next label and click where the label number should appear. Type the word Label and press space. This time choose Insert, Field and choose the Numbering option from the Category list and the SEQ option from the Field Names list. After the word SEQ type the identifier mynum (or the identifier that you used previously). Tap the spacebar, click Options, click the Field Specific Switches tab, click the \n option and click Add to field and then click Ok twice.

You can now copy and paste this second field code into each of the labels on the page. To update the label numbering, choose Edit, Select All and press the F9 key. You’ll now have a series of sequentially numbered labels. At any time you can alter the first field code by changing the number after the \r option to start at a new number thus giving you a sequential series of labels from a single saved document. To change the field code, click on it, press Shift + F9, change the value, press Shift + F9 again then select the entire document and press F9 to update it.

I would like to create a series of file labels wit...

2007-04-11T10:36:00.000-07:00

I would like to create a series of file labels with consecutive numbers as in "Label 1", "Label 2" etc. How can this be done in Word or Excel?
Ken