Send Gmail Emails Through Access Using Oath 20 - Access Developer Forum


	Back to Access Developer Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Send Gmail Emails Through Access Using Oath 20

Rick Taepke

12 months ago

Google no longer supports Less Secure Apps setting and says OAuth 2.0 should be used instead. I have looked into this and find it all very confusing. Has anyone setup OAuth for MS 365 and sent emails using Access? I would like advice on where to begin. Thank you!

Adam Schwanz @Reply

12 months ago

Here's some more information
Google API Oauth

I have done this multiple times with JavaScript in web servers but not in Access. My experience with trying to use Access to create tokens (especially JWT) has been bad, it's created incorrect tokens with the same logic as my JavaScript. Maybe you'll have better luck. My experience has pretty much been that it's best (Definately easiest) to move to something like sendgrid to send emails with as the CDO method is fading out.

The third party apps should still work for gmail for right now (might not be long) on a personal account if you want to try that (I just set one of these up like a week ago), the business ones no longer allow it.

	Alex Hedley @Reply 12 months ago
VBA-tools/VBA-Web Google-APIs https://github.com/VBA-tools/VBA-Web/wiki/Google-APIs

	Rick Taepke OP @Reply 12 months ago
Adam Thanks for the info!

	Rick Taepke OP @Reply 12 months ago
Alex Thank you! I will try this also.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developer Forum.

Next Unseen

New Feature: Comment Live View