Unable to Send SMTP E-mail

[RogerCooper]

I generate e-mails automatically by using an SMTP object. This works fine from my own computer but when I use a virtual server I receive the message "A program is trying to send an e-mail message on your behalf.." which I then need to allow manually. Is there any way to get around this?

 

[theDBguy]

Are you using CDO?

 

[RogerCooper]

Yes.

 

[theDBguy]

Yes.

Okay, I will assume your virtual server has some security settings you have to adjust. You may have do it through the Registry.

 

[sonic8]

I receive the message "A program is trying to send an e-mail message on your behalf.." which I then need to allow manually. Is there any way to get around this?

Are you using CDO?

Yes.

This does not make sense!
As far as I'm aware, the message "A program is trying to send an e-mail message on your behalf.." is typical and documented for Microsoft Outlook only and I've never heard about it ever appearing when using CDO.

 

[RogerCooper]

The exact same database works perfectly on my local machine. I think theDBguy is right, that this is a registry issue.

I have created workaround using AutoHotKey.