¡¡¡¡
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 'ÓÚÁ¬½ÓÖÐʹÓÃSSL£¨True»òFalse£©
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