Dim ObjSendMail
Set ObjSendMail = CreateObject("CDO.Message")
'ṩԶSMTPϢ
ObjSendMail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2 'ʹʼͨSMTP
ObjSendMail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "smtp.163.com" 'SMTP
ObjSendMail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25
ObjSendMail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpusessl") = False 'ʹSSLTrueFalse
ObjSendMail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpconnectiontimeout") = 60
' ķʼҪSMTP֤ע·ʹһЧĵʼַ롣
ObjSendMail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = 1 'clear-text֤
ObjSendMail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/sendusername") =""
ObjSendMail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/sendpassword") ="***" 'ĵʼַ
ObjSendMail.Configuration.Fields.Update
'ԶSMTP
ObjSendMail.To = "" 'ռ˵ַ
ObjSendMail.Subject = "¶" '
ObjSendMail.From = "" 'ȷsendusernameͬ
'ڷʼ..л´HTMLʼ
ObjSendMail.HTMLBody = "Ʒ"&rsoks("s1")&"
"&rsoks("je")&"
"&rsoks("s2")&"
ַ"&rsoks("s3")&"
绰"&rsoks("s4")&"
ע"&rsoks("s5") '
ObjSendMail.TextBody = "" 'ʼ
ObjSendMail.Send