Column A = persons name
column B = persons email address
Column C = date email needs to be sent
Column D = has email already been sent Y/N

Can optionally create column E if it makes this macro easier = Does an email need to be sent today Y/N

I will have a macro that continuously adds new addresses to the bottom of this list, it will also populate the date column at this point

I want a macro that I can run daily that will check Columns C&D (or E) and send an email to that person if the date in column C is today (or earlier) AND the person hasn't already had an email sent to them.
So the macro needs to also update Column D for each email it sends, might be helpful to have it add the date the email was sent in Column F as well.

The macro can either email each person individually or BCC them all on to one email, I don't expect much more than 10-15 email addresses per day.