Send Email to smtp.gmail.com from VBA after 5/30/2022

I have several personal Excel/Word VBA addins I've created that send email using smtp.gmail.com as SMTP server. I use my email address and password and turn on "Allow less secure apps" option in my GMAIL account. Everything works well.* I use a third party app I've had for about 15 years. **

On May 30, 2022 Google will disable "Allow less secure apps".* Has anyone addressed this issue.* I'm not using Outlook for my personal use.

On my Gmail Account.
Some apps and devices use less secure sign-in technology, which makes your account vulnerable. You can turn off access for these apps, which we recommend, or turn it on if you want to use them despite the risks. Google will automatically turn this setting OFF if it’s not being used. Learn moreAllow less secure apps: ONOn May 30, 2022, this setting will no longer be available. Learn more

Following this. I run a number of sheets using the mail tool and it just broke for me. Any updates anyone?

I am testing a tool called easendmail from EmailArchitech. I got it working. I'm working on refreshing the accesstoken.

I have a similar problem I have an excel workbook using VBA to send individual gmails to multiple “google group” members. It had been working for 4 years until Gmail added Oauth. I have been going in circles with EmailArchitech. I can test the app in test mode and it will send the email if I add include read. Compose, send and delete permissions AND click through the alarms. When I configure it as production I get not verified message and go through a similar routine that "test" needed.
Currently the file is on my local disk. I run this from my google account xxxx@gmail,com and my google account has owner permissions for gmail. I only want to send emails not read, compose or delete.

When I try to Verify the API it needs a domain.

Mogul, let us know if you get a fix.

got this from DiamTo at stackoverflow. It is easy and you don't have to use oauth .....

To be clear Google did not add Oauth2. The option of using Xoauth2 with the smtp server has always been there. Nor is google forcing you to use Xoauth2 with the smtp server.

What google did was remove the option for Less secure apps & your Google Account. Which allowed you to use the google account password to connect to the smtp server.

If you have 2fa enabled on the google account you can create an apps password and use that password instead of the actual password for the google account in your code.

.Item("http://schemas.microsoft.com/cdo/configuration/sendpassword") = "AppsPassword"
If you do not want to use an apps password then yes you will need to configure Xoauth2. xoauth2-protocol Its been a very long time since i have touched VBA I dont think this is something i can help with. But a quick google search shows it should be supported Oauth