Connecting Word with Access and MailMerge : MailMerge « Outlook « VBA / Excel / Access / Word






Connecting Word with Access and MailMerge

 

Sub MailmergeLetter()
   Dim myLetter As Document
   Documents.Open FileName:="C:\Letter.doc"
   Set myLetter = Documents("Letter.doc")

   myLetter.MailMerge.OpenDataSource Name:="C:\store.mdb", Connection:="TABLE Employees"
End Sub

 








Related examples in the same category

1.Merge to a new document and use only records 1 to 3