We have been VBA code to send emails using Smtp service but somehow Microsoft is treating it as spam and unable to receive it anymore.
So we have started using outlook app for sending email instead as mentioned in this thread (https://answers.microsoft.com/en-us/msoffice/forum/all/use-excel-vba-in-office-365-to-send-automated-e/f6b2042b-a17e-4aa4-99ea-f647b82cc8fd?page=2).
The problem with this approach is that outlook has to be opened/running. If not they just sit in outbox and keep wait until we open outlook. Is this an expected behavior and are there any other alternatives in VBA?
So we have started using outlook app for sending email instead as mentioned in this thread (https://answers.microsoft.com/en-us/msoffice/forum/all/use-excel-vba-in-office-365-to-send-automated-e/f6b2042b-a17e-4aa4-99ea-f647b82cc8fd?page=2).
Nash1511 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
2