Access.2007.VBA.Bibl..

(John Hannent) #1
TABLE 6.1 (continued)
Method Advantages Disadvantages

TypeText No advance preparation of any kind Suitable only for very simple documents,
is needed; this method works with a such as mailing labels or tabular lists.
document created from the default Word
template, or a default labels document.

There is no link to the Access database,
so documents can be opened even on
another computer.
Mail Merge Suitable for merging very large numbers Customization of individual records is
of records, too large to create an difficult, because all data is merged to a
individual document for each record. single document.

Creating a mail merge labels document is
more complex than creating a labels
document for use with the TypeText method.

You can work with Word 97/2003 documents in Word 2007, as well as create new doc-
uments in the new Word 2007 format, so you don’t need to redo all your templates just
to get them to work in Office 2007. Some of the templates used for Word merge in the sample Word
Export database are in Word 2007 format, and others are in Word 97/2003 format. The extensions
differ for these two formats; new documents have the .docx extension, and new templates have the
.dotx extension, whereas older ones have the .doc or .dot extensions, as shown in Figure 6.8. When
you open a document or template in the older format, the title bar says “(Compatibility Mode)” after
the file name.

The new Type column in the Windows Vista Explorer shows the contents of a Word 2007
document’s Keywords field, so you can use this built-in Word property to display rele-
vant information in the Explorer.

Working with Word Document Properties ....................................................

In previous versions of Word, document properties were accessed in a straightforward manner,
through the Properties dialog, opened from the File menu. The process is now more complicated;
in Word 2007 you click the Office button, select Prepare, and then Properties (see Figure 6.9).

TIPTIP


NOTENOTE


Part II Writing VBA Code to Exchange Data between Office Components

Free download pdf