All, Thank you for your input and all of the suggestion. Upon further and very detailed investigation, It was discovered that McAfee was the root cause of my issues.
If you encounter similar errors when sending emails, check the following on your computer:
Go to your quick tool bar and...
Gemma-the-husky: Yes, the email is fake, but I do have a real on that works. Yes, the Access version are all the same for each machine.
Solo712: I have tried to send messages with both a gmail account as well as with my normal email and pwd that the system knows. I can change the port number...
Here was the last version I tried.
Private Sub Testemail_Click()
Set cdomsg = CreateObject("CDO.message")
With cdomsg.Configuration.Fields
.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2 'NTLM method...
KenHigg- Yes, when I did the bare bones test, I took out everything except the email address and used "test" as the subject and message body. Kept it very simple.
Yes.....and on the machines that it does not work, it always stops at the ".send"
I have checked to insure that the ports are open not to mention that I made sure that the anti virus was turned off on some of the testing to see if that was causing the issue. But still was getting the same error.
Spikepl- yes, I did check all of the settings and they all match between machines. I am logging into each machine using the same login credentials in an effort to keep things consistent.
KenHig- here is the code (its pretty basic):
Private Sub Command74_Click()
Set cdomsg =...
spikepl, I would have to agree except it is currently running fine on two other computers on our network but non of the others.
KenHigg- I did as you suggested and created a very basic email routine and still getting the same error "The transport failed to connect to the server"". Its almost...
I have code in place for sending emails when anyone enters a new record into my access database. This works fine from my local computer as well as another computer on our network. My problem is that its not working anywhere else.
All of the computers involved are running windows 7 (64 bit)...