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

Take a look here for a CDO solution...

http://vbcity.com/forums/t/61790.aspx

I would suggest you embed GIF or PNG files instead of JPG, because JPG is not very text friendly: tends to make text a bit fuzzy.

Lambert 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Friday, March 30, 2012 2: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