I have an excel spreadsheet that shows each Sunday and who is serving in what capacity on that particular Sunday, for instance:
Sunday 6/12/2011 I have 2 readers, 1 chalice bearer and 1 usher
Next week it will be 4 other people but the same job needs to be done.
How do I set this up so that I can go through and select a persons name and then select the dates that they are assigned to say Read and each week send out an e-mail to the people that are serving on the upcoming Sunday.
I am a little confused between events/tasks and assigning.
HELP
