"this sounds like an anti-virus problem"

Mr Magoo wins the prize. I installed FileZilla FTP yesterday.. and some antivirus software got installed along with it. I uninstalled that... no more problem

Thank...

Thank you to you both for the suggestions. I haven't made time to investigate these proposed solutions, but I'll let you know the results when I do.

Thanks,

Joe

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]