I have an Excel 2010 spreadsheet which is streaming in live market data. I need to be able to send out emails when certain cells hit certain values/rules.
a) Trigger an email (I have an SMTP/POP account) when figures in certain cells hit certain rules or values
b) The email subject header, must be able to have user-defined text, and values in selected cells
c) Timed alert - at a specific time, trigger an email with header of user-defined text and values in certain cells