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

Jim Lawrence accessd at shaw.ca
Sat Mar 31 10:25:32 CDT 2012


If you can find no obvious way to create the report to HTML you might have
to brute force it by building the code yourself. Either by doing the full
lay out, line by line or assembling groups of data within the program.

Had to do this, on a few of occasions, where report requirements were just
too complex for standard methods...like long reports and photo ID badges.
When you choice this method you can nudge photos exactly into position,
control data out put, line by line, create any size page and even pull
special fonts from the internet. It can takes some time to build such a
report but the results can be a thing of beauty.

You could use word documents translated to HTML, to start you off, but be
warned they are the most ugly convoluded pieces of code and to rebuild them,
through code can cause brain damage. A good 50 percent of the internal code
can be removed with impunity and with no degradation or change in the
output.

Jim

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

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



More information about the AccessD mailing list