Did anyone ever have / solve the problem where Excel becomes unstable and "buggy" after you run a macro that uses CDO Message to send an email? I saw other posts but never a solution.
My code worked fine under Win Vista and Excel versions so it's not an obvious bug in the code, but when I run the code under Win 10 and Excel 2016 (MSO 16.0.8625.2121, 32 bit), the code works and sends the email but then Excel becomes "unstable and pretty much locks up" and I have to close all open Excel files and reopen Excel to clear the bug. The code is generic and similar to the examples here using remote server and authentication: http://www.paulsadowski.com/wsh/cdo.htm).
Any others having this problem? Any help greatly appreciated, tx. Joe
My code worked fine under Win Vista and Excel versions so it's not an obvious bug in the code, but when I run the code under Win 10 and Excel 2016 (MSO 16.0.8625.2121, 32 bit), the code works and sends the email but then Excel becomes "unstable and pretty much locks up" and I have to close all open Excel files and reopen Excel to clear the bug. The code is generic and similar to the examples here using remote server and authentication: http://www.paulsadowski.com/wsh/cdo.htm).
Any others having this problem? Any help greatly appreciated, tx. Joe