In our last episode.... I had written
Cleared up the PasteSpecial issues I was having. Added some checks that the temp .htm file was created and that the publish() method worked before trying to send email. Attached is modified working script and sample excel file. If someone could test the script with Outlook I would appreciate it.
Files are attached