How do I bypass the message: "A program is trying to automatically send e-mail on your behalf. Do you want to allow this?" This appears when I execute the folowing VBA code:
DoCmd.SendObject , , , "bcreen@American-services-inc.com", , , "Nightly-Run - Your attention is requested!", strMsg, False
strMsg is a message string for the body of the email.
THIS USED TO WORK FINE! I suspect a security patch (for Outlook) no longer allows this. There are 3rd-party "Outlook Security managers" available for purchase, which alegedly allow you to place a few lines of code into your VBA, to bypass this problem.
Is there a way to do this differently, without paying for a 3rd party solution?