I have huge problems making this macro working. I want it to send automatic e-mail reminders, but I'm really bad at VBA. Can anyone help me please?

Right now I have cells with
1) Person's birthday year
2) Birthday month
3) Birthday day
4) Yes or No if Today is their birthday today (=IF(AND(DAY(TODAY())=C2,MONTH(TODAY())=B2),"Yes","No"))
5) Their name
6) Their e-mail

What I want to do is:
1) Eachtime I open this excel file it checks the 4th row to see if there's a "Yes", if there's a "Yes" then it would generate an e-mail message.
2) It will send an e-mail to them, wishing a happy birthday, inside of e-mail body it should say When they were born.
3) Close when done

Excel file attached.
Birthdays.xlsx


VBA code that might work, but needs editing
Please Login or Register  to view this content.