I invoke MS Excel and MS Word 2013 from IBM Notes R9 to perform a mail merge to PDF. After the merge (and before creating the PDF) I need to run a macro on the merged data. I have the macro working. My problem is I cannot invoke it via lotusscript. It is in the Word Merge Template and also in Normal.dotm.
I get errors like
Instance member SHADE does not exist
Instance member MODULE1 does not exist
Microsoft Word: 'Run' is not a property.
depending on how I attempt to invoke it.
If I invoke manually it works fine.