Avoiding Security Prompt while sending email through VBA

[GK039]

Hi all,

I am using the following line of code to avoid the prompt security window displaying while sending a worksheet via email, but it doesn't seem to work.

<code>
Application.SendKeys "%{s}", True
</code>

Any help will be appreciated. Thanks in advance

George

 

[John_w]

Try AppActive with the title of the Outlook warning dialogue, before the SendKeys:

AppActivate "Microsoft Office Outlook"

Also http://www.rondebruin.nl/mail/prevent.htm.

 

[Smitty]

Check out Outlook Redemption.

HTH,

 

[GK039]

Didn't know of that....Thanks a lot Smitty!!

Check out Outlook Redemption.

HTH,

 

[GK039]

Yeap it worked. Thanks!!!

Try AppActive with the title of the Outlook warning dialogue, before the SendKeys:

AppActivate "Microsoft Office Outlook"

Also http://www.rondebruin.nl/mail/prevent.htm.