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).

"PatK" <(E-Mail Removed)> wrote in message
news:2CE7212D-4515-4E48-8539-(E-Mail Removed)...
>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.

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" wrote:

> "PatK" <(E-Mail Removed)> wrote in message
> news:2CE7212D-4515-4E48-8539-(E-Mail Removed)...
> >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" <(E-Mail Removed)> wrote in message
news:EF755638-CE43-45B0-95A6-(E-Mail Removed)...
> 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" wrote:
>
>> "PatK" <(E-Mail Removed)> wrote in message
>> news:2CE7212D-4515-4E48-8539-(E-Mail Removed)...
>> >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.

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)

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


"PatK" <(E-Mail Removed)> wrote in message
news:2CE7212D-4515-4E48-8539-(E-Mail Removed)...
> 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).