Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Gets or sets a String that represents the connection to the specified mail merge data source. Read/write.
Syntax
expression.ConnectString
expression A variable that represents an OfficeDataSourceObject object.
Example
This example checks if the connection string contains the characters ODSOOutlook and displays a message accordingly.
Sub VerifyCorrectDataSource()
Dim appOffice As OfficeDataSourceObject
Set appOffice = Application.OfficeDataSourceObject
appOffice.Open bstrConnect:="DRIVER=SQL Server;SERVER=ServerName;" & _
"UID=user;PWD=;DATABASE=Northwind", bstrTable:="Employees"
If InStr(appOffice.ConnectString, "ODSOOutlook") > 0 Then
MsgBox "Your Outlook address book is used as the data source."
Else
MsgBox "Your Outlook address book is not used as the data source."
End If
End Sub
See also
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.