ODSOColumn object (Office)
Represents a field in a data source. The ODSOColumn object is a member of the ODSOColumns collection.
Remarks
The ODSOColumns collection includes all the data fields in a mail merge data source (for example, Name, Address, and City).
You cannot add fields to the ODSOColumns collection. All data fields in a data source are automatically included in the ODSOColumns collection.
Use Columns(index), where index is the data field name or index number, to return a single ODSOColumn object. The index number represents the position of the data field in the mail merge data source.
Example
This example retrieves the name and value of the first field of the first record in the data source attached to the active publication.
Sub GetDataFromSource()
Dim appOffice As OfficeDataSourceObject
Set appOffice = Application.OfficeDataSourceObject
appOffice.Open bstrConnect:="DRIVER=SQL Server;SERVER=ServerName;" & _
"UID=user;PWD=;DATABASE=Northwind", bstrTable:="Employees"
With appOffice.Columns
MsgBox "Field Name: " & .Item(1).Name & vbLf & _
"Value: " & .Item(1).Value
End With
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.
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for