Automatic Emails

Hi There

In the past I have often used vba to send emails automatically from excel.

I would now like to be able to take this a step further and send emails automatically containing different attachments depending on the date. I had found information on the internet showing how to send the same file to the same group of people every day at the same time. My situation however is different in that I want to be able to send a different file to the same group of people every week at the same time. Is this possible and if so how can it be done?