disable security popups using code rather than add-in

[Guest]

I have wrritten a macro in excel to send an email. while the macro is sending
a email a security popup appears which says "“A program is trying to access
e-mail addresses you have stored in Outlook. Do you want to allow this?â€
Code execution is suspended until I respond to the pop-up

can any one help me to disabling this using the vba code and i don't want to
use the add-in feature.

 

[Sue Mosher [MVP-Outlook]]

See http://www.outlookcode.com/article.aspx?ID=52 for your options with regard to the "object model guard" security in Outlook 2000 SP2 and later versions. Disabling it is not an Excel VBA option.