From: Tom van Stiphout on
On Thu, 12 Nov 2009 19:28:05 -0800 (PST), Dummy <cliff72(a)>

The simplest way to distribute a report is to use the built-in
features. Check out DoCmd.SendObject in the help file.

If you want to do this the hard but flexible way, there is Outlook
Automation. Would require expert coding skills.

Microsoft Access MVP

>I�m using access 2007. I would like to use one of my reports as the
>body of an outlook 2007 email message. I�m able to export the report
>as an HTML file but can�t figure out how to use either as body of the
>email message. Is this possible in VBA? Can anyone help with an
>example or sample code if possible?
>Thanks All