HeaderSourceType Property

Microsoft Word Visual Basic

Returns a value that indicates the way the header source is being supplied for the mail merge operation. Read-only WdMailMergeDataSource.

WdMailMergeDataSource can be one of these WdMailMergeDataSource constants.
wdMergeInfoFromAccessDDE *
wdMergeInfoFromMSQueryDDE *
wdMergeInfoFromODSO
wdNoMergeInfo
wdMergeInfoFromExcelDDE
wdMergeInfoFromODBC
wdMergeInfoFromWord

*

Security  Dynamic data exchange (DDE) is an older technology that is not secure. If possible, use a more secure alternative to DDE, such as object linking and embedding (OLE).

expression.HeaderSourceType

expression    Required. An expression that returns one of the objects in the Applies To list.

Example

This example opens the header source attached to the active document if the source is a Word document.

Dim mmdsTemp As MailMergeDataSource

Set mmdsTemp = ActiveDocument.MailMerge.DataSource

If mmdsTemp.HeaderSourceType = wdMergeInfoFromWord Then
    Documents.Open FileName:=mmdsTemp.HeaderSourceName
End If