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