Email by CDO via Gmail To Stop Working?

[szucker1]

I just received notice from Google that on May 30th they will no longer allow the use 3rd party apps which only use a username & password. I have an Access Database where I send email using CDO via Gmail server which I'm afraid will stop working.

I am using CDO because I have to send a few hundred email, some with two attachments, and I don't want to deal with a security message for each individual email that's involved with emailing from Access through Outlook.

Is there another way for me to do this past May 30th?

[Welshgasman]

It has been asked here.
https://www.utteraccess.com/topics/2.../posts/2796293

[Micron]

Access with Outlook using CDO presents no prompts/warnings/messages? At least not if the email is sent via Exchange?
That's been my experience.