sending a report to the body of an e-mail

[Kirk Ricks]

I need to know if anyone has been succesful in doing this.

I have a report that gets emailed using SendObject however it sends the txt
file as an attachment. Does anyone know of a way to have a report sent to
the body of the e-mail.

I am using Access 97 & Outlook Express

 

[Emilia Maxim]

I need to know if anyone has been succesful in doing this.

I have a report that gets emailed using SendObject however it sends the txt
file as an attachment. Does anyone know of a way to have a report sent to
the body of the e-mail.

I am using Access 97 & Outlook Express

Kirk,

this would be much more complicated. You would need to export the
report in a TXT format file, then open the TXT file in code, read it's
content and pass it to SendObject as the mail text.

However, IMHO it would be better to leave it as an attachment, maybe
in RTF format. At least some of the formattings would survive, whereas
in a TXT resp. mail the only remaining formatting are the lines.

Best regards
Emilia

Emilia Maxim
PC-SoftwareService, Stuttgart
http://www.maxim-software-service.de