Charlotte Foust
charlotte.foust at gmail.com
Fri Mar 30 20:28:39 CDT 2012
I definitely don't recommend using an RTF format for the report output. It loses any graphics elements like lines and is not terribly reliable. You can export it directy to HTML in the latest versions of Access, but the size of the report might make that impractical. PDF is by far the most portable format and most smartphones can handle it with an applet. Charlotte Foust On Fri, Mar 30, 2012 at 11:36 AM, Brad Marks <BradM at blackforestltd.com>wrote: > 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 > > >