HKFuey
asked on
MSAccess VBA email error
Getting run time error: STARTTLS is required to send mail.
Using office365.com
Using CreateObject("CDO.Message"). Was working a few weeks ago.
ASKER
Yes, I came across that article and tried the changes but it did not work.
I think Microsoft changed something in 365:
https://docs.microsoft.com/en-us/microsoft-365/compliance/exchange-online-uses-tls-to-secure-email-connections?view=o365-worldwide
I think Microsoft changed something in 365:
https://docs.microsoft.com/en-us/microsoft-365/compliance/exchange-online-uses-tls-to-secure-email-connections?view=o365-worldwide
and in addition:
https://docs.microsoft.com/en-us/deployoffice/endofsupport/microsoft-365-services-connectivity
Microsoft is also moving to remove basic authentication. That seems to be a moving target, and they will allow it for SMTP services, but everything else needs to be moved to oAuth2.
Jim.
https://docs.microsoft.com/en-us/deployoffice/endofsupport/microsoft-365-services-connectivity
Microsoft is also moving to remove basic authentication. That seems to be a moving target, and they will allow it for SMTP services, but everything else needs to be moved to oAuth2.
Jim.
and FYI, Microsoft is going to break a lot of eggs trying to make an omelet in the name of security.
Apps all over are going to break with these changes.
Jim.
Apps all over are going to break with these changes.
Jim.
ASKER
Great :(
I assume I can still send mail through the outlook app from Access?
I have a lot of stuff to change....
I assume I can still send mail through the outlook app from Access?
I have a lot of stuff to change....
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
with TLSUSESSL
https://www.tachytelic.net/2018/12/email-vbscript-vba-office-365/