Domino下通过vbs脚本删除指定主题邮件---脚本文件

'数据库路径 
folder ="\D$\IBM\Lotus\Domino\data\mail" 
subject =Trim(InputBox("请输入邮件主题:","提示"))

'添加服务器地址,逗号隔开 
serverArray=Array("192.168.220.11","192.168.220.12")

For i= LBound(serverArray) To UBound(serverArray) 
    mailFolder = "\\" & serverArray(i) & folder 
    Set fso = CreateObject("scripting.fileSystemObject") 
    Set folderObj = fso.GetFolder(mailFolder) 
    For Each file In folderObj.Files 
     names = Split(file.Name,".",-1) 
     Call DeleteSubjectDocument(serverArray(i),names(0),subject) 
    Next 
Next

MsgBox "执行完成"

Sub DeleteSubjectDocument(server,user,subject) 
On Error Resume Next 
  Dim aNotes 
  Dim aDatabase 
  Dim aDC 
  Dim aDoc 
  Dim i 
  Dim dt 
  
  Set aNotes = CreateObject("Notes.NotesSession")  
   ' 获取服务器上指定数据库 
  Set aDataBase = aNotes.GetDatabase(server, "mail/" & user) 
  ' 指定日期 
'  Set dt = aNotes.CREATEDATETIME("12/22/12")  
'  Set aDC = aDatabase.Search("@Contains(Subject;""test"")", dt, 0) 
  Set aDC = aDatabase.Search("@Contains(Subject;"""&subject&""")", Nothing, 0) 
  Call aDC.RemoveAll(True) 
if err.Number >0 Then 
   WriteLog "server=" & server & ",user=" &user &"删除主题:"& subject &",info:数据库拒绝访问" 
Else 
   WriteLog "server=" & server & ",user=" &user &"删除主题:"& subject &",info:操作完成" 
End If 
  Set aNotes = Nothing 
  Set aDatabase = Nothing 
  Set aDC = Nothing 
  Set aDoc = Nothing 
  Set dt = Nothing    
End Sub


Sub WriteLog(info)

logFolder = "c:\log" 
Set fso = CreateObject("scripting.FileSystemObject") 
If Not fso.FolderExists(logFolder) Then 
      fso.CreateFolder logFolder 
End If 
filepath=logFolder & "\mail_log.txt" 
Set logFile = fso.OpenTextFile(filepath,8,True) 
logFile.WriteLine Now() & ": " & info 
logFile.Close

Set logFile = Nothing 
Set fso = nothing 
End Sub



本文转自 高文龙 51CTO博客,原文链接:http://blog.51cto.com/gaowenlong/1098089,如需转载请自行联系原作者

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值