Hi Joseph

U r article is excellent!!!...

A small problem i noticed it, though it is working successfully, data getting appended with old data, so in effect SQL Excecute task is not dropping the table..

can anybody tell me why and how I can solve it?

Thanks in advance

Agson C A

My post has nothing to do with capturing the error description, but after ten minutes of searching for a 'new thread' button I give up.

What I am looking for is more leeway in formatting the email. In sqlmail I am able to insert cr's and lf's, but the same syntax doesn't work in the activex mail.

Can someone point me in the right direction to research this further?

Thanks,

Dunc

Wildh, i've found the opposite.  You don't need to delete and recreate the csv file, the original data is replaced with the new data, at least in my experience.

Excellent just the kind of thing I need ....

Now if someone could give me a tip on using a parameterized stored Procedure instead of a view of a table ... and how to invoke that from a .net application it would absolutely make my day!!!!

nano

I also had the drop table problem, I just removed the quotes altogether, which seemed to solve the problem

I have a problem with the ActiveX script, it results in an error

Error Code: 0

Error Source: CDO.Message.1

'The SendUsing configuration value is invalid'

Error Line : 13

David