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

Just curious - was there a specific business reason to switch to the new
approach?  Do they need to be able to access the data in the reports as if
it were text rather than an image?  The answers to these questions may
dictate the approach to use.  Does the email note contain other info than
the report content?


Sincerely yours,
 
Guss Ginsburg
Beechnut Consulting Services
5247 Beechnut Street
Houston, TX  77096
 
Ph: 713-667-8216
Cell: 713-553-6298
www.beechnutconsulting.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 1: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