(Excel) Send HTML Email with Image Downloaded from URL

Demonstrates how to compose an HTML email with an embedded image where the image data is downloaded from a URL.

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.

' First download the image we'll be adding to the HTML "img" tag.
Dim bdJpg As Chilkat.BinData
Set bdJpg = Chilkat.NewBinData
Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

success = http.QuickGetBd("https://www.chilkatsoft.com/images/starfish.jpg",bdJpg)
If (success = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Dim mailman As Chilkat.MailMan
Set mailman = Chilkat.NewMailMan

' Use your SMTP server..
mailman.SmtpHost = "smtp.yourserver.com"
mailman.SmtpPort = 587
mailman.StartTLS = True

' Set the SMTP login/password
mailman.SmtpUsername = "my_login"
mailman.SmtpPassword = "my_password"

' Create an HTML email.
Dim email As Chilkat.Email
Set email = Chilkat.NewEmail
email.Subject = "HTML Email with Image"
email.From = "Dave <somebody@mydomain.com>"
Dim success As Boolean
success = email.AddTo("Chilkat","info@chilkatsoft.com")


html = "<html><body><p>This is an HTML email with an embedded image.</p><p><img src=""starfish.jpg"" /></p></body></html>"
email.SetHtmlBody html

' Note: The "starfish.jpg" here must match the name in the "img" tag's "src" attribute in the HTML above.
success = email.AddRelatedBd2(bdJpg,"starfish.jpg")
If (success = False) Then
    Debug.Print email.LastErrorText
    Exit Sub
End If

success = email.SaveEml("qa_output/out.eml")

' success = mailman.SendEmail(email);
' if (success == ckfalse) {
'     println mailman.LastErrorText;
'     return;
' }
' 
' ignore = mailman.CloseSmtpConnection();

Debug.Print "Success."