Hello! I have built a macro to generate and send invoices using the full Microsoft Office Suite and VBA. Cover letters are generated using Word and MergeMail. It's working pretty smoothly except when the macro opens the template mail in Word, it always ask to select the table from Excel. I would really like to get my program to OK this step automatically. Any suggestion?
Set docMail = wrdApp.ActiveDocument
With docMail.MailMerge
.MainDocumentType = wdCatalog
.OpenDataSource Name:="Y:\Accounts\Credit Control\CreditControlSystem.xls", _
ReadOnly:=True, _
Connection:="aaSummary"
This is where i get stopped to OK the table selection.
Set docMail = wrdApp.ActiveDocument
With docMail.MailMerge
.MainDocumentType = wdCatalog
.OpenDataSource Name:="Y:\Accounts\Credit Control\CreditControlSystem.xls", _
ReadOnly:=True, _
Connection:="aaSummary"
This is where i get stopped to OK the table selection.
