Email reminder in checklist

Hello,

My name is Pim. I am currently struggling with a problem and I have searched many forums already but it is just to difficult for me to understand as I am not that skilled with Excel.
I am using excel 2010 and I made a checklist in a spreadsheet. Tasks, completion dates and names of responsible persons are all in. I've been asked to implement an email reminder in this spreadsheet to remind my colleagues with their task, for example one week before the actual date. I found some information on VBA, macros, specific codes to use this and I have been busy for more than a full day already by trying these codes, but without any result.

Now I saw that Outlook is commonly used with Excel email notifications. I don't want to use Outlook as I need to send emails via another email address. After some research I've seen that this is possible too by something called CDO, is this right?

I hope that I am clear in explaining my problem. To summarize: I have a checklist with tasks for different colleagues on different dates. These colleagues need to be reminded one week before they need to do this task, via email (no Outlook but Gmail or another account). Automatically sent emails would be even better!

As I said, I did research on VBA and codes but that is like Chinese to me, I don't see much logic in it. I have added an example of the checklist Example Checklist.xlsx for a complete picture.

Help is highly appreciated! Thanks in advance.

Hello Mr. PBrack,

Nice meeting you. i am also trying to send emails automatically. the scenario is same as you have mentioned in it. Please do let me know if you come across any solution on the same. i will also try my level best to find for you too.

Thanks

Kamal