outlook security settings

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Outlook security settings

Outlook security settings

resolvedResolved · 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 courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Shared Conditional Formatting

In 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.

View all Excel hints and tips


Server loaded in 0.08 secs.