I've been asked to find a way to have an excel spreadsheet (that will be updated often) send an email to the email address from a column, as well as on a specific date according from another column. But hoping for it to do it automatically given that it is about 500 rows long. If I need to open a program every morning, I'm willing to do that. I also need the email to grab the name of the coordinator from a specific column in the sheet, a number from another column, as well as being able to add a message to the email. I'm willing to use anything within sharepoint.
So basically, when November 16 (Column H) hits, it will automatically send an email (that is in Column G) like below:
Hello (Name from Column F),
(Number from Column A) is within 130 days.
Is this at all possible within sharepoint?