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

outlook security settings

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

Outlook security settings

ResolvedVersion 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:

Checking if a calculation adheres to Order of Precedence

When writing formulas you must make sure that results will be calculated as you intended.

Excel adheres to the standard order of precedence for calculations. It calculates percentages, exponents, multiplication, and division in this order before calculating addition and subtraction.

For example, =7+5*3 results in an answer of 22, not 36.

To force a calculation to be completed before another calculations, place the section in parentheses: =(7+5)*3 will result in 36.

To check how excel is evaluating a formula, click on the cell and select the 'Tools' menu, select 'Formula Auditing' and click 'Evaluate Formula'

In the dialog box click on 'Evaluate' to watch as each part of the formula is successively calculated.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.