





























Sub Send(Subject As String, Body As String, SendTo As String)
Dim OlApp As New Outlook.Application
Dim mail As Outlook.MailItem
Set mail = myOlApp.CreateItem(olMailItem)
mail.To = SendTo
mail.Subject = Subject
mail.HTMLBody = Body
mail.Send
End Sub
Sub SendFromCell()
Dim sh As Worksheet
Set sh = ThisWorkbook.Worksheets("Sheet1")
Send sh.Cells(2, 1), sh.Cells(2, 2), sh.Cells(2, 3) & "@DoMainName"
End Sub
此内容由惯性聚合(RSS阅读器)自动聚合整理,仅供阅读参考。 原文来自 — 版权归原作者所有。