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.
