Hi everybody,
Can anybody help me turning these lines below to access ODBC SQL source?
Dim myMerge As MailMerge
Dim LastRecord As Long
Dim myDoc As Object
Set myDoc = ActiveDocument
With myDoc.MailMerge
.MainDocumentType = wdFormLetters
.OpenDataSource Name:="D:\Data\Access\TestDB.mdb", _
LinkToSource:=True, AddToRecentFiles:=False, _
Connection:="TABLE Test"
End With
Can anybody help me turning these lines below to access ODBC SQL source?
Dim myMerge As MailMerge
Dim LastRecord As Long
Dim myDoc As Object
Set myDoc = ActiveDocument
With myDoc.MailMerge
.MainDocumentType = wdFormLetters
.OpenDataSource Name:="D:\Data\Access\TestDB.mdb", _
LinkToSource:=True, AddToRecentFiles:=False, _
Connection:="TABLE Test"
End With