Sending emails from Access VBA

[GraeagleBill]

From one of Paul's old posts https://www.devhut.net/vba-outlook-automation/, Daniel Pineault offers a clean method of sending emails via Outlook. The problem, or at least where I'm currently bumping my head, is that gmail isn't allowing Outlook to access its servers. I thought I could circumvent that issue with the gmail 2-step verification available at Google, but don't see it at Google for Outlook.

Any ideas for an alternative? I only need to periodically "Send" emails with attachments.



EDIT:
I found this, but imposing this kind of scenario upon a user doesn't seem like a reasonable request.
https://blog.gsmart.in/2-step-verifi...gmail-outlook/

[Welshgasman]

You now use the authentication password that google gives you, when you select that option. Do not lose it either.

Then there is outlook.com?

[isladogs]

As I think I've mentioned to you before you can send email from Access without involving an external app such as Outlook
See my example app: CDO EMail Tester (isladogs.co.uk)
CDO does still work with GMail by using the set app password feature mentioned above

[GraeagleBill]

Thanks Colin, I'll chime back in a couple of hours.


EDIT: I owe you an apology Colin. You "taught" me some time ago about CDO and I completely forgot. I even ran your test module at that time and recall how simple it was. My only excuse is that this fuzzy old brain of mine continues to be troublesome, as evidenced by this OP.

[GraeagleBill]

CDO does still work with GMail by using the set app password feature mentioned above

I can't find the option that Welshgasman mentions.

[isladogs]

See the help file that is supplied with my example app. It includes info on how to apply an app password. Its not done within Access itself.

[GraeagleBill]

Thanks Colin, the biggest help is found here: https://support.google.com/accounts/answer/185833

[isladogs]

Correct. That tells you all you need to do to keep CDO working with GMail's new security measures