Hi, I need to send automatic email responses to customers based on values that are stored in the sql server 2008 r2 databae. There are multiple templates based on the value. I need to know if the template can be created with Sql Server Report Builder 3.0 and then be scheduled to automatically run and send users emails on 3 hour intevals. I am open to learning how to create an html template then store it in SQL Server 2008 r2 and then create a procedure that pulls in the customer data with the corresponding template. Thank you, Kellylee

Hi Kellylee, Well you can create a stored procedure inside which you can declare variable to store or create your html code and use xp_sendemail procedure to send emails. Details of that are given in the link http://msdn.microsoft.com/en-us/library/ms189505.aspx. Then you can create an SSIS package which you can schedule it to run every 3 hours. Let me know if it helps you. Regards, Bharath R S

Hi Bharath, I finally finished creating a procedure that builds an html template and loops through a cursor to email to all customers. This was very involved and tedious. Can you explain more how I can set the procedure up on a SSIS package? Thank you. Regards, Kellylee