Using VB Script to email....  
Author Message
PuPpYpc





PostPosted: Thu Jul 17 03:25:25 CDT 2003 Top

SQL Server Developer >> Using VB Script to email....

Hello,

I am attmepting to use VB Script to send email from a job
step. Does anyone have a VB Script that sends out email
from a job? I do not want to use xp_sendmail... I want to
use VB Script. I am running Windows 2000 Server and SQL
Server 2000.

Please advise...

Thank you,

Brett MCP

SQL Server157  
 
 
Martin





PostPosted: Thu Jul 17 03:25:25 CDT 2003 Top

SQL Server Developer >> Using VB Script to email.... Brett,

you can use the CDONTS.NewMail object.
Look for it in the online documentation or in google. You will find lots of
examples.

Martin



> Hello,
>
> I am attmepting to use VB Script to send email from a job
> step. Does anyone have a VB Script that sends out email
> from a job? I do not want to use xp_sendmail... I want to
> use VB Script. I am running Windows 2000 Server and SQL
> Server 2000.
>
> Please advise...
>
> Thank you,
>
> Brett MCP
>


 
 
Martin





PostPosted: Thu Jul 17 03:49:37 CDT 2003 Top

SQL Server Developer >> Using VB Script to email.... Brett,

you can use the CDONTS.NewMail object.
Look for it in the online documentation or in google. You will find lots of
examples.

Martin



> Hello,
>
> I am attmepting to use VB Script to send email from a job
> step. Does anyone have a VB Script that sends out email
> from a job? I do not want to use xp_sendmail... I want to
> use VB Script. I am running Windows 2000 Server and SQL
> Server 2000.
>
> Please advise...
>
> Thank you,
>
> Brett MCP
>