You can use database mail to send emails from the database.

You can use SQL Agent to schedule jobs.

However, the ease of making all this possible is dependent upon what you want to send and how easy it is to get that information.

CEWII