Hi everyone,
I have no prior experience with Macro/VBA and would need help in creating an excel spreadsheet where an email reminder would be sent 60 days, 30 days and 7 days respectively if the project is not completed to the email stated in the 6th column with information from its row. If its completed, the checkbox would be checked and no mail will be sent.
The email should look like:
To: <email stated in that row>
Subject: Reminder to complete project within (e.g. 60 days)
Body:
Dear all,
Reminder to complete IN1661234 by 31st Aug 2016.
<personal email signature>
Do I need to create a button where I have to click in order for those reminders to be sent or will it be sent automatically everyday as long as the spreadsheet is opened?
Also, is it possible to create 3 different email template for each reminder days, such as 60 days prior to the deadline, the subject of the email would be First Reminder, 30days would have Second Reminder and 7 days prior would have FINAL REMINDER and a urgent marked on the email?
And how do I change the email where those reminders will be sent from?
Any help with regards to the above would be greatly appreciated. Thank you so much.
I have no prior experience with Macro/VBA and would need help in creating an excel spreadsheet where an email reminder would be sent 60 days, 30 days and 7 days respectively if the project is not completed to the email stated in the 6th column with information from its row. If its completed, the checkbox would be checked and no mail will be sent.
The email should look like:
To: <email stated in that row>
Subject: Reminder to complete project within (e.g. 60 days)
Body:
Dear all,
Reminder to complete IN1661234 by 31st Aug 2016.
<personal email signature>
Do I need to create a button where I have to click in order for those reminders to be sent or will it be sent automatically everyday as long as the spreadsheet is opened?
Also, is it possible to create 3 different email template for each reminder days, such as 60 days prior to the deadline, the subject of the email would be First Reminder, 30days would have Second Reminder and 7 days prior would have FINAL REMINDER and a urgent marked on the email?
And how do I change the email where those reminders will be sent from?
Any help with regards to the above would be greatly appreciated. Thank you so much.