Excel VBA Code for automated email arlert

[SkyKen]

Hi all, I am a newbie in Excel VBA. I am working on a urgent project assigned by my superior. This project required to design an investment model based on certain technical criteria. I have no issue in generating certain trading signals or investment opportunities. However, I am stuck with the part where I am required to send an automated email alert to my superior once the signals emerging or opportunities arising.


Can I have some ideas or readily available VBA codes that I can instantly apply? Thanks in advance and have a good day ahead.

 

[Fluff]

Have a look at Ron de Bruin's site for how to send e-mails from Xl
https://www.rondebruin.nl/win/s1/outlook/mail.htm

 

[SkyKen]

Have a look at Ron de Bruin's site for how to send e-mails from Xl
https://www.rondebruin.nl/win/s1/outlook/mail.htm

Thanks this is very helpful.

 

[Fluff]

You're welcome