views:

85

answers:

0

How to close excel opened by Word mail merge macro?

With ActiveDocument.MailMerge
.MainDocumentType = wdCatalog
Connection:="Entire spreadsheet", SubType:=8, ReadOnly:=True
.Destination = wdSendToNewDocument
.Execute
End With 'Activedocument
DDETerminateAll