当我尝试使用 VBScript 将 MHTML 文件作为电子邮件附件添加到电子邮件中时,ContentMediaType
被错误地设置为"message/rfc822"
(RFC 822)。据我了解,根据 Microsoft 的说法这是正确的,但根据RFC 2557其中指出应该是"multipart/related"
。这是一个问题,因为大多数(如果不是全部)邮件客户端都会解释"message/rfc822"
作为电子邮件消息。由于文件扩展名".mht"
and ".mhtml"
不匹配电子邮件的任何有效文件扩展名,邮件客户端会附加以下之一".msg"
, ".eml"
等到文件名。当用户打开附件时,它会作为电子邮件打开,并且无法正确显示,因为 MHTML 文件和电子邮件的保存方式不同。
Sub SendEmail(FromAddress, ToAddress, Subject, Body, Attachment)
Call Err.Clear
On Error Resume Next
Schema = "http://schemas.microsoft.com/cdo/configuration/"
Set Configuration = Sys.OleObject("CDO.Configuration")
Configuration.Fields.Item(Schema + "sendusing") = 2
Configuration.Fields.Item(Schema + "smtpserver") = SMTPServer
Configuration.Fields.Item(Schema + "smtpserverport") = 25
Configuration.Fields.Item(Schema + "smtpauthenticate") = 1
' Configuration.Fields.Item(schema + "sendusername") = ""
' Configuration.Fields.Item(schema + "sendpassword") = ""
Call Configuration.Fields.Update
Set Message = Sys.OleObject("CDO.Message")
Set Message.Configuration = Configuration
Message.From = FromAddress
Message.To = ToAddress
Message.Subject = Subject
Message.HTMLBody = Body
If Not IsEmpty(Attachment) Then
'CDO.Message.AddAttachment doesn't set the correct content media type for an MHTML file.
Call Message.AddAttachment(Attachment)
End If
Call Message.Send
End Sub
当我运行这段代码时,Message.Attachments.Item(1).ContentMediaType
被设定为"message/rfc822"
。我需要它是"multipart/related"
if Attachment
(字符串)以以下结尾".mht"
or ".mhtml"
(不区分大小写)。我可以用下面的代码来做到这一点。
If Len(Attachment) >= 4 And InStr(Len(Attachment) - 3, Attachment, ".mht", vbTextCompare) Or Len(Attachment) >= 4 And InStr(Len(Attachment) - 5, Attachment, ".mhtml", vbTextCompare) Then
Message.Attachments.Item(1).ContentMediaType = "multipart/related"
End If
由于某种未知的原因,这取消了附件的定义Message.Attachments
.
我已经考虑过手动添加附件这些说明,但是当我打电话时Message.Attachments.Item(1).Fields.Update
,该对象变得未定义。我想设置附件的ContentMediaType
,隐式调用它的Fields
's Update
我认为这是造成这种意外行为的方法。
我怎样才能解决这个问题并发送带有以下内容的 MHTML 文件"multipart/related"
内容类型,同时保持正确的文件扩展名?