I have an excel spreadsheet where I track inventory items to order, when supplies are low. I enter items used weekly, and once they drop below a certain quantity, I use this formula to let me know [=IF(B20<=C20,"ORDER ME NOW","I am OK")]. I would like to modify the formula so that when the cell changes to "order me now", I get an email letting me know to order this item. I am using outlook express. Any suggestions?
