I tested the code here. No errors. Although it creates an email here, it doesn't go anywhere when I send it. The code is simply going through the motions.

What I have found on my machine is an email macro must refer to Outlook in order for it to actually be sent from my computer to my email carrier.

I wonder what is the difference between your computer there and all the others where the macro works ? If it functions on all the others except yours - that must be the culprit but I am at a loss of where to advise to start looking.

Again, I can not replicate the error you see, here on my computer.

Sorry.