Outlook Message in HTML Format From Access, Report PDF


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.
 
Ad

Advertisements

K

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.
 
J

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


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.
<snip>
 
Ad

Advertisements

J

Jason Brady

Will do. Thanks again!

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top