We need a application that can automatically send an email to a group of predestined users and text based on a event date. The trigger should fire every 12, 9, 6 & 3 months before an event date. There will many different events.
The softaware available to use Microsoft Office 2010 (include Access), Sharepoint and any open sources.
Any advise and pointers on how this can be achieved is extremely appreciated.