CDO VBA Excel Macro

Question

Hello Community!

I am testing a excel macro which suppose to send emails.

It was done with CDO which access SMTP server.

But I am getting the following error message:

"The transport failed to connect to the server" or in German "Der transporter konnte keine Verbindung zur Server herstellen".

Could somebody knows exactly why this message comes up?

I already tried many thing without success.

I am looking for deep knowledge.

Thank you in advance.

Regards

Carioca

Answer 1

"The transport failed to connect to the server" or in German "Der transporter konnte keine Verbindung zur Server herstellen".

Could somebody knows exactly why this message comes up?

The message means that your PC can not connect to the SMTP server.

If we assume that you've setup the CDO right, it is obvious that a 3rd party tool blocks the connection.

In most cases the firewall and/or virusscanners on your local PC blocks that, because it's a back door for malware to send confidential data out into the world.

Most companies runs also firewalls on there servers that blocks this kind of connections. Contact your admin, he can look with a Port or IP scanner what going on behind the scenes.

Andreas.

Answer 2

it is already 465

Answer 3

Hi,

change the SMTP port from 25 to 465.

Or have a look:

https://www.rondebruin.nl/win/s1/cdo.htm

Claus