Thanks very much for this.

As I am new to Database Mail (as you can obviously tell) - can you suggest which settings I need to amend...

As far as...

Hi Alex

Thanks so much for your reply - much appreciated.

I have added the extra line as you describe, and sent both with 'Text' and 'HTML':

@body_format= 'TEXT'.

However, the Provider...

Hi Grasshopper

I've been trying exactly what you say. This has always worked well in the past. However, I haven't got it cracked yet... I'll keep trying.

Many thanks...

Thanks, Ray K

Much appreciated.

I've just had a useful reply from sitepoint.com

Paul

Thanks, Grant and OCTom

I'll check them out...

Best wishes

Paul

Hi ToddASD

No. All very frustrating. I can't find any logic in what is happening...

I wish you all the best in your own upgrade.

Paul

Hi Lowell

Thanks for your reply. I'll check out codeproject.com.

Best wishes

Paul

Thanks, Bruno

Yes, I can do that fine...

Best wishes

Paul

Hi Andy

Thanks again for your reply.

What I was hoping to be able to do was to buzz off a lot of emails by using the 'People' rescordset and iterating through...

Hi Andy

Thanks for your reply.

Just the first one. I click OK, expecting to see the next one, but nothing happens...

Thanks

Paul

Hi

Excellent article, Andy.

I hope someone is still watching this. I'm just upgrading from DTS and need all the help I can get...

I want to eventually use this code for...

Thanks, Phil

I really appreciate your very good advice.

Best wishes

Paul

Hi Phil

Yes, it was a typo. And yes what you suggested worked...

What I'm finding is that the data returned from the subquery (which uses the same field each time...

Hi Phil

Sorry for the late reply - I haven't had a chance to get near it...

I re-did the whole thing yet again to see if I could begin to understand...

Hi Phil

I've just tried this and it appears to be correct in the Transformation Task. I changed the field types and length. Then in the Destination I deleted...