Some expert help needed. -

If there a way to create an automatic email to say x6 people and then mark the date the email was sent.
Then I need it to continue through the database and keep selecting x6 email addresses and sending the email on a weekly basis, catch here is I need it to send about 5 weeks in advance.

Example of what I am trying to create is:
Club membership help roster;
5 weeks prior 6 members get an email saying they need to be at the club 5 weeks from the email date to complete they duties.
I need then for it to choose the next 6 people and repeat on a weekly basis.

Sorry to sound so confusing about this guys and girls.