CDO Message Failing

The core issue here is that CDO is a very old technology.  I tried to search for some answers but it was difficult.  Basically: Exchange Online recently moved to requiring TLS 1.2, and CDO isn't using that so fails to connect to the server.  This page had some potential answers: Using CDO/SMTP/TLS in VB6 to send email smtp.office365.com mail server - Stack Overflow

Honestly: I think the best solution would be to move to the VAF and use .NET to send the emails.  Whilst even that may have some issues, the reality is that .NET is much better supported now than CDO, so you're likely to find some workarounds.  I appreciate the overhead in making such a change though.

The core issue here is that CDO is a very old technology.  I tried to search for some answers but it was difficult.  Basically: Exchange Online recently moved to requiring TLS 1.2, and CDO isn't using that so fails to connect to the server.  This page had some potential answers: Using CDO/SMTP/TLS in VB6 to send email smtp.office365.com mail server - Stack Overflow

Honestly: I think the best solution would be to move to the VAF and use .NET to send the emails.  Whilst even that may have some issues, the reality is that .NET is much better supported now than CDO, so you're likely to find some workarounds.  I appreciate the overhead in making such a change though.

A workaround could be to send the CDO message to a local SMTP server such as hMailserver and then configure that SMTP server to forward the messages to the external mail server.

That's a great option. Far, far easier than my suggestion! 

Thanks Craig

Thanks bright-ideas.dk will give it a shot