Outlook Message in HTML Format From Access, Report PDF

  • Thread starter Thread starter Jason Brady
  • Start date Start date
J

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.
 
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.
 
Ken,

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

Jason


Ken Slovak - said:
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.
Click to expand...
<snip>
 
Will do. Thanks again!

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