Roland Hoelscher
New Member
- Joined
- Oct 15, 2022
- Messages
- 12
- Office Version
- 365
- Platform
- Windows
I want to develop an Excel VBA which sends emails using MS Outlook. I basically have a prototype that works (using early binding, I added the reference to MS Outlook, using GetObject, etc.)
When I run the VBA I get a warning message from Outlook which says "A program is trying to send an email message on your behalf . . ." Is there any way to eliminate that warning without changing the Outlook Trust Center settings? In my corporate environment I don't have permissions to change the corresponding Trust Center setting. If my Excel VBA solution needs to send hundreds of emails each time I run the VBA, then clicking on "Allow" in the Outlook warning message is not a feasible solution. Any way I can eliminate or bypass that Outlook warning?
When I run the VBA I get a warning message from Outlook which says "A program is trying to send an email message on your behalf . . ." Is there any way to eliminate that warning without changing the Outlook Trust Center settings? In my corporate environment I don't have permissions to change the corresponding Trust Center setting. If my Excel VBA solution needs to send hundreds of emails each time I run the VBA, then clicking on "Allow" in the Outlook warning message is not a feasible solution. Any way I can eliminate or bypass that Outlook warning?