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

True enough. However, the parent document is Word that acts as the email
template.
The image is a full page watermark once embedded in an email.

Michael R Mattys
Mattys Consulting, LLC
www.mattysconsulting.com


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Friday, March 30, 2012 9:29 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Embedding Multiple Access Reports in an E-mail Body
(as HTML)

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
>
>
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com