Brad Marks
BradM at blackforestltd.com
Sat Mar 31 11:16:26 CDT 2012
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.