How to automatically, using VBA, send an email for a completed task from a table in excel?

I have a table created:

And I would like to have this table using VBA send an automatic email to the group once a task is marked on the table as completed.