Sub 筛选OutLook主题并转发()
On Error Resume Next
Dim OutApp As Application
Set OutApp = Application
Dim OutMail As MailItem
Dim OneAccount As Account
Dim UsingAccount As Account
Dim OutNameSpace As NameSpace
Dim OneFolder As Folder
Dim subFolder As Folder
Dim OneBody As String
Dim ToName As String
Dim FwdItem As MailItem
Dim NewBody As String '要在OutLook里配置一个POP3的账户 用来发送邮件
For Each OneAccount In Application.Session.Accounts
If OneAccount.AccountType = olPop3 Then
Set UsingAccount = OneAccount '找到账户
Debug.Print "测试账户>>"; UsingAccount.UserName
Exit For
End If
Next OneAccount Set OutNameSpace = OutApp.GetNamespace("MAPI")
For Each OneFolder In OutNameSpace.Folders If OneFolder.Name = "next@126.com" Then '此处改为你收件OutLook的账户名(就是收到对不起XXX的那个邮箱名称)
For Each subFolder In OneFolder.Folders '循环所有的文件夹
For Each OutMail In subFolder.Items '循环所有邮件
Debug.Print OutMail.Subject
If InStr(1, OutMail.Subject, "对不起") > 0 Then '如果标题含有对不起三个字
ToName = Split(outMailSubject, "-")(0) '对不起,XXX后面是什么符号, 引号内则填什么符号 比如横杠-
ToName = Split(ToName, ",")(1) '对不起和XXX之间什么符号,引号内就填什么符号 比如中文 逗号, Set FwdItem = OutMail.Forward '转发 '构建新的邮件内容
NewBody = "Hello " & ToName & vbCrLf
NewBody = NewBody & " Your payment to " & ToName & " is declined" & vbCrLf
NewBody = NewBody & "Hi hi" & vbCrLf
NewBody = NewBody & FwdItem.Body FwdItem.Recipients.Add ("8485@qq.com") '填写转发地址
FwdItem.Recipients.Add ("7866@qq.com") '添加更多的转发地址 就再复制一行
FwdItem.Subject = "Hello " & ToName '转发的标题
FwdItem.Body = NewBody '转发的内容
FwdItem.SendUsingAccount = UsingAccount '发送使用的账户
FwdItem.Send '发送 End If
Next
Next
End If
Next Set OutApp = Nothing
Set OutNameSpace = Nothing
Set OutMail = Nothing
Set OneFolder = Nothing
Set subFolder = Nothing
Set UsingAccount = Nothing
End Sub

  

最新文章

  1. Python 类(一)
  2. Intellij Idea中定制getter setter的模板
  3. 深入理解CSS中的长度单位
  4. locale的设定及其LANG、LC_ALL、LANGUAGE环境变量的区别
  5. Hadoop作业JVM堆大小设置优化 [转]
  6. google proto buffer安装和简单示例
  7. A Statistical View of Deep Learning (V): Generalisation and Regularisation
  8. drwtsn32.exe 遇到问题须要关闭。我们对此引起的不便表示抱歉
  9. MySQL表结构同步工具 mysql-schema-sync
  10. BZOJ 1191: [HNOI2006]超级英雄Hero(二分图匹配)
  11. Spring MVC中前后台数据传输小结
  12. 用js来实现那些数据结构12(散列表)
  13. 关于JavaScript中的几种匿名行数的写法
  14. Hello greenDAO(SQLite)
  15. SQL server 一些小结
  16. 如何利用pip自动生成和安装requirements.txt依赖
  17. Python基础语法-基本数据类型
  18. Haskell语言学习笔记(39)Category
  19. 连接数据库:ERROR:The server time zone value '?й???????' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration prop
  20. hdu 5224 Tom and paper 水题

热门文章

  1. Python: 正则表达式匹配多行,实现多行匹配模式
  2. ORA-00980: 同义词转换不再有效
  3. [转载] My97DatePicker日历实现开始日期小于结束日期验证
  4. Python之路----递归函数
  5. 0-5v转0-20ma和0-5v转4-20ma
  6. servlet之一(概念/如何写/运行/错误提示/乱码处理)
  7. Linux查看文件大小命令
  8. 20145314郑凯杰《网络对抗技术》实验8 WEB基础实践
  9. 20165211 预备作业3 Linux安装与学习
  10. DTMF在VOIP中的解决方案