Send Email Smtp Fail - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Send Email Smtp Fail

Kim Boren

9 months ago

Hello,
I am going through the email seminar and creating what I need from scratch. I am to the point of using the bare minimum code to send a test email. I have the username and password in the code. I click the send button and "sending..." appears on the button then an error "the transport failed to connect to the server." the code stops at Msg.Send. Debug is in yellow. I would like some help to determine where to look to correct this error.
Thanks,
Kim

	Kim Boren OP @Reply 9 months ago

	Jerry Fowler @Reply 9 months ago
Kim, do you know if you have setup a Gmail App Password yet? this is different than your reg Google password. There is a video with all the instructions, but I have been un-able to find it. Hopefully one of the mods will be able to.

	Kevin Robertson @Reply 9 months ago
Gmail App Passwords Thread: App passwords

	John Davy @Reply 9 months ago
Kevin, you beat me again. John https://599cd.com/blog/display-article.asp?ID=2308

	Kim Boren OP @Reply 9 months ago
Yes, I have done the gmail password and username

	Kim Boren OP @Reply 9 months ago
So if I understand correctly the code ran past the username and password and stopped at "Msg.Send"

	Kim Boren OP @Reply 9 months ago
Interesting, I replaced "Msg.Send" with "Msg.Display" and it does the same thing.

	Kim Boren OP @Reply 9 months ago

	Raymond Spornhauer @Reply 9 months ago
Where in your code you set the following variables: EMAIL_USERNAME EMAIL_PASSWORD -Raymond

	Kevin Robertson @Reply 9 months ago
I tried the code and it really doesn't work anymore. Try this instead: Send Email with CDO (4 part series)

	Jerry Fowler @Reply 9 months ago
I am no expert like the great Moderators here on the site. I went through the Email Seminar. One thing I noticed in your code that I have but did not see it in yours was just before all Msg.Configuration lines I have this line; Schema = "http://schemas.microsoft.com/cdo/configuration/" Not sure if it's required or not. Just a suggestion

	Kevin Robertson @Reply 9 months ago
Jerry The required code is there. In the code in the screenshot the repeating part ("http://schemas.microsoft.com/cdo/configuration/") is not stored in a variable.

	John Davy @Reply 9 months ago
Hi Kim, I second what Kevin said. I use CDO all the time. John

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

Next Unseen

New Feature: Comment Live View