Peter has attended:
Excel VBA Advanced course
Outlook security settings
Is it possible to get around the security setting where you have to wait 5 seconds before an ecxel spreadsheet will send an email using outlook?
Thanks.
RE: Outlook security settings
Hi Peter
Thanks for your question, and apologise for the delay
As agreed I will research this isue and get you a substantive response by the end of today
Reagrds
Stephen
RE: Outlook security settings
Hi Peter
As mentioned here is a third party piece of software which will accomplish this.
http://www.add-in-express.com/outlook-security/
I strongly urge however that you confirm the safety of such an approach with your IT support staff before proceeding
Regards
Stephen
RE: Outlook security settings
Thanks Stephen, I'll take a look at this.
I also found some code which might be worth a look. It involves creating a public function in the Outlook VBA Project and then calling that function from within VBA code running in another application. It's based on the fact that functions in the Outlook project should be trusted and therfore not trigger the security warnings. It's based in Access VBA but from what I've read there shouldn't be any reason for it not to be transferrable to other applications. I've not had chance to digest exactly how it works yet but I'll give it a try. Link is below if you want to take a look.
<http://www.everythingaccess.com/tutorials.asp?ID=Outlook-Send-E-mail-Without-Security-Warning>
Kind Regards
Pete