Don't get framed

Labels: Fields, Tips, Tutorials

If it's broke, fix it

Labels: Fields, General, Reference, Tips

Enter once — use again

Labels: Fields, Reference, Tips, Tutorials

Tiny code snippets

Microsoft has included a number of code pieces that you can use without having to haul out the VBA editor. These codes handle such things as page numbers, Table of Contents, Merge data and more.

"Some 80-plus fields are built into Word that provide information about the file and the user; store, display, and manipulate reference information; and link the document to other applications - all without a bit of code."

Automate Word Documents with Minimal Code
By Cindy Meister


Cindy Meister is a Word MVP.

She also works with bobbin-lace. Here is a sample of a Honiton lace butterfly.

Also:

AddBalance.com:
Using { Fields } in Microsoft Word

GMayor.com
Formatting Word Fields with Switches

Labels: Fields, Tips, Tutorials

Budget0056.doc

"Sometimes, when working on a project, you may want to save your documents in sequential order (for example, "0001", "0002", "0003", and so on).

If you wanted to do this manually, you would need to sort through your working directory for the latest file number before you could assign the next number to a new file.

Using this fairly straightforward Word macro, you can make creating sequenced files as easy as pressing a button."

LogicalExpressions.com:

Save sequential number docs
(Kevin Christy)

Also see:

Autonumber Invoices



See all Topics
word

Labels: Customize, Fields, Formatting, Tips, VBA

Creating sequentially numbered documents

In the template from which you create the document, insert a bookmark named Order in the location where you want the sequential number to appear and create an AutoNew macro, as follows:

Sub AutoNew()
Order = System.PrivateProfileString("C:\Settings.Txt", "MacroSettings", "Order")
If Order = "" Then
  Order = 1
Else
  Order = Order + 1
End If
System.PrivateProfileString("C:\Settings.txt", "MacroSettings", "Order") = Order
ActiveDocument.Bookmarks("Order").Range.InsertBefore Format(Order, "00#")
ActiveDocument.SaveAs FileName:="path" & Format(Order, "00#")
End Sub 

If you do not need to display the number in the document, but just want to save it with a sequential number, there is no need to create the bookmark in the template and you should then delete the second last line of the code.

Article contributed by Doug Robbins
Word MVP Site

Microsoft Knowledgebase:
Macro to Increment Invoice Number to New Form Document

WordTips:
Sequentially numbered Labels

Here's a further discussion including methods to create sequential ticket numbers:

Here's the PDF version:
Word Field Codes Revealed



See all Topics
word

Labels: Documents, Fields, Formatting, Tutorials

Order!

1. Make a list of the important words.
   
2. Create a two-column table in a new document.
   
3. In the first column, enter the word or phrase.
   
4. In the second column, enter the index entry
   (If you need a sub-category, type the main entry followed by a colon (:) and then the sub category.)
   
5. Save the file.

When it comes time to create the Index, place the insertion point, go to Insert>Reference Index and Tables. Choose Index and then AutoMark.
(2007 – Reference Tab>Index group)

Browse to the location of your Index file.

Word will now automatically use your list to mark the main document and insert an Index.

Also:

Word for Word:
An Index or a Concordance for Your Book?

Word MVPS.org:
How can I automatically generate an index in Word?

Microsoft KB:
How to create a table of contents and index with field codes in Word



See all Topics
word

Labels: Fields, Inserts, Lists, Reference, Tips, Tutorials

Custom content

• The curly brackets { } cannot be entered from the key board. Either use Insert>Field, or Ctrl+F9.
  
• Word uses spaces in the If..Then..Else statement.
  
• The last two quote marks "" are "empty" , so nothing will be entered.
  
• Notice the \\ in the path statement. A path is not needed if the Main document is in the same folder as the letters.
  
• To see the field codes, use Alt+F9 to toggle the view on and off.

Letters 1 and 2 can have completely different texts, formats and layouts. One can be an invitation to a sale, the other can be a dunning letter.
(To carry over different formatting, leave out the \* MERGEFORMAT switch)

After setting up the main document for mail merging, insert all of the fields you want to merge.

Copy the individual fields and paste them in the correct locations in Letter 1 and 2.

Go back to the main document and erase all of the text and fields EXCEPT for the IF statements.

Letters 1 and 2 do not have to be set up a merge docs, or connected to a data source. Their text will be inserted in the Main document depending on the field type.

Labels: Documents, Fields, Merge, Tutorials

More to come

You can place the word "More" or "Continued" at the bottom of every page except the last one.
The field, for those of you who know how to use them is:

{ IF { PAGE } = { NUMPAGES } "" "more" }

You can't just type in the brackets, you must use Insert>Field or Ctrl+F9.

For step by step instructions, go to:
How to Control the Page Numbering in a Word Document on TechTrax

There is a more sophisticated formula on WordTips On Line

{ IF { PAGE } < { NUMPAGES } "Continued on page {={PAGE} + 1}" "Last Page"}

Also see the Word MVP site
How to control the page numbering in a Word document

Here's a previous reference to page numbers:
Don't get framed



See all Topics
word

Labels: Fields, Inserts

Cardinal numbers

Word can format numbers in several ways when they are represented by field codes. The DollarText field code is one choice.

Press Ctrl-F9 to insert a pair of field-code delimiters, which resemble boldface curly brackets {}. (The brackets can not be entered directly from the keyboard).

Between the field-code delimiters, enter = followed by the number. Then append the DollarText field switch. The result should look like this:

{ =34,582.13 \*DollarText \*Firstcap }

There are spaces in the field. Here is how it should be entered:

{space=34,582.13space\*DollarTextspace\*Firstcapspace}

Right-click on the field and choose Update Field. You should now see the number spelled out in words:

Thirty-four thousand five hundred eighty-two dollars and 13/100.

Word provides some other numeric field codes. Here are a few of the more useful ones:

{ =42 \*CardText } - forty-two
(Spell our page numbers with a fields like this { PAGE \*CardText \*Caps } )

{ =42 \*OrdText } - forty-second

{ =42 \*Ordinal } - 42nd

{ =42 \*ROMAN } - XLII

KB article:

How to Use DollarText to Convert Numbers to Cardinal Text - 173287

and:

Microsoft Word - General Switches for Field Codes

For Access see:
Access - Numbers to Words

To create Cardinal numbers in Excel see:
Excel - Numbers to Words



See all Topics
word

Labels: Fields

MacroButton

[Click here and type Name]

1. Place the Insertion point in the document where you want the field.
   
   
2. Hit Ctrl+F9 to create field brackets {}.
   (they can not be just typed in)
   
   
3. Between the brackets type:
   
   

   {MACROBUTTON NoMacro [Click here and type junk]}

   
   

4. Press Alt+F9 and the field code will disappear.

Labels: Fields