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
Bookmarks