我在我的oulook中从一个VBA社区复制了以下代码,并根据我的需要对其进行了修改。我可以使用F5和F8运行它。现在,每当我收到folder1中的电子邮件时,我都想运行这个宏。我尝试设置一个规则,但在“运行脚本”选项框中看不到列出的宏。我已经查过了
你能告诉我现场出了什么问题吗?
Public Sub SaveAttachments()
Dim myOlapp As Outlook.Application
Dim myNameSpace As Outlook.NameSpace
Dim myFolder As Outlook.MAPIFolder
Dim yourFolder As Outlook.MAPIFolder
Dim myItem As Outlook.MailItem
Dim myAttachment As Outlook.Attachment
Dim I As Long
Set myOlapp = CreateObject("Outlook.Application")
Set myNameSpace = myOlapp.GetNamespace("MAPI")
Set myFolder = myNameSpace.GetDefaultFolder(olFolderInbox)
Set yourFolder = myNameSpace.GetDefaultFolder(olFolderInbox)
Set myFolder = myFolder.Folders("folder1")
Set yourFolder = yourFolder.Folders("folder2")
For Each myItem In myFolder.Items
If myItem.Attachments.Count <> 0 Then
For Each myAttachment In myItem.Attachments
I = I + 1
myAttachment.SaveAsFile "C:\arthur\test.csv"
Next
End If
myItem.Move yourFolder
Next
End Sub发布于 2018-09-19 20:01:52
在Office升级到1803版(Build 9126.2282)之后,今天我在一个类似的脚本上也出现了同样的问题。从潜艇中移除"Pubic“关键字起了作用。不知道为什么,因为多年来一直在以另一种方式工作。
我还必须重新添加已消失的reg键- EnableUnsafeClientMailRules。
https://stackoverflow.com/questions/17493093
复制相似问题