Brad Marks
BradM at blackforestltd.com
Fri Mar 30 16:28:31 CDT 2012
-----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Guss Ginsburg Sent: Friday, March 30, 2012 4:04 PM To: 'Access Developers discussion and problem solving' Subject: Re: [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? To make it easier to view the reports on various types of cell phones (without the need to open up attachments) ~~~~~~~~~~~~~~~~ Do they need to be able to access the data in the reports as if it were text rather than an image? I think an image would be fine. I have not found a way to export an Access report as an image, however. ~~~~~~~~~~~~~~~~~ The answers to these questions may dictate the approach to use. Does the email note contain other info than the report content? Yes, there will be other text in the e-mail body besides the Access reports. ~~~~~~~~~~~~~~~ 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 -- 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.