I've successfully duplicated your solution, except I did it in a .net web form. My project is using the 4.0 .NET framework.

I tried to reproduce your solution in SSDT...

Good points, Rob--we did consider Database Mail and for the reasons Chris specified we decided to go with the SSIS option. The biggest factor in our decision was the configuration/availability...

Hi Koen, thanks for the compliment.

yes the emails do contain html/formatting. it depends on the app we are sending the email for.

the styles need to be inline, not a...

Sorry -- didnt read your post close enough. My suggestion is goingto give u what u are already getting... Ill take a closer look, send a solutionif i have one

Would this work:

select isnull(addressline1, '') + isnull(addressline2,'') "Address/AddressLine"....[rest of sql]