Capturing htm formatted source to email via CDO

[GraeagleBill]

I've been using Colin's contribution to the Forum (See #5 in Programming: "Sending emails with VBA CDO") that tests the use of CDO to send emails. Both of Colin's simple text and HTML tests work exactly "as advertised". I've adopted the simple text code behind a form where a user can specify the To, From, Subject and Body and "send" without any difficulty. The body text can be entered into the spacious text box on the form from which the "Body Field" in CDO can be set in addition to the related fields and the email sent.



So, given the esoteric nature and syntax of htm together with the limited nature of an Access text box control, it would seem that one would have to create htm coded text outside of Access then paste the "htm source" into a form's text box. Or, am I missing something that is built into Access I've not yet discovered?

Thanks,
Bill

[isladogs]

Hi again
Personally I don't use HTML email often with CDO and have never bothered to setup a form to handle that specifically.

As already mentioned in a private email to you, inline images are usually blocked by email apps such as Outlook, Windows Mail & GMail.
For that reason, HTML email is a less attractive option these days than used to be the case

However, I do have other forms that create complex HTML content including formatted text, inline images, hyperlinks and video links e.g. You Tube.
For example for a help system with one of my large commercial apps which has both a rich text screen (formatted text only) as well as an HTML version (with all the above)
To create the HTML version I use a web browser control

For example, this is the form used for editing content - both rich text (on the left) and HTML (on the right)
Apologies for the large screenshots - these are full screen forms



This shows the HTML source code:



The HTML output is probably more complex than most HTML emails. Here is a printout of a relatively simple topic created using this form:


The same method can be used to create topics covering multiple pages with numerous images & hyperlinks.
However be warned - setting up this form was a lot of work

Hope that helps


.

[GraeagleBill]

I'll play with what I've done so far plus experiment with the browser control so I can best determine how to capitalize on my newfound discovery of CDO. Clearly, CDO will help provide more user friendly UI when bulk emailing come into play.

I'll mark the OP as solved, as anyone following the thread should get see the breadth of using CDO, especially if they download and examine your tester code like I did.

Thanks again,
Bill