¿ÉÒÔ½«Õâ¶Î´úÂëǶÈëaccessµÄÄ£¿é¡¢excelµÄºêÖÐÔËÐС£
³ÌÐòÒªÇó£º
ÐèÒªÒýÓÃ"microsoft outlook x.x library"
´úÂ룺
sub email_send()
Dim olkapp As Outlook.Application
Dim newmail As MailItem
Dim emailadd,para as String
Set olkapp = CreateObject("outlook.application")
Set newmail = olkapp.CreateItem(olMailItem)
'ÓʼþÕýÎÄÄÚÈÝ
para = para+"ףдº¿ìÀÖ£¬²¢ÓÑÇéÌáÐÑ×¢ÒâеÄÓʼþ²¡¶¾¡£"
'ÊÕ¼þÈ˵ÄemailµØÖ·£¬ÕâÀïûÓÐÊäÈëÄÚÈÝ¡£
emailadd = ""
With newmail
.To = emailadd
.Subject = "дº¿ìÀÖ" ' ÓʼþµÄÖ÷Ìâ
.Importance = olImportanceHigh 'ÓʼþµÄÎªÖØÒªµÈ¼¶
.Body = para '½«ÓʼþÕýÎÄÄÚÈÝÖ¸¶¨para±äÁ¿ÄÚÈÝ
.Send '·¢ËÍ
End With
end sub
,| ×ÔÓÉ¹ã¸æÇø |
| ¡¡ |