MailMergeDataSource$()

Syntax

MailMergeDataSource$(Type)

Remarks

Returns information about the data or header source, the means of data retrieval, or the current connection or query string.

Type

Values and descriptions

0

The path and filename of the data source

1

The path and filename of the header source

2

A number, returned as text, indicating how data is being supplied for the mail-merge operation:

0 From a Word document or through a Word file converter

1 Dynamic data exchange (DDE) from Microsoft Access (Windows only)

2 DDE from Microsoft Excel

3 DDE from Microsoft Query (Windows only)

4 Open database connectivity (ODBC) (Windows only)

3

A number, returned as text, indicating how the header source is being supplied for the mail-merge operation. See values and descriptions for Type 2.


Type

Values and descriptions

4

The connection string for the data source

5

The query string (SQL statement)


See Also

MailMergeCreateDataSource, MailMergeEditDataSource, MailMergeOpenDataSource