Emmanuel Katto : How to Set Outlook to Open in HTML Format from Access Email

[emmanuelkatto23]

Hi all,
I’m Emmanuel Katto, working on a small database for a non-profit that tracks donors and their donations. I’ve set up an Access form that, using the DoCmd.SendObject command, opens Outlook with a filled-out email, including an attached tax receipt. However, the problem is that Outlook opens in Plain Text mode, not HTML, even though my Outlook settings are configured to use HTML for composing emails.

I’m wondering if there’s a simple way to modify the Access VBA code to force Outlook to open in HTML format when using the DoCmd.SendObject command? I don’t want to rewrite the whole VBA code to send the email manually, just need a quick solution. Any ideas?

Regards
Emmanuel Katto

 

[Minty]

Nope.
DoCmd.SendObject has no idea what email client you are using - it just uses the local machines default client.

If I get any response from the OP for this reply I would like a chocolate biscuit.

 

[Trevor G]

As Minty has stated the Docmd will only look at the default email client you have and as far as I'm aware it will only be Plain Text you'll need full VBA code especially for HTML and anything you are looking to format. As an extra point I doubt you'll know what formatting the recipient has theirs set to. If they have it only as Plain Text pretty much that's all they'll see regardless of what your using.