Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Document.IsDataSourceConnected Property

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

Syntax

expression.IsDataSourceConnected

expression   A variable that represents an Document object.

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.

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



Community Additions

ADD
Show:
© 2015 Microsoft