(Excel) Send HTML Email with CSS as Related Item using Content-Location

Demonstrates how to compose an HTML email with an external CSS file included as a related item and referenced by Content-Location.

Some email clients display embedded (related) content best using CID's (Content-IDs), whereas other email clients display related content best by Content-Location. The choice you make may depend on the software used by the intended recipient of your email. (Does' the recipient read email on an iPhone? Android? Outlook? GMail? Thunderbird? etc.)

Download Excel Class Modules

Chilkat Excel Class Modules

' This example requires the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

' The mailman object is used for sending and receiving email.
Dim mailman As Chilkat.MailMan
Set mailman = Chilkat.NewMailMan

' Use your SMTP server hostname.  This example uses office365, but it could be any SMTP server..
mailman.SmtpHost = "outlook.office365.com"
mailman.SmtpPort = 587
mailman.StartTLS = True

' Set the SMTP login/password
mailman.SmtpUsername = "OFFICE365-SMTP-LOGIN"
mailman.SmtpPassword = "OFFICE365-SMTP-PASSWORD"

' Create a new email object
Dim email As Chilkat.Email
Set email = Chilkat.NewEmail
email.Subject = "HTML Email with embedded CSS"
email.From = "Chilkat Support <my-office365-user@mydomain.com>"
Dim success As Boolean
success = email.AddTo("Chilkat Support","support@chilkatsoft.com")

Dim sbCss As Chilkat.StringBuilder
Set sbCss = Chilkat.NewStringBuilder

bCrlf = True
success = sbCss.AppendLine("body {",bCrlf)
success = sbCss.AppendLine("    background-color: powderblue;",bCrlf)
success = sbCss.AppendLine("}",bCrlf)
success = sbCss.AppendLine("h1 {",bCrlf)
success = sbCss.AppendLine("    color: blue;",bCrlf)
success = sbCss.AppendLine("}",bCrlf)
success = sbCss.AppendLine("p {",bCrlf)
success = sbCss.AppendLine("    color: red;",bCrlf)
success = sbCss.AppendLine("}",bCrlf)

' The filenameInHtml is what should exists within the HTML (in the href atribute)

filenameInHtml = "styles.css"
' Call AddRelatedString2 to use Content-Location.
email.AddRelatedString2 filenameInHtml,sbCss.GetAsString(),"utf-8"

Dim sbHtml As Chilkat.StringBuilder
Set sbHtml = Chilkat.NewStringBuilder
success = sbHtml.AppendLine("<!DOCTYPE html>",bCrlf)
success = sbHtml.AppendLine("<html>",bCrlf)
success = sbHtml.AppendLine("<head>",bCrlf)
success = sbHtml.AppendLine("  <link rel=""stylesheet"" href=""styles.css"">",bCrlf)
success = sbHtml.AppendLine("</head>",bCrlf)
success = sbHtml.AppendLine("<body>",bCrlf)
success = sbHtml.AppendLine("",bCrlf)
success = sbHtml.AppendLine("<h1>This is a heading</h1>",bCrlf)
success = sbHtml.AppendLine("<p>This is a paragraph.</p>",bCrlf)
success = sbHtml.AppendLine("",bCrlf)
success = sbHtml.AppendLine("</body>",bCrlf)
success = sbHtml.AppendLine("</html>",bCrlf)

email.SetHtmlBody sbHtml.GetAsString()


success = mailman.SendEmail(email)
If (success <> True) Then
    Debug.Print mailman.LastErrorText
Else
    Debug.Print "Mail Sent!"
End If