Send E-mail from Excel VBA without Security Warning
 

Hi everyone,

I am using Excel to pull and store live data from a manufacturing process,
and automatically generate an e-mail alert when the process values drift
outside allowable limits.

How do I disable the Security warning? (preferably without reg-edit). While
the warning is active and during the included 5 second delay Excel stops and
I lose data.

I know this sounds like "how do I write a virus?" but any help I can get
would be greatly appreciated.

Thanks.

Send E-mail from Excel VBA without Security Warning
 

this question has been raised several times in the past few weeks - so its
worth doing a search.
I understand that the security setting is not an Excel issue but a setting
in Exchange Server...so your IT dept need to configure it.

"fhjfhgjf" wrote:

Hi everyone,

I am using Excel to pull and store live data from a manufacturing process,
and automatically generate an e-mail alert when the process values drift
outside allowable limits.

How do I disable the Security warning? (preferably without reg-edit). While
the warning is active and during the included 5 second delay Excel stops and
I lose data.

I know this sounds like "how do I write a virus?" but any help I can get
would be greatly appreciated.

Thanks.

Send E-mail from Excel VBA without Security Warning
 

You cannot circumvent that dialog without recoding..


either write your routine to use CDO
(code at www.rondebruin.nl)

or download a utility called redemption
http://www.dimastr.com/redemption/




--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


fhjfhgjf wrote :

Hi everyone,

I am using Excel to pull and store live data from a manufacturing
process, and automatically generate an e-mail alert when the process
values drift outside allowable limits.

How do I disable the Security warning? (preferably without reg-edit).
While the warning is active and during the included 5 second delay
Excel stops and I lose data.

I know this sounds like "how do I write a virus?" but any help I can
get would be greatly appreciated.

Thanks.