I have a project that I need to complete and am freaking out because I can not figure out the VB code.
I need excel to email certain individuals the day a task is due and keep sending emails until a box next to the cell is marked completed.
I would rather trade services, not rich, but I am...
I found this code, I can make it work but how do I get it to stop emails of the cell next to it is marked a completed or to keep sending emails until marked completed?
Dim myApp As Outlook.Application, mymail As Outlook.MailItem
Dim mydate1 As Date
Dim mydate2 As Long
Used in sheet
Use conditional formatting and add two rules
for 2007, 2010 or 2013 excel version
Highlight applicable range >>
Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description...
I found this code in an excel spreadsheet that does sort of what I want it to do but, I don't now how to apply it to what I want. I can change the Email notice in the code, but how to get it to send an email to a specific person on a spefic day and to keep sending them until it has been...
Please help if you can, I know very little about excel and I have a very complicated spreadsheet to build.
If I can pull this off, it will help me fight the coming layoffs.
I need excel to send automatic email when the spread sheet is opened to the supervisor every time a check in...