EditDataSource Method

Applies To

MailMerge object.

Description

Opens or switches to the mail merge data source.

Syntax

expression.EditDataSource

expression Required. An expression that returns a MailMerge object.

Remarks

If the data source is a Word document, this method opens the data source (or activates the data source if it's already open).

If Word is accessing the data through dynamic data exchange (DDE) — using an application such as Microsoft Excel or Microsoft Access — this method displays the data source in that application.

If Word is accessing the data through open database connectivity (ODBC) (Windows only), this method displays the data in a Word document. Note that if Microsoft Query is installed, a message appears, providing the option to display Microsoft Query instead of converting data.

See Also

OpenDataSource method.

Example

This example opens or activates the data source attached to the document named "Sales.doc."

Documents("Sales.doc").MailMerge.EditDataSource

This example opens or activates the attached data source if the data source is a Word document.

Set myDataSource = ActiveDocument.MailMerge.DataSource
If myDataSource.Type = wdMergeInfoFromWord Then
    ActiveDocument.MailMerge.EditDataSource
End If