How to make an excel table that automatically sends email to someone on his birthday? -

I have to write a formula that recognizes someone's birthday and triggers www.zapier.com.]

I have a birthdays validation formula that creates "send email" hyperlink, but I must send it automatically (and delay up to 10am) non-mutually I did something in VBA but I only Managed to write code that sends that message to 1 person.

Here is the birthday working-formula that has the customer's name in column C8: C100, in email D8: D100, DOBs are in E8: E100 and "Send mail" in hyperlink F Are:. 100

  = IF (text (E13, "dm") = TEXT (today (), "dm"); Hyperlink ("mailto:" & amp; D13 & amp; $ D $ 2 & amp; "& body =" & Substitution ("subject =?" Substitute ($ E $ 3, "$", C13); "@"; $ $ D $ 4); "pošalji "Pošalji čestitku" = Mail sending (Croatian language)  
 VBA code:  
  private Sub CommandButton1_Click () PO_SALJIRONDENDSKEPESTITKE End Sub Public Function POVALJIRONDENDSKESTITKE () Dim olApp Outlook.Application set olApp = CreateObject olmail (olmailItem) as olMail = OlApp.CreateItem set olmail Outlook.MailItem set olmail ("App as Outlook."). To = Cells.Range ("D8: D1000") olMail.subject = "Sretan Rodjen Dan "olMail.Body =" Poštovani, "& amp; VbCrLf & amp; VbCrLf & amp; "Zillimo Wam Siten Rohenland" & amp; VbCrLf & amp; VbCrLf & amp; "Sway Nezbolje," & amp; VbCrLf & amp; VbCrLf & amp; The "Svinaweb" olMail.Send termination function  
 
 This code only has an email to send message when I click on the command button, but as I said I I want to be sent that 
 
 I am using Excel 2013.