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