app to send email using Crystal Reports

Can anyone direct me to a place where I can find some references(tutorials, code sample, etc.) on how to build an app that will send an email every night based on some criteria from a db(date). Here's what I'm trying to do. I have a db with about 100 projects and I need to send an email out to two people in each project if that project has been updated. The email should go every night with a report created in Crystal Report in a pdf format (the report if done, I need to find out how to automate the report creation however). So, each email would contain a report with all projects that have been updated today, if no project has been updated today, no email should be sent. Any help is much appreciated.

Thanks!