Excel VBA Email Send Fix

My Excel workbook contains a VBA routine that automatically composes and sends an Outlook email. Recently, without any edits to the file, the macro began throwing Run-Time error ‘-2147467259 (80004005)’ the moment it reaches .Send. If I swap .Send for .Display, the message opens perfectly—confirming the body, attachments, and recipients are fine—but of course it never gets dispatched. Trying .[login to view URL] shifts the error to ‘424’. The failure appeared suddenly; I did not push updates or change references. I work with Outlook as the mail client, and I’m unsure whether an antivirus or other security layer is blocking MAPI calls, so please consider that angle while investigating. What I need from you: locate the root cause of the .Send blockage, adjust the VBA so the email sends reliably again, and give me any quick setup tweaks (trust settings, library references, or programmatic access steps) I must apply on my side. A clean, annotated code snippet that drops into my existing module and a brief explanation of the fix will be the final deliverable.

Project ID: 40413645