How to write a notification program using Excel?

Question

Macros

Good afternoon.
There is Microsoft excel, in it the table. The table contains a list of employees of the organization with their dates of birth. It is necessary, using excel tools, to organize the issuance of notifications about DR. Is there such a possibility? And if it is, I will be glad to receive tips on this issue. Thank you.

Answer 1

I thought a little (googled) - which I advise you. And here's what I wrote :).

' Private Sub Workbook_Open()
Sub Кнопка1_Щелчок()
Dim mess As String
' В столбце ДР проверить, есть ли дата совпадающая с сегодняшней
  For Each rCell In Range("A3:A6")
    If rCell.Value <> "" Then
      If (Day(rCell.Value) = Day(Date)) And (Month(rCell.Value) = Month(Date)) Then
        ' MsgBox Cells(rCell.Row, rCell.Column + 1).Value
        mess = mess + Cells(rCell.Row, rCell.Column + 1).Value + " "
      End If
    End If
  Next
  If mess <> "" Then MsgBox "Поздравляем " + mess + "!"
End Sub

To work when opening a file, replace Sub Button1_Click() with Private Sub Workbook_Open()
File Link

Answer 2

You can do the following. In VBA, write a book open event handler in which to run through the list of employees and compare whether the date of birth matches the current date. If it matches, then perform some action (show a message, send an email).
All this is written in 5 minutes.
Minus. You will need to periodically open this workbook in Excel (the handler only fires when it is opened). For example, you can throw in autoload.
Do you need Excel tools? After all, you can use some kind of calendars (Google Calendar, in Outlook, etc.).