sendobject attachment on mail body instead

[andox]

My ultimate goal is to send reports via e-mail, via access. This I already understand how to do. My question is, is it possible to send the report embedded in the body of the e-mail itself instead of an attachment?

I understand that this would be easier done if the database were online and I had a website for it, but I do not want to ever have the database accessible over the internet.

 

[sunilvedula]

we can do that but the problem would be that you can get in text format and it would never contain rows and coloums. If that is ok let me know will paste the code. Here is the explanation. in the body of the email mention all the fields of the query you want to run with spaces in between. it will show then.