Thanks for the information, I shall try and find the switches you mean.

CREATE PROCEDURE dbo.sp_predictionout AS

Declare @directory char(50), @pkzipname char(50), @tfilename char(50), @bcpcommand char(50)

Declare @name char(8), @filename char(50), @nrow int

DECLARE cName CURSOR FOR

select name from IC_PREDICTION.dbo.sysobjects

where crdate>=CONVERT(char, getdate(),...

mmm. When I posted this I'm sure it had more data in it. I'm looking for which one is better when automating task that will run after a stored procedure.

At...

I fined that using smtp is just as good

Have tried the examples but the attachemnt did not turn up.

Please could someone help

Has anyone managed to send attachmenst using cdosys.

Would be interested to know how you did it.