[AccessD] Writing HTML to Outlook

Arthur Fuller artful at rogers.com
Sat Feb 26 10:39:50 CST 2005


The problem with that is that all the fancy graphics are lost. That was 
my first try. Maybe it's improved in A2003.

Arthur

Dan Waters wrote:

>Arthur,
>
>Would something like this work out?
>
>DoCmd.SendObject acSendReport, "rptMyReport", acFormatHTML, _
>    "name1 at ISP.com; name2 at ISP.com", , , _
>    "Report Name", , False
>
>This is modified from Access VBA Help.
>
>Dan Waters
>ProMation Systems
>
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
>Sent: Saturday, February 26, 2005 9:13 AM
>To: Access Developers discussion and problem solving
>Subject: [AccessD] Writing HTML to Outlook
>
>Does anyone know how to convert an Access report to HTML and then embed 
>it in an Outlook message? Actually there are two problems.
>
>1. When I save a report to HTML, I lose all its graphics.
>2. I don't know how to embed the result in an Outlook message.
>
>Currently my user is saving to a PDF, then loading Adobe and opening the 
>PDF, then saving it as HTML, then copying and pasting the result into an 
>Outlook message. It works, but it's tedious, espcially given that when 
>he needs to do it, he does it several hundred times in succession.
>
>TIA,
>Arthur
>
>  
>



More information about the AccessD mailing list