98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Outlook security settings
Outlook security settings
Resolved · Low Priority · Version 2000
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
Training information:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Shared Conditional FormattingIn a shared workbook, conditional formats applied before the workbook was shared will continue to work; however you cannot modify the existing conditional formats or apply new ones. |