Send Email Button - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Send Email Button

Kim Boren

9 months ago

I have been working with Richard's CDO email tech help videos. I have run into an error when clicking on the email send button. This is the error: Run-time error '94': Invalid use of Null. I did not even know I was using Null with this button. This is where the code stops in my VBA. See attachment. If you can help I would appreciate it.
Kim

	Kim Boren OP @Reply 9 months ago

	Richard Rost @Reply 9 months ago
Check and make sure your fields have values: Email, Subject, Body. MsgBox each of them.

	Kim Boren OP @Reply 9 months ago
Richard, Thank you. I did not have values in each of the objects. Now I have and I have a different error: The transport failed to connect to server. Kim

	Kim Boren OP @Reply 9 months ago

	Richard Rost @Reply 9 months ago
I see you're using Gmail. Did you set up an App Password? Gmail App Passwords

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

Next Unseen

New Feature: Comment Live View