PasteMergeFromXL Property
True to merge table formatting when pasting from Microsoft Excel. Read/write Boolean.
expression.PasteMergeFromXL
expression Required. An expression that returns one of the objects in the Applies To list.
Example
This example sets Microsoft Word to automatically merge table formatting when pasting Excel tables if the option has been disabled.
Sub AdjustExcelFormatting()
With Options
If .PasteMergeFromXL = False Then
.PasteMergeFromXL = True
End If
End With
End Sub