A better response to this might be that there are many ways to do what you want to do. A few of the better ones involve running a nightly SQL Server Agent job to generate the email, then use a COM object to send it. SQL Server Jobs are very very flexible, I use them to run scheduled VBScript quite often. My suggestion is do some research as to what your best options are for actually sending the email. Then make a table with fields something like EmailID, Sender, Recipient, Subject, Body, and DateSent. Insert rows into that table, one for each email you want sent. After you have the email in there, you can select it out in VBScript and send it using a COM object.