Get SendObject into e-mail body

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

Guest

Is there a way (within Access) to get a report to show up in the e-mail body
instead of as an HTML attachment?

Here is my SendObject statement:

DoCmd.SendObject acSendReport, "ReportName", acFormatHTML, "(e-mail address removed)", ,
, "Subject", "Body", False, False
 
Thanks, Alex.

This works well for getting the text in there, but I am really after a way
to get the actual HTML into the body of the message because it involves some
different fonts, alignment of report & subreport elements is critical, and,
and there and some important separator lines.

I guess what I would really like is a way to output this to an HTML file,
then copy the contents of the HTML file into the body of the e-mail. I can
come close: I can create the HTML file, then read through it line-by-line to
build the body of the e-mail, but the HTML comes through as this:

<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html;charset=windows-1252">
<TITLE>Statement</TITLE>
</HEAD>
<BODY>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 >

etc.

instead of displaying the correct format in the body of the e-mail.
Do you think it is possible to get the actual HTML into the body of the
e-mail from within Access. Or am I dreaming of something impractical?
 
Back
Top