(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:

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 *