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

Jim Lawrence accessd at shaw.ca
Sat Mar 31 11:38:20 CDT 2012


Hi Brad:

At times I have even dumped all the data to text files and then pulled the
results back in and reprocessed it, only to then dumped the results back out
to an HTML file for sending. Command line batch/text files can be your
friend. 

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Saturday, March 31, 2012 9:16 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Embedding Multiple Access Reports in an
E-mailBody(asHTML)

Jim,

Thanks for the advice/insights.

I have experimented with building some simple HTML with VBA.

I have not yet experimented with building HTML with VBA using the data from
a more complex report that has headers, footers, sub-totals, final totals,
etc.  I am not sure how I can "grab" these fields when Access is generating
such a report.

Brad


-----Original Message-----
From: accessd-bounces at databaseadvisors.com on behalf of Jim Lawrence
Sent: Sat 3/31/2012 10:25 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Embedding Multiple Access Reports in an E-mail
Body(asHTML)
 
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

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

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.





More information about the AccessD mailing list