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

It would be best to develop a template in HTML/CSS.
Then just do a Replace to insert the real data.
If you know CSS well, you could do this much easier than having to work with
HTML tables.


> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:accessd-
> bounces at databaseadvisors.com] On Behalf Of Brad Marks
> Sent: Saturday, March 31, 2012 12:16 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Embedding Multiple Access Reports in an E-mail
> Body(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.
>