CDO 2000, that you're using, doesn't use or require Outlook. It directly communicates with a SMTP server. The error message indicates that it cannot connect to the SMTP server specified for whatever reason.

>I've tried one of your given reference(http://www.orcsweb.com/articles/sendmailsql.aspx) and it works good on it and it delivers directly to the recepients via msoutlook. Please see below the following code.
<snip>
>------------------
>however when I try to run this morning I'm afraid I've encounter an error and please see below:
>-----------------------------------------
>(1 row(s) affected)
>
>
> Description: The message could not be sent to the SMTP server. The transport error code was 0x800ccc15. The server response was not available
>-----------------------------------------
>do you have any idea on this? Thanks.
>