This documentation is archived and is not being maintained.

Document.IsDataSourceConnected Property

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



expression   A variable that represents an Document object.


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


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.

Before running this example, you must replace PathToFile with a valid file path and TableName with a valid data source table name.

Visual Basic for Applications
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