Dear Team,
I have gone though the below thread, which helps somewhat on my requirement but not completely. Please need you kind help on VBA code. Sorry if i have missed any other thread which would have met my requirement.
https://forums.techguy.org/threads/...ue-date-reminder-based-on-excel-file.1129238/
Here is my requirement...
I have a data in excel (attached file) basically its a re-assigment project which needs 3 tasks.
Can you please help me with a VBA code which should send a email notification/reminder not to individual email addresses instead it should send an email to me, If the Column F & H has today's date i.e. current date with the table of data in body of email and update the status as Done in excel sheet once the email has triggered.
Hope you will help me on this. Many Thanks in advance
Example of email
I have gone though the below thread, which helps somewhat on my requirement but not completely. Please need you kind help on VBA code. Sorry if i have missed any other thread which would have met my requirement.
https://forums.techguy.org/threads/...ue-date-reminder-based-on-excel-file.1129238/
Here is my requirement...
I have a data in excel (attached file) basically its a re-assigment project which needs 3 tasks.
- Column A to E are filled manually which need not be automatic.
- Column F has a formula for 29 days date for Column B and accordingly Column H for column F.
- Column G & H are the status of task action.
Can you please help me with a VBA code which should send a email notification/reminder not to individual email addresses instead it should send an email to me, If the Column F & H has today's date i.e. current date with the table of data in body of email and update the status as Done in excel sheet once the email has triggered.
Hope you will help me on this. Many Thanks in advance
Example of email