Have you set up a Gmail App Passwords?

I set up a Gmail App Password a few months ago. I have entered the App Password  in the vba along with my gmail user name [email protected]. Still gt error message "the transport failed to connect to the server. Help.

I am trying without success to generate a new Google App Password. I get into Security, turn 2FA on, click again on 2FA, but do not see the option to create a App Password. Google has changed since the videos were made. I was hoping a new App password would solve the problem, but I can't accomplish that.

The option to set an App Password is well hidden now (don't know why). Use the Search Box to find it.

Thread: App passwords

Kevin, you are correct. I did stumble upon the place to create App Password. I added it to Access, but no success. I continue to get the error in vba editor "Msg.Send"

I found this when searching for a solution as to why I can not use gmail SMTP server with Access: "Starting on September 30, 2024, less secure apps, third-party apps, or devices that have you sign in with only your username and password will no longer be supported for Google Workspace accounts. For exact dates, visit Google Workspace Updates. To continue to use a specific app with your Google Account, you'll need to use a more secure type of access that doesn't share password data." I do not have a google workspace account. I have a personal gmail account. Does this mean Access email seminar technique to send mass email without using Outlook will no longer work with a personal gmail account?
https://support.google.com/accounts/answer/6010255?hl=en

I can't get past Lesson 10 12:30. When I click Send via SMTP is get errors. I change vba to use my Godaddy exchange email smtp.office365.com and the password (I could not get gmail to work). I get the run time error StartTLS is required to send mail. How to do I do that. What am I missing?

I just tried Richard's code for using CDO for Gmail and it worked.  Make sure all your CDO configuration settings are exactly as what he uses:

sendusing = 2
smtpserver = "smtp.gmail.com"
smtpusessl = 1
smtpauthenticate = 1
smtpserverport = 465
sendusername = "[email protected]"
sendpassword = "xxxxxxxxxxxx"  ' Your Gmail app password, not your Gmail login password

I have tried both my Microsoft Exchange account through GoDaddy a well as gmail. I get the same error. Please help.

Try it with a different Gmail account (or create a dummy account to try, since it's free).  This is to eliminate the possibility of something being wrong in your current Gmail account.

Will I need a new Gmail App password?

Yes, for a different email address.

I got it to work thanks to everyone's help.