DoCmd SendObject - send an email with a richtext formatted field - not working

[atrium]

The table filed is specified as Rich Text, the same field on the form is specified as Rich Text.

When I include the field in the body of the message I have all the html showing

I use

DoCmd.SendObject , , acFormatRTF, varName, varCC, , varSubject, varBody, False, False


Any help would be great

 

[theDBguy]

When you view the message in your email client, is there a setting to view it in rich text?

 

[arnelgp]

acFormatRTF

how about if you use acFormatHTML

 

[isladogs]

You may find it worth reading this parallel thread at another forum https://www.utteraccess.com/topics/2061486

 

[atrium]

Thanks guys ,
I have tried acFormatRTF and acFormatHTML same result. The text comes out with all the html code

DoCmd.SendObject , , acFormatHTML, varName, varCC, , varSubject, varBody, False, False

DoCmd.SendObject , , acFormatRTF, varName, varCC, , varSubject, varBody, False, False

 

[arnelgp]

SendObject will not do it for you. Try Outlook automation.

For info, the TemplateFile argument only applies to Output format acFormatHtml and there is an object to send (report, table, query, etc).
Also the template will apply Not to the Body of the email, but to the Attachment (report, table, query, etc).

 

[theDBguy]

Thanks guys ,
I have tried acFormatRTF and acFormatHTML same result. The text comes out with all the html code

DoCmd.SendObject , , acFormatHTML, varName, varCC, , varSubject, varBody, False, False

DoCmd.SendObject , , acFormatRTF, varName, varCC, , varSubject, varBody, False, False

Hi. You didn't see my question. You can open an html file with a text editor and see all the tags. The only way to see it as a web page is to open it with a web browser or any application that can render html tags. It just so happens that Outlook can do both. That's why I asked if you can switch the view in your email client.