In order for that CDO example to work the SMTP relay has to accept password authentication. An exchange host is not likely to work. However, you could use another email account. Having said that, Gmail and other free email hosting will not allow this code to work.
What you could do is edit each of the client's registry to trust Networks and trust the folder where the BE resides. Then, automate outlook as Hidden, using code like this.
https://www.accessforums.net/import-...tml#post281258