But I try not to think with my gut. If I'm serious about understanding the world, thinking with anything besides my brain, as tempting as that might be, is likely to get me into trouble.
I have watched and enjoyed your Email Seminar through lesson 10. I use Gmail and have an issue. When I entered your VBA code for the test email and used port 465 I received an error "The transport failed to connect to the server". Then I tried the port 587 and got the error "The server rejected the senders address. The server response was 530 5.7.0 must issue a STARTTLS command first." I checked my address and password. Both correct. Any suggestions? Thanks
Do you have 2-factor authentication turned off? Did you make an App Password for your Google account? Go into your Google Account settings and go to Security - Signing in to Google - App passwords. There you can setup a special username and password just for your Access app to send email thru your Gmail account. Not sure if I covered this in the seminar or not because it wasn't required at the time.
Jerry FowlerOP
@Reply 5 years ago
Richard thanks I will give that a try.
Jerry
Jerry FowlerOP
@Reply 5 years ago
Richard I tried this several different way with 2-factor turned off and then turned on. I also set up an App password and substituted that for my password in the vba code and also with ports 465 and 587 and still got the exact same errors.
I then copied and pasted the vba code from your website just in case I had something wrong. Still got the same errors
So far the only way I got an email to send was using my gmail address through Outlook, but would rather not have to do that.
Yeah, you've got me stumped, Jerry. I don't know where else to guide you. Try running down the Troubleshooter, perhaps? I use this code myself every day in my database. It's what sends my daily emails, subscriber updates, newsletters, etc. Several thousand people have taken this seminar too, so I know it works. If not, they'd all be yelling at me too. Has to be something on your system, I'm thinking. Do you have a different PC to try it on?
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
