Disable "a program is trying to..." message

**eriknokc** · 03-05-2009, 08:24 PM

When I run the macro below, I receive the message "A program is trying to automatically send e-mail on your behalf. Do you want to allow this?" My options are yes, no and help and the green progress bar has to go across the warning box before I can click yes. Is there a way to add code in the macro to disable or skip this?

Please Login or Register  to view this content.

**Leith Ross** · 03-05-2009, 09:44 PM

Hello eriknokc,

There are 2 options available. You can send the email using CDO (Collaboration Data Objects, previously known as Active Messaging) schema or rewrite the macro to run from Outlook. If you want to run the macro from Outlook you will have to create a digital signature and sign your project before you will be free of all the security b.s.

If you want to see how it is done using CDO, check out Ron De Bruin's site here

If you want a VBA example of sending the email from Outlook and how to create a digital signature, download the attached Zipped Word document.

**eriknokc** · 03-06-2009, 08:32 PM

Thanks for the information. When I do that I receive a runtime error -2147220960 (80040220) The "sendusing" configuration value is invalid

Please Login or Register  to view this content.

**Leith Ross** · 03-06-2009, 08:59 PM

Hello eriknokc,

This is one of the drawbacks in using CDO. It is complicated by many factors. Perhaps this will help you understand what is happening with the field...

If the SMTP service is installed on the local computer, then the value defaults to cdoSendUsingPickup (1). Otherwise, if Microsoft Outlook Express is installed, the value defaults to cdoSendUsingPort (2) and the settings from the default account are used.

Field Values
cdoSendUsingPickup (1)

cdoSendUsingPort (2)

cdoSendUsingExchange (3)

smtpserverport Field
This field is only relevant when the SendUsing field is set to cdoSendUsingPort (2). The default is 25. What browser are you using? This can effect the port setting.

**eriknokc** · 03-07-2009, 04:00 AM

I am trying to use this code at work and so that makes sense why I am receiving this error. Thanks for your help in clearing that up.

**DonkeyOte** · 03-07-2009, 04:38 AM

CDO is my preference also but there are 2 other methods that have not been mentioned:

1 - Outlook Redemption see: http://www.dimastr.com/redemption/

2 - ClickYes (3rd Party) see: http://www.contextmagic.com/express-clickyes/
(the free version should be sufficient)

Myself, as I say I prefer CDO though I have used ClickYes (without issue) ... I found Redemption a little intense...

**silent_knight** · 05-14-2010, 01:03 AM

Hi,

I tried copying digital certificate to the required folder however I got an error while was not clearly understand as it said error only. I have attached the snapshot as well. I am using this on my office PC .Please assist me .

Regards,
Knight

Originally Posted by Leith Ross

Hello eriknokc,

There are 2 options available. You can send the email using CDO (Collaboration Data Objects, previously known as Active Messaging) schema or rewrite the macro to run from Outlook. If you want to run the macro from Outlook you will have to create a digital signature and sign your project before you will be free of all the security b.s.

If you want to see how it is done using CDO, check out Ron De Bruin's site here

If you want a VBA example of sending the email from Outlook and how to create a digital signature, download the attached Zipped Word document.