gpt4 book ai didi

vba - Outlook 2010 自定义 VBA 脚本将传入的邮件消息移动到特定文件夹

转载 作者:行者123 更新时间:2023-12-04 19:19:39 25 4
gpt4 key购买 nike

我正在尝试为 Outlook 2010 创建一个自定义规则,用于检查电子邮件的主题,如果它生成正则表达式,则它会被移动到特定文件夹中。

但是,当我运行脚本时,当我尝试获取要将邮件移动到的文件夹的 Outlook.Folder 对象时,出现以下错误:

Run-time error '91':
Object variable or With block variable not set



下面是我用来检查电子邮件主题并将邮件移动到指定文件夹(如果匹配)的 VBA 脚本。
Sub MoveToETS(Item As Outlook.MailItem)
Dim Subject As String
Subject = Item.Subject

Dim FolderToMoveTo As Outlook.Folder
Set FolderToMoveTo = GetFolder("ETS")

If (CheckSubject(Subject, "^[Project|Bug] (\d+?) - \[[UPDATE|NEW|RESOLVED]\]")) Then
Item.Move (FolderToMoveTo)
End If
End Sub

Function CheckSubject(Subject As String, PatternToCheck As String)
Dim ObjRegExp As RegExp
Dim ObjMatch As Match

Set ObjRegExp = New RegExp
ObjRegExp.Pattern = PatternToCheck

If (ObjRegExp.Text(Subject) = True) Then
CheckSubject = True
End If

End Function

Function GetFolder(ByVal FolderName As String) As Outlook.Folder

Dim ObjFolder As Outlook.Folder

Set ObjFolder = Outlook.Application.Session.GetDefaultFolder(olFolderInbox).Folders("ETS")

GetFolder = ObjFolder

End Function

最佳答案

你的最后一行需要是

Set GetFolder = ObjFolder

关于vba - Outlook 2010 自定义 VBA 脚本将传入的邮件消息移动到特定文件夹,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/5589665/

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com