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

I did this successfully in Excel. Had to work on a Blackberry. Font style
selection was important as was the "form factor" and pixel width of the
device.
Of course I had Outlook to work with.....so pasting in the HTML was no
problem.
I had to make a slight tweak to the HTML that Excel had generated....wow, it
was complex and voluminous....tons of CSS.

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:accessd-
> bounces at databaseadvisors.com] On Behalf Of Brad Marks
> Sent: Friday, March 30, 2012 5:29 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Embedding Multiple Access Reports in an E-mail
> Body (as HTML)
>
>
>
> -----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.
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com