Good morning!!
I hope I am doing this right. It is my first time. I am currently deployed to Iraq, and my commander wants his Excel spreadsheet to do something special so here we are. I have no where else to go. We have a current listing which has a cell count down til an expiration date is met. He would like to have the system send an e-mail to the responsible commander of the unit when their cell reaches 60 days left, 30 days left, and then again when their account has officially expired. There are 58 sheets in the workbook with different units listed and different commanders, all with expirations dates differing from each other. All the countdown cells are in C18. I have no experience in macros, so please go easy on me. Also the cell C18 is a formula with conditional format. So let me break it down of exactly what he wants since noone has answered this question yet:
1. I need a macro that will look through all 58 sheets at the C18 cell and see if the value is 60, 30, or 0.
2. If it matches any of these values, then it needs to send a specific e-mail message through Outlook.
3. The message will be sent to the individual responsible for that sheet in the workbook. Their name appears in the sheet.
4. This e-mail should run automatically without any input from the user.
5. This macro should run as soon as the "Account List.xls" is opened.
6. This macro will only be run once per day.
Thanks for all your help, and your support. GO ARMY!!