sending mail

Question

Hi to all, I was done custom reports using asp.net with sql server 2005. Now i need to send mail custom reports using sql server. Custom reports only i send to client by scheduling basis(daily,weekly or monthly), it will send automatically also.I gone through about sql server agent and database mail but both of these methods working manually , cant attach for custom reports.So i have to send mail custom report using sql server or report manager. Any one help me.... Thanks & regards, Sundar