Access 2007 connecting to Outlook 2007 through gmail server

[Woods]

I used to send emails through Outlook 2007 to gmail server with no issues. The Pop2 and SMTP were all set correctly, but in January 2025 gmail stop allowing Using Names and Passwords to Authenticate, does anyone know how to get through this so I can continue using Access 2007 and Outlook 2007?

 

[The_Doc_Man]

Read this article, at least the first couple of paragraphs.

Transition from less secure apps to OAuth - Google Workspace Admin Help

Starting March 14, 2025, you and your users must use OAuth with third-party apps to access Gmail, Google Calendar, and Google Contacts. OAuth is a more secure access method. You will no longer use a p

support.google.com

It talks about gmail requiring OAuth methods as authentication. Outlook 2007 does not support OAuth methods. Therefore, I'm thinking that something else will have to change. A newer version of Outlook CAN use OAuth, for example, and would allow you to use gmail with Outlook. Note, however, that newer versions of Outlook will have Microsoft's touch, trying to persuade you to use "New Outlook" - that is TOTALLY not compatible with Access Component Object Model operations - i.e. no application object.

It is possible to find articles using javascript to use a "refresh token" to bypass the oauth token, but in general I would say this isn't going to work any more in the exact configuration you described.

 

[Gasman]

I seem to recall you just need an app password generated by Gmail?
I used 2007 outlook with Gmail with no issues, though I am on 2019 now.

 

[Woods]

Okay, is there anything that I can do to use Microsoft Access 2007 to automate emails?

 

[theDBguy]

Okay, is there anything that I can do to use Microsoft Access 2007 to automate emails?

I think maybe your problem is not with Access but with GMail. If it was just Outlook, you can use CDO as a replacement.

 

[Gasman]

Okay, is there anything that I can do to use Microsoft Access 2007 to automate emails?

Yes, set the outlook gmail account to use the app password.

 

[Gasman]

I am able to send via Gmail with Outlook, albeit 2019, but I have only recently upgraded. Previously using 2007?

 

[The_Doc_Man]

What I had to do for Outlook via AT&T servers before OAuth became a thing is they allowed me to create a 16-character random-letter password which I could store as the password for the Outlook mail. But the shorter password still worked for the web version.

 

[Gasman]

What I had to do for Outlook via AT&T servers before OAuth became a thing is they allowed me to create a 16-character random-letter password which I could store as the password for the Outlook mail. But the shorter password still worked for the web version.

Exactly!