I have the following scenario: based on a schedule, I need to remind people of their turn. In a spreadsheet I have the date the person is scheduled, For each day there are two people scheduled, each having an individual email address.
The scheduled date is always on a Sunday. The reminder has to be sent on the Thursday prior. Would be a set up text that would have to pick up the date from the spreadsheet. Let's say: "This message is to remind you that Sunday, "1/1/14" you are scheduled to be a volunteer in the church's nursery room. We value your participation and we ask you to let us know if you are not able to be present so a replacement can be assigned. Please contact Annie at 758-986-1111.
Children are a gift from the Lord;they are a reward from him. Psalm 123:3"
I am looking for a macro that would automate this task. What are my options?
Sunday Schedule.xlsx
Thank you!
Bookmarks