I just tried to write a code which, upon clicking on a button should send an email with attachment. I succeded by using some of the posts here, but however I need to add some special effects in between...
In the body of the email, I need to Bold and change 2 lines to blue. Like this:
Dim objOutlook As Object
Dim objOutlookMsg As Object
Set objOutlook = CreateObject("Outlook.Application")
Set objOutlookMsg = objOutlook.CreateItem(0)
.To = "firstname.lastname@example.org "
.Cc = "email@example.com"
.Subject = "Hello Friends (one more time)..."
.Body = "This is the body of message"
.HTMLBody = "HTML version of message"
.Send 'send the mail
Set objOutlookMsg = Nothing
Set objOutlook = Nothing