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

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

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