The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » excel training course - How can i stop this message coming up when sending email through

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

excel training course - How can i stop this message coming up when sending email through

Resolved · Low Priority · Version Standard

ReplyThu 13 Dec 2007, 11:14Delegate Samantha said...

How can i stop this message coming up when sending email through

A program is trying to automatically send e-mail on your behalf.

Do you want to allow this

If this is unexpected, it may be a virus and you should choose No >>

For upcoming training course dates see: Pricing & availability

ReplyThu 3 Jan 2008, 16:45Trainer Stephen said...

RE: how can i stop this message coming up when sending email thr

Hello samantha

Thank you for your question

Could you clarify a couple of points to help me here?

1. What e-mail system are you using?
2. What anti viral software are you using?
3. Have you a firewall? If so what is it?

Thanks

Stephen

ReplyFri 4 Jan 2008, 08:28Delegate Samantha said...

RE: how can i stop this message coming up when sending email thr

Hi stephen,
i am using MS outlook
i am using norton anti virus 2005
i have a firewall through norton. i have tried to turn off the firewall but this doesnt seemto make a difference.

thanks
sam

ReplyMon 21 Jan 2008, 13:01Trainer Rich said...

RE: how can i stop this message coming up when sending email thr

Samantha,

If this message is coming up during a VBA program you've written, it's usually Office warning the user of your program (or Excel) that the program is about to send an e-mail, and wants the user to confirm this is okay.

This is built-in security from Microsoft in case a malicious VBA Macro is written to spread Viruses etc.

I'm not sure you can remove it.

Usually, this is MS Outlook brining up this message, no matter what program is trying to send an e-mail (eg. some links in Browsers do this too).

Regards, Rich

Excel articles

· Microsoft Excel provides the building blocks of shared information
· Create Buttons To Navigate Between Worksheets
· Working Together Is Easier Than Ever With Excel 2010
· How To Use The Cell Styles Functionality In Excel 2010
· How To Print Worksheets In Excel

Excel tip:

Create and delete borders

To put a border around the outside of a selected range, press Ctrl+Shift+&. Use Ctrl+Shift+_ (underscore) to remove any borders from a range.

View all Excel hints and tips

Hi

I am trying to loop through selected worksheets, using a select case statement to exclude the unwanted worksheets. I have the below code but it doesn't loop at all; it just updates the active sheet. Could you let me know where I am going wrong? &..