[AccessD] Writing HTML to Outlook

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

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com