MailMergeQueryOptions

Syntax

MailMergeQueryOptions .SQLStatement = text [, .SQLStatement1 = text]

Remarks

Specifies the query options for a mail merge. You can use MailMergeQueryOptions to change the query options established with a MailMergeCreateDataSource or MailMergeOpenDataSource instruction. If the active document is not a main document, an error occurs.

Argument

Explanation

.SQLStatement

An optional query string that retrieves a subset of the data in a primary data source.

.SQLStatement1

If the string is longer than 255 characters, .SQLStatement specifies the first portion of the string and .SQLStatement1 specifies the second portion.


Note

To determine the query string, set query options manually, and then use MailMergeDataSource$() to return the string.

See Also

MailMergeCreateDataSource, MailMergeDataSource$(), MailMergeOpenDataSource