VBA: is there a way to trigger an email

[Lball]

Hi, just wondering if there is a way for an email to be generated from excel when certain circumstances occur. Lets say i have a log and a date is put in that somethign is due today. My entering the date=today would trigger an email to start to be created. Obviously it would have to be sent manually, but is there anyway to notify anyone this way? This is a shared workbook as well.

Let me know if anyone has any thoughts about notification/emailing from excel.

Thanks!!

 

[VoG]

See if this helps http://www.rondebruin.nl/mail/change.htm

 

[Dan44]

Hello,

Yes it is possible to trigger an email and also send the email automatically via MS Outlook... See here- http://www.everythingaccess.com/tutorials.asp?ID=Outlook-Send-E-mail-Without-Security-Warning

 

[Lball]

Thanks to both of you for your quick responses. I will digest info but i think i can get this to work.
THANKS