Using CDO to email HTML content in the body of the email

[GraeagleBill]

I found a few places online that reference CDO as the only method that provides the means to embed graphic content within the body of an email. However, I've not found exactly how to do that. Does one create an HTML file and then some how use the CDO.Message object to load the body?



Now that I've post'd, I found this: https://answers.microsoft.com/en-us/...a-9c18d8f94a95

The link will ultimately lead one to the use of a procedure to read files into a variable that can subsequently be assigned to the text property of the CDO object. The only issue I see there is that the file types are txt, csv and SQL, but no reference to HTML files. I remain puzzled.

Here's what I missed, there's another CDO property: .HTMLBody that one assigns the HTML string using the procedure referenced within the link above.

I shall experiment............... Any additional suggestions would be most welcomed!

[Micron]

I don't think you need CDO to embed an image in an html body. CDO is useful because you can bypass the email app and work with the email server directly. The only reason I ever used it was to get around the security prompt we used to get at that time. It also allowed me to send mail without using my own email account.

I believe the tag you need is like "<img src=cid:ImageFileNameHere></img>"

[GraeagleBill]

So, you're saying that one simply inserts like "<img src=cid:ImageFileNameHere></img>" directly into a String variable and sends that string as the body property? (With the file image name of course)

[Micron]

I don't think I've ever embedded an image with vba. I simply found that as a solution elsewhere, so you'll have to try it out. Before you decide it works (assuming it does) make sure you send a test email to someone who does not have access to that image file. If they can't see it but you can, then the image wasn't embedded. I would have thought the path to the file folder would be required, so that part looks suspicious. Don't forget - the email body has to be html format.