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

Using CreateObject("CDO.Message"). Was working a few weeks ago.

Microsoft AccessVBAMicrosoft 365

Avatar of undefined
Last Comment
HKFuey

8/22/2022 - Mon
M A

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

Jim Dettman (EE MVE)

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.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Jim Dettman (EE MVE)

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.
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
Jim Dettman (EE MVE)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
HKFuey

ASKER
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.