howto: send a mail, exchange script read your mail

作者:袖梨 2022-06-30
Again, no error handle, no optimize, just demo test...
paste this to your exchange event script
========================================================
T 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=demo;uid=sa;pwd="
    oConn.Open dbcnstr
    Set oRs = CreateObject("ADODB.Recordset")

相关文章

精彩推荐