title: Sending out an HTML Email Notification
body: <p>Something that seems pretty simple is now driving me nuts. I need to come up with something that runs a query against a SQL Server database for recent shipments from our warehouse. Based on what is marked as recently shipped, it looks up the email address from that customer and emails them a shipment notification, just like <a href="http://www.hotforsecurity.com/wp-content/uploads/2013/05/Amazon_2.png" rel="nofollow">Amazon</a> and pretty much <a href="https://litmus.com/blog/wp-content/uploads/2012/12/sephora-shipment.jpg" rel="nofollow">every other company</a> does. </p>
  
  <p>The body of the email would have the items in the shipment, tracking number with hyperlink and some other order details. It needs to be HTML. </p>
  
  <p>Made sense to use SSRS since it lets me choose to send the report in the body of the email, but I could never figure out how to dynamically set the To: email. Apparently SSRS has a feature called Data Driven Subscriptions, but as usual, I happen to have a cheaper version of SQL Server that doesnt include that. </p>
  
  <p>I figured, no big deal. I will do it SSIS. So I write my Tasks and Send an email, but I can only send the report as an attachment. Apparently, SSIS cannot send HTML.</p>
  
  <p>So now I'm back to square one. </p>
  
  <p>I am at the point now where I can get SSIS to generate a .pdf, .html, or .txt file, save it in a folder and send that as an attachment. </p>
  
  <p>How do I send an SSRS or Crystal Report in the body of an email based on the results of a query? Do I need to ditch SSIS and use something completely different?</p>