[AccessD] Embedding Multiple Access Reports in an E-mail Body (as HTML)

We have several different templates whose bookmarks get filled by data.
One of them incorporates rtf output.
It has been years since I've set them up, but this link may help:
http://office.microsoft.com/en-us/outlook-help/create-an-e-mail-template-HA0
01086500.aspx

Michael R Mattys
Mattys Consulting, LLC
www.mattysconsulting.com


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Friday, March 30, 2012 2:37 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Embedding Multiple Access Reports in an E-mail Body (as
HTML)

All,

I have an automated Access report job that runs at a specific time every
night and automatically e-mails multiple Access reports in PDF format as
e-mail attachments.  This has worked nicely for a long time. 

Now there is a need to "embed" the reports in the body of the e-mail rather
than send them as attachments.

I know that I can export the multiple reports from Access into HTML files.
This would probably work Okay if there was only one report.

I have experimented with building the HTML "by hand" via VBA code.  This may
work, but it takes some time to do the VBA coding and I am not 100% sure
that I can write the code to generate the HTML for summary reports that have
a lot of sub-totals, etc.

It would be nice if a person could export an Access report to a jpg file.
Multiple jpg files could then be embedded in the HTML file that is embedded
in the e-mail body.

Anyway, I am curious if anyone else has ever run into this type of
situation.

Thanks,
Brad

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com