FIGURE 6.23
An Avery 5161 mailing labels merge document filled with Access data.Lists
The Word Catalog-type merge is very useful for producing lists of merged data. Selecting the
Contact List (Mail Merge) document (this is a Word 97/2003 document, used in Compatibility
mode) from the Select Document combo box on frmMergeToWord creates a list in tabular form,
shown in Figure 6.24.Documents
You can use mail merge to create a merge document, where each page displays data from one con-
tact record. I prefer to use the document properties or bookmarks method, in order to have a sepa-
rate document for each contact, but if you have many hundreds (or thousands) of documents to
generate, this is not practical. The Contact Letters (Mail Merge) selection in the Select Document
combo box creates a mail merge document with a letter on each page; Figure 6.25 shows one page
of this merge document.Part II Writing VBA Code to Exchange Data between Office Components