Edit

OfficeDataSourceObject members (Office)

  • Article

Represents the mail merge data source in a mail merge operation.

Methods

Name Description
ApplyFilter Applies a filter to a mail merge data source to filter specified records meeting specified criteria.
Move Moves a record in a return set from an OfficeDataSourceObject object from one position to another.
Open Opens a table in an OfficeDataSourceObject object.
SetSortOrder Sets the sort order for mail merge data.

Properties

Name Description
Columns Gets an ODSOColumns object that represents the fields in a data source. Read-only.
ConnectString Gets or sets a String that represents the connection to the specified mail merge data source. Read/write.
DataSource Gets or sets a String that represents the name of the attached data source. Read/write.
Filters Gets the filter status for a OfficeDataSourceObject object. Read-only.
RowCount Gets a Long that represents the number of records in the specified data source. Read-only.
Table Gets a String that represents the name of the table within the data source file that contains the mail merge records. The returned value may be blank if the table name is unknown or not applicable to the current data source. Read-only.

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.