Hi there,

I volunteer for a 'not for profit' and i need to build a database for volunteers. Once main area I need assistance with (without the need to manually check all the time) is to develop a way that when certain fields with a date in them are reached, that a prewritten email is then sent to an email listed in another cell and cc my email in all the time.

An example is that we track when volunteers do particular training that needs to be refreshed every 12 months. I have around 500 volunteers so manually managing is really onerous. If I could enter all the data I need for each volunteer, together with when a reminder needs to occur, I would like it to use my outlook account to send the reminder to the volunteer (to complete training) and cc me it.

Any advice or help would be appreciated.

I have medium formula experience and very little VBA experience.

Thanks for looking at my post.
Benjamin