Preventing outlook security features from excel vba

[maheshjj]

Hi All

I have developed a VBA in excel which send emails via outlook object.
I have Excel 97 with Outlook2000 SP3 installed. From SP3 onwards MS have introduced some security featues which gives a popup "A program is trying to access your address book do you want to allow" only if we give yes we can proceed further.
So do anybody have idea of how to suppress this popup via code or changing any registry entries.

Thanks In Advance
Mahesh JJ

[techgnome]

Nope.... it's a feature, to prevent email hijacking. As far as I know there isn't a way around it. At least none that I have seen.

Tg

[Hack]

Welcome to the forums.

In addition to what techgnome said, I believe I read somewhere that this is as actually feature of XP, but I've only seen it manifest itself in Outlook.

[maheshjj]

Hi
Thanks for your replies..
Actually we need to do a batch process which is done using windows scheduler. So here we need a user interupption . Actually there are some 3rd party tools which suppress this popup. But iam looking into a way which can be acheived thro code or changing registry values..

Bye
Mahesh

[RobDog888]

No, your correct, from Outlook 2000 SP3 MS has intruduced more and more restrictions on what can and can not be accesed
programmatically without incurring the security prompt.

You may be able to write an Add-In for Office targeting Excel and Outlook but probably easier to just switch to SMTP to send
your emails. Try a search for SMTP for there are several examples using it on the Forums.