Outlook VBA发送后删除邮件
问题描述:
我正在写一个宏,允许我通过附件转发当前邮件(通过功能区上的按钮运行宏),然后删除原始邮件。Outlook VBA发送后删除邮件
但是,当我运行宏消息不会被删除,我收到一封来自“系统管理员”的电子邮件,消息是un-deliverable
。
如果我注释掉该行.DeleteAfterSubmit = True
该消息已发送但未删除。
Dim objAttachment As Attachment
Dim strAttachment As String
Set objItem = GetCurrentItem()
Set objMsg = Application.CreateItem(olMailItem)
strAttachment = ""
For Each objAttachment In objItem.Attachments
strAttachment = strAttachment & " " & objAttachment.DisplayName ' FileName
Next
With objMsg
.Attachments.Add objItem, olEmbeddeditem
.Subject = objItem.Subject & " " & objItem.To
.To = "[email protected]"
.Body = "From: " & objItem.Sender & vbNewLine & _
"Sent: " & objItem.ReceivedTime & vbNewLine & _
"To: " & objItem.To & vbNewLine & _
"CC: " & objItem.CC & vbNewLine & _
"Subject: " & objItem.Subject & vbNewLine & _
"Attachment: " & strAttachment & vbNewLine & vbNewLine & _
objItem.Body
.DeleteAfterSubmit = True
.Send
End With
答
应该objItem.Delete
外With...End With
With objMsg
.Attachments.Add objItem, olEmbeddeditem
.subject = objItem.subject & " " & objItem.To
.To = "[email protected]"
.Body = "From: " & objItem.sender & vbNewLine & _
"Sent: " & objItem.ReceivedTime & vbNewLine & _
"To: " & objItem.To & vbNewLine & _
"CC: " & objItem.CC & vbNewLine & _
"Subject: " & objItem.subject & vbNewLine & _
"Attachment: " & strAttachment & vbNewLine & vbNewLine & _
objItem.Body
.Send
End With
objItem.Delete
我认为这只是防止在_Sent Items_ – jsotola
objMsg.Delete或objItem.Delete这取决于你想删除哪一个省 – Sorceri