Sending out a database mail alerting you to upcoming birthdays?

Question

SQL Server

There is a table in the database - a list of employees in the company. Name | Date of Birth.
There is an idea to set up mailing of letters through db mail - when someone's birthday is approaching (for example, next week) - a letter to employees.
The question of a person who can only write selects and inserts.
How to google to realize such an idea? ))

Answer 1

Well, as an option - google the unflattering word blat (this is such a command-line mailer) + xp_cmdshell
is completely knee-deep, but just for those who know how to write selects