Report to Export via outlook

[syedadnan]

Regards,

I am looking to sent report from access 2007 to few recipients and i want the report to be inserted with same formating as actual in the text body of outlook 2007 and not as attachment, after this it should ask for TO, CC and BCC any idea please

 

[vbaInet]

I've not tried it but I feel it should work, how about saving the report as acFormatHTML and then copy and paste the html from the file to the HTML body like you're doing with the RTF format.

You'll probably need a different approach of reading the html file into a variable.