Embed report inside email and keep formating

[megatronixs]

Hi all,

I'm trying to get a report embedded inside an email. I have current a report build with excel that I can copy paste inside the email or even automate it to create email and have the selection inside the email of the report.
I created now a report based on the current excel file using some queries to feed the fields inside the report.

Could you please let me know how this could be done?
code to create emails and some formatting I have, but no way to figure out how to embed the report in the email.

Greetings.

 

[Ranman256]

You can attach an excel sheet with a single line of code :

Docmd.sendObject (Use query param and Excel format)

 

[megatronixs]

Hi Ranman256,
I actually meen the access report. I'm rebuilding the excel report in Access as a report.

I will prepare a small test version and post it.

Greetings.

 

[pbaldy]

I've never needed it, but I've heard of people exporting the report to html, grabbing the resulting text and incorporating it into the body of an email (in html format of course).

 

[megatronixs]

Attached the test database.

Greetings.