Jim Lawrence
accessd at shaw.ca
Sat Mar 31 13:13:45 CDT 2012
CSS is just style sheets and they have to have a HTML structure to work. You don't have to be a master web designers as there are thousands of examples on the web for any possibility and requirement. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Simms Sent: Saturday, March 31, 2012 10:46 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Embedding Multiple Access Reports in anE-mail Body(asHTML) It would be best to develop a template in HTML/CSS. Then just do a Replace to insert the real data. If you know CSS well, you could do this much easier than having to work with HTML tables. > -----Original Message----- > From: accessd-bounces at databaseadvisors.com [mailto:accessd- > bounces at databaseadvisors.com] On Behalf Of Brad Marks > Sent: Saturday, March 31, 2012 12:16 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Embedding Multiple Access Reports in an E-mail > Body(asHTML) > > Jim, > > Thanks for the advice/insights. > > I have experimented with building some simple HTML with VBA. > > I have not yet experimented with building HTML with VBA using the data > from a more complex report that has headers, footers, sub-totals, final > totals, etc. I am not sure how I can "grab" these fields when Access > is generating such a report. > > Brad > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com on behalf of Jim Lawrence > Sent: Sat 3/31/2012 10:25 AM > To: 'Access Developers discussion and problem solving' > Subject: Re: [AccessD] Embedding Multiple Access Reports in an E-mail > Body(asHTML) > > If you can find no obvious way to create the report to HTML you might > have to brute force it by building the code yourself. Either by doing > the full lay out, line by line or assembling groups of data within the > program. > > Had to do this, on a few of occasions, where report requirements were > just too complex for standard methods...like long reports and photo ID > badges. > When you choice this method you can nudge photos exactly into position, > control data out put, line by line, create any size page and even pull > special fonts from the internet. It can takes some time to build such a > report but the results can be a thing of beauty. > > You could use word documents translated to HTML, to start you off, but > be warned they are the most ugly convoluded pieces of code and to > rebuild them, through code can cause brain damage. A good 50 percent of > the internal code can be removed with impunity and with no degradation > or change in the output. > > Jim > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks > Sent: Friday, March 30, 2012 11:37 AM > To: Access Developers discussion and problem solving > Subject: [AccessD] Embedding Multiple Access Reports in an E-mail Body > (asHTML) > > 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