日期:2008-12-12  浏览次数:20964 次

no error handle, no optimize, just demo test...
paste this to your exchange event script

=========================================================
<SCRIPT RunAt=Server Language=VBScript>


Option Explicit


' Event Handlers
'---------------------------------------------------------------------
' DESCRIPTION: This event is fired when a new message is added to the folder

Public Sub Folder_OnMessageCreated

    On Error Resume Next

    Dim AMSession
    Dim fldrOutbox
    Dim msgTarget
    Dim fldrTarget

    Dim oStores
    Dim Temp
    Dim idTargetFolder
    Dim idTargetMessage
    Dim msgResponse

    idTargetFolder = EventDetails.FolderID
    idTargetMessage = EventDetails.MessageID

    Set AMSession = EventDetails.Session
    Set fldrOutbox = AMSession.Outbox

    Set fldrTarget = AMSession.GetFolder( idTargetFolder, Null )
    Set msgTarget = AMSession.GetMessage( idTargetMessage, Null )
' =========================================================================

    Dim oConn
    Dim oRs
    Dim Index
    dim strDBResult
    dim dbcnstr
                
    Set oConn = CreateObject("ADODB.Connection")

     dbcnstr = "driver={SQL Server};server=sqlserver;database=" & msgTarget.subject & ";uid=sa;pwd="

    oConn.Open dbcnstr

    Set oRs = oConn.Execute("SELECT * From " & msgTarget.text)
    
    Do while (Not oRs.eof)
        For Index=0 to (oRs.fields.count-1)
            strDBResult = strDBResult & "   |   " & chr(9) & oRs(Index)
        Next
        strDBResult = strDBResult & chr(13)
    oRs.MoveNext
    Loop

    oRs.close
    oConn.close

' =========================================================================    
    Set msgResponse = fldrOutbox.Messages.Add( "Query Result for database:" & msgTarget.subject & ";table:" & msgTarget.text, strDBResult)
    msgResponse.Recipients.Add "", "", 1, msgTarget.Sender.ID
    msgResponse.Recipients.Resolve(False)
    msgResponse.Send
    
End Sub

' DESCRIPTION: This event is fired when a message in the folder is changed
Public Sub Message_OnChange
    On Error Resume Next

End Sub

' DESCRIPTION: This event is fired when a message is deleted from the folder
Public Sub F