|I am working in supply chain, in order to follow the shelf life the material , i need the automate mail from excel 1 week in advance.|
Prodution date -01-Apr-13
Shelf life upto : 30-Apr-13
In the cell A1 : remaining shelf life will come,
If shelf life A1 is less than 7 days i need mail (lotus)from excel , untill i change the value.