在Outlook(VBA)中添加主题标题
时间:2020-03-06 14:22:53 来源:igfitidea点击:
基本上,我们有一个规则设置,可以在传入消息的正文中检测到代码字时运行脚本。该脚本将在当前主题标头的前面添加一个单词。例如,之前:"测试消息",之后:"部门测试消息"。有任何想法吗?
解决方案
未经测试:
mailItem.Subject = "Dept - " & mailItem.Subject mailItem.Save
或者,如果我们需要整个脚本:
使用MailItem作为参数执行"运行脚本"。
Sub RewriteSubject(MyMail As MailItem)
Dim mailId As String
Dim outlookNS As Outlook.NameSpace
Dim myMailItem As Outlook.MailItem
mailId = MyMail.EntryID
Set outlookNS = Application.GetNamespace("MAPI")
Set myMailItem = outlookNS.GetItemFromID(mailId)
' Do any detection here
With myMailItem
.Subject = "Dept - " & mailItem.Subject
.Save
End With
Set myMailItem = Nothing
Set outlookNS = Nothing
End Sub
Sub AppendSubject(MyMail As MailItem)
Dim strID As String
Dim mailNS As Outlook.NameSpace
Dim mailItem As Outlook.MailItem
strID = MyMail.EntryID
Set mailNS = Application.GetNamespace("MAPI")
Set mailItem = mailNS.GetItemFromID(strID)
mailItem.Subject = "Dept - " & mailItem.Subject
mailItem.Save
Set mailItem = Nothing
Set mailNS = Nothing
End Sub
我们错过了什么吗?编辑:Doh!我们已经用完整的脚本回答了我们的问题...谢谢!

