I've recently noticed in release 1.3 that if a spreadsheet includes a value of NOW() or TODAY() or probably anything with a dynamic value, it displays a (hidden) prompt for save dialog when the Create Mail Merge script terminates, and the Excel process remains active in the background.
In the Create Mail Merge script:
MergeXLSpreadsheet.New() calls varXLApp.Workbooks.Open strXLFilename, 0, readOnly to open the file in read-only mode, but that doesn't seem to be sufficient.
MergeXLSpreadsheet.Delete() simply calls varXLApp.Quit()
I'll need to investigate either:
-
how to quit without prompting for save, or,
-
how to open without any value auto-calculation.