dumping report into e-mail body

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to have a report submitted into an e-mail body, either by
using a macro or using VBA? My recipient of the report want to see the
report in the body of the e-mail and not have to open the attachment.
Yea...I know...lazy!

Thanks in advance,
 
I don't know if there is a way to do this through Access,
but you may want to think about linking to your Access db
via php or perl then usng the mailto: functions of either
language.

Or find more self-supporting clients...

Rick
 
-----Original Message-----
FMS may have a solution. You could print the report to a text file (loosing
all formatting) using the generic text printer, then open that file in code
and insert it into the body of the email.
They would have to make sure the email was wide enough to view the report
properly and I've seen a few times when the wrong margins gave the wrong
information in a column but it looked like it belonged.

If they want color etc, then you would have to edit the text file and add
HTML to it.

I'd tell them that I'd love to do it, it will only cost an additional $50.00
per email or I could give him a free PDF reader...
 
thanks to all. The pdf option was explored. The user want to open the e-mail
and see the report without any additonal effort. I appreciate your
responses. Thank you.
 
Back
Top