IsDataSourceConnected Property

Microsoft Publisher Visual Basic

Show All Show All

IsDataSourceConnected Property

True if the specified publication is connected to a data source. Read-only.

expression.IsDataSourceConnected

expression    Required. An expression that returns one of the objects in the Applies To list.

Remarks

A publication must be connected to a valid data source to perform a mail merge or catalog merge.

Example

The following example tests whether the publication is connected to a data source and, if it is not, specifies and connects a data source to the publication. (Note that PathToFile must be replaced with a valid file path, and TableName with a valid data source table name, for this example to execute properly.)

    Dim strDataSource As String
Dim strDataSourceTable As String

    'Specify data source and table name
    
    strDataSource = "PathToFile"
    strDataSourceTable = "TableName"
    
    'Connect to a datasource
    If Not (ThisDocument.IsDataSourceConnected) Then
        ThisDocument.MailMerge.OpenDataSource strDataSource, , strDataSourceTable

    End If