 | Member with 1 posts. THREAD STARTER | | Join Date: Jul 2012 Experience: Beginner | |
Automated Email warnings on an excel spreadsheet Hi,
I am a summer student for a concrete company and I am responsible for keeping all of our MSDS up to date. I have a spreadsheet set up to summarize it and that includes expiration dates. Currently the dates change color when it is within 30 days of expiration and to red when it has passed the expiration date. My problem is I have other jobs to do at the same time and don't check the sheet daily. Is there a way I can have Excel email my outlook account when the msds hits 30 days before the expiry?
P.S. I'm running excel 2010 |
