(Solved) – Excel freezes after using macro that sends email using Collaboration Data Objects

(solved)-–-excel-freezes-after-using-macro-that-sends-email-using-collaboration-data-objects

I use a macro to send out emails, I am using this approach:
http://learnexcelmacro.com/wp/2011/12/how-to-send-an-email-using-excel-macro-from-gmail-or-yahoo/

Everything works fine, except that after the email is sent Excel will freeze. It is only the things that are visible in the document that are “frozen”. If I scroll down or switch sheet, it will update the screen.

For example if I delete a row, it will delete the row but not show it on the screen. If I switch to another sheet and back again, it will show the row has been deleted.

Is this some kind of memory problem or what can cause this?

I am using the latest version of Windows 10 (1903 i believe) and latest version of MS Excel.

Leave a Reply

Your email address will not be published. Required fields are marked *