Created Formatted Reports in Access 2007 and emailing (not attachm

[PatK]

I was wondering if anyone has any idea of how I might send out nicely
formatted reports, where the report content is in the body of the email? I
have seen a number of threads posted about sending attachments, and that will
likely be my "fallback" approach.

Trying to avoid attachments, however, as this required folks, who are
already in email jail, to take an extra step, which results in them not
seeing the report (my reports are communicating significant issues in ongoing
projects, and important that they at least "See" the red flags in the report.

This leads me to the formatting issue...I would like the reports to look
similar to a report i might generate via a normal access report, but with the
ability to set background text on some words like "RED" to be red, etc (let's
folks scan the report quickly for line-items "at risk."

Has anyone see a nice set of code that lets you produce formatted reports
(maybe of HTML type format)?

Thanks!

PatK

(hope this posts...for whatever reason, my earlier posts don't seem to be
showing up).

 

[Stuart McCall]

I was wondering if anyone has any idea of how I might send out nicely
formatted reports, where the report content is in the body of the email?
I
have seen a number of threads posted about sending attachments, and that
will
likely be my "fallback" approach.

Trying to avoid attachments, however, as this required folks, who are
already in email jail, to take an extra step, which results in them not
seeing the report (my reports are communicating significant issues in
ongoing
projects, and important that they at least "See" the red flags in the
report.

This leads me to the formatting issue...I would like the reports to look
similar to a report i might generate via a normal access report, but with
the
ability to set background text on some words like "RED" to be red, etc
(let's
folks scan the report quickly for line-items "at risk."

Has anyone see a nice set of code that lets you produce formatted reports
(maybe of HTML type format)?

Thanks!

PatK

(hope this posts...for whatever reason, my earlier posts don't seem to be
showing up).

Try selecting the report in the database window and choosing File | Save As.
When the Save as dialog appears, change the type of file to HTML before
saving.

 

[PatK]

Well...I am trying to accomplish it in VBA code. Ultimately, this code will
loop through and send out over 100 reports, so need to find a way to do this
programatically. I Do appreciate the help and response!

Patk

 

[Stuart McCall]

Well...I am trying to accomplish it in VBA code. Ultimately, this code
will
loop through and send out over 100 reports, so need to find a way to do
this
programatically. I Do appreciate the help and response!

Patk

You need to use the OutputTo command, where you can specify the output
format:

DoCmd.OutputTo acOutputReport, "MyReport", acFormatHTML, "c:\temp\test.htm"

(this effectively does what I described, but in code instead of the UI)

 

[Mark Andrews]

My email module does this. It basically save the html file, reads it back
in to the email template so it appears in the body.

Note: This approach is limited by the power of Access and how well/badly it
exports reports to HTML.

You could look at my simple demo on my website.
http://www.rptsoftware.com

I have a better example of email templates in my latest donation management
software.
http://www.donationmanagementsoftware.com

The general email template approach would probably serve your needs better
(depending on how much tabular data is in the mix).

Send me an email with more details and I'll give you my best opinion on how
to approach. See website for details.

HTH,
Mark Andrews
RPT Software
http://www.rptsoftware.com