Link to home
Start Free TrialLog in
Avatar of HKFuey
HKFueyFlag for United Kingdom of Great Britain and Northern Ireland

asked on

MSAccess VBA email error

Getting run time error: STARTTLS is required to send mail.

Using office365.com

User generated imageUsing CreateObject("CDO.Message"). Was working a few weeks ago.

Avatar of M A
M A
Flag of United States of America image

Avatar of HKFuey

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

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.
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.
Avatar of HKFuey

ASKER

Great :(

I assume I can still send mail through the outlook app from Access?

I have a lot of stuff to change....
ASKER CERTIFIED SOLUTION
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial