Decoding HTML for CDO delivery

[travisbrown]

Been looking for a while for this one.

I have some html in a table that i need to send out by email through cdo. HTML Looks like this:

<p>This is a test to see the sort of content one can include in the email send field.</p><p>Paragraph breaks and all.</p>

How can I decode it so it sends out a pretty HTML email that doesn't look like this? I've looked at some of the HTML and URLDecoding functions, but nothing seems to have any effect.

<p>This is a test to see the sort of content one can include in the email send field.</p><p>Paragraph breaks and all.</p>

 

[theniteowl]

Look at HTMLEncode

http://www.w3schools.com/asp/met_htmlencode.asp

Stamp out, eliminate and abolish redundancy!

 

[travisbrown]

Yeah, I'm trying to go the other way. Decoding rather than encoding. The text is encoded in the db. The html email won't render the html like the browser does. Shows the tags like in the second code example.

I found a post/function by Damber that helped:

http://www.tek-tips.com/viewthread.cfm?qid=1157666

Works when using cdo htmlsend