Outlook Message in HTML Format From Access, Report PDF

[Jason Brady]

Hello,

In an Access 2007 application I'm using the SendObject to e-mail a report as
a PDF attachment.

DoCmd.SendObject acSendReport, strReportName, acFormatPDF, _
strRecipient, strCC, , , , True

It works great, but when the e-mail message opens in Outlook it's in Plain
Text format, and my users want to default to HTML format. Is this possible?
If not, what alternatives are available to achieve the desired result?

I apologize if this has been addressed before; a pointer to other messages
is appreciated.

Thank you.

 

[Ken Slovak - [MVP - Outlook]]

DoCmd calls into Simple MAPI, not the Extended MAPI that Outlook normally
uses. In order to create the email as an HTML email you probably will end up
needing to code everything using the Outlook object model instead of using
DoCmd and Simple MAPI.

 

[Jason Brady]

Ken,

Okay, thanks for explaining that. Can you recommend an online resource where
I can learn more along with sample VBA code?

Jason

DoCmd calls into Simple MAPI, not the Extended MAPI that Outlook normally
uses. In order to create the email as an HTML email you probably will end up
needing to code everything using the Outlook object model instead of using
DoCmd and Simple MAPI.

<snip>

 

[Ken Slovak - [MVP - Outlook]]

Go to www.outlookcode.com. Lots of code samples for Outlook programming.

 

[Jason Brady]

Will do. Thanks again!

--
Jason Brady
Brady Systems Solutions, LLC
Lynnwood, WA USA