asked on
Function Mail_Out(ByVal EMailAddress As String, Optional ByVal EMailSubject As String = "", _
Optional ByVal EMailMessage As String = "")
Dim application As Outlook.Application
Dim objItem As Outlook.MailItem
application = CreateObject("Outlook.Application")
objItem = application.CreateItem(Outlook.OlItemType.olMailItem)
objItem.Subject = EMailSubject
objItem.To = EMailAddress
objItem.HTMLBody = Mail_FirstShift
objItem.Send()
application = Nothing
objItem = Nothing
Return DBNull.Value
End Function