1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
|
'---------------------------------------------------------------------------------
'函数名称 : SendMail
'函数功能 : 自动发送邮件功能
'函数输入 : SendTo----收件人,多个收件人可使用";"隔开
' MailTopic----邮件主题
' MailBody----邮件内容,此处内容格式为Html
' MailAttachment---邮件附件,多个附件可使用";"隔开
'函数输出 : Boolean,邮件是否发送成功
'---------------------------------------------------------------------------------
Function
SendMail(SendFrom,Password,SendTo,MailTopic,MailBody,MailAttachment)
On
error resume next
Set
Email = CreateObject(
"CDO.Message"
)
Email.BodyPart.Charset =
"GBK"
Email.From = SendFrom
Email.
To
= SendTo
Email.Subject = MailTopic
Email.Htmlbody = MailBody
If
MailAttachment <>
""
Then
For
i=0 to Ubound(Split(MailAttachment,
";"
))
Email.AddAttachment Split(MailAttachment,
";"
)(i)
Next
End
If
With
Email.Configuration.Fields
.Item(MS_Space&
"sendusing"
) = 2
.Item(MS_Space&
"smtpserver"
) =
"smtp."
&Split(SendFrom,
"@"
,-1, vbTextCompare)(1)
.Item(MS_Space&
"smtpserverport"
) = 25
.Item(MS_Space&
"smtpauthenticate"
) = 1
.Item(MS_Space&
"sendusername"
) =Split(SendFrom,
"@"
,-1,vbTextCompare)(0)
.Item(MS_Space&
"sendpassword"
) = Password
.Update
End
With
Err.clear
Email.Send
If
Err.number<>0
Then
SendMail=
False
Else
SendMail=
True
End
If
Set
Email=
Nothing
End
Function
|
技术改变世界! --狂诗绝剑