Murray Brown
asked on
Access VBA send email with html body
Hi
How do I modify the following VBA code so that I can send the body of the email
as html eg
How do I modify the following VBA code so that I can send the body of the email
as html eg
Dim oHBody As String = ""
oHBody = oHBody & "<html><body><font size=3 color=" & sColor1 & " name = 'Calibri'>" & oIntro & "</font></body></html>"
oHBody = oHBody & "<br>"
Sub SendReports(DisplayMsg As Boolean, Optional AttachmentPath)
Dim objOutlook As Object
Dim objOutlookMsg As Object
' Create the Outlook session.
Set objOutlook = CreateObject("Outlook.Application")
' Create the message.
Set objOutlookMsg = objOutlook.CreateItem(0)
With objOutlookMsg
'.To = strTo
'Subject = strSubject
'.Body = strBody
'.Attachments.Add strAttach
'.Save
'.Open
End With
Set objOutlook = Nothing
End Sub
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER