I have written an application to be used by our Seniors Captain at the Golf Club. It allows him to email Teamsheets to select players directly from Excel using Outlook. I want to adapt the application to use other mail packages other than Outlook.
Using code supplied from Ron de Bruin's Web site I used this test program to test out the method.
End Sub
With Port smtpserverport set to 25, I get this error message
Run-time error '-2147220978(8004020e)':
The server rejected the sender address. The server response was: 550 Access denied - Invalid HELO name (see RFC2821.4.1.1.1)
With the smtpserverport set to 465 I get
Run-time error '-2147220978(80040213)':
The transport failed to connect to the server
The code above was used on a computer using Outlook.
My Outlook application uses port 465.
I got the same result from a laptop using Windows Live Mail.
Can anyone tell me what is wrong?
Dave
Bookmarks