Hello,
I've struggled with this for several days and have finally decided I can't figure it out. Any help would be greatly appreciated as I am supposed to have this figured out by tomorrow (Friday). Here we go....
I need for column D to be subtracted from the day it is =today() and the outcome in days to be put in column E. If there is no date in column D then the return should be 60. When the days in column E = 120, I need it to send an automatic email to the addresses in column L, M and C. After that I need it to send an email every 60 days until a date is put in the received column F. Last but not least I need for Column C to be linked to the "CQI Schedule" file column C so that the C column in the "PandPupdate" file are updated. My understanding is that the email option won't run unless the file is open so I'll have to figure out how to get the windows task scheduler to open the file, but at the moment that is the least of my worries. I've attached the two files I need help with. As you'll probably be able to tell, I tried to use Ron Debruin's code for auto sending the emails. It worked great till I had to add all the other stuff.
Thanks in advance for anyone's help. You'll possibly be saving my job. I definitely got in over my head this time.
Tara
Bookmarks