Steve Capistrant
scapistrant at symphonyinfo.com
Tue Aug 19 17:59:06 CDT 2003
Ooooohh, I love touring these dark labyrinths. Thanks for enlightening us; I will promptly save these secrets. :) But it does pretty much shut the door on this being used for (e)mail merging. Steve Capistrant Symphony Information Services scapistrant at symphonyinfo.com Phone: 612-333-1311 www.symphonyinfo.com 212 3rd Ave N, Ste 404 Minneapolis, MN 55401 -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Stuart McLachlan Sent: Tuesday, August 19, 2003 5:38 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] HTML Email from Access - Progress On 19 Aug 2003 at 9:37, Steve Capistrant wrote: > MessageAs long as the SendObject topic is open: does anybody really know > how to use the TemplateFile parameter? This would seem to be the perfect > mail merge tool, but I can't find documentation anywhere, and my attempts > silently fail (a plain vanilla email is produced, and that's all). > Buried many layers deep in the A2K Help files is a secret location, know only to a select few. Lock the doors, close the curtains and I will let you in on the secret :-) (Hint: OutputTo Action - Remarks - Export a Report to Static HTML format) "About HTML template files You can use one or more HTML template files to enhance the appearance, consistency, and navigation of your static HTML and server-generated HTML files. For example, you might want to include a company logo in the header section, a company-approved background image in the body section, and your own navigation buttons in the footer section of a static HTML report. An HTML template is a text file that includes HTML tags and tokens that are unique to Microsoft Access. These tokens indicate where to insert output and other information in the static HTML or server- generated HTML files. See an example of an HTML template file. When you output a table, query, form, or report, and you specify an HTML template file in the associated Output Options dialog box, Microsoft Access merges the HTML template file with the .html, .asp, and .htx output files by replacing the tokens with the following. HTML template token Replacement <!--AccessTemplate_Title--> The name of the table, query, form, or report placed in the title bar of the Web browser <!--AcessTemplate_Body--> The output of the table, query, form, or report <!--AccessTemplate_FirstPage--> An HTML anchor tag that links to the first page of a report <!--AccessTemplate_PreviousPage--> An HTML anchor tag that links to the page previous to the current report page <!--AccessTemplate_NextPage--> An HTML anchor tag that links to the next page after the current report page <!--AccessTemplate_LastPage--> An HTML anchor tag that links to the last page of a report <!--AccessTemplate_PageNumber--> The current page number " The "see an example" in the above text jumps to a second page containing this: "HTML template file example <HTML> <!--The following token places the object name in the title bar of the Web browser.--> <TITLE><!--AccessTemplate_Title--></TITLE> <!--The following HTML tag creates a different background color than the Web browser default.--> <BODY BACKGROUND = "gray.jpg"> <!--The following token places all object output inside the <BODY> tag.--> <!--AccessTemplate_Body--> </BODY> <BR><BR> <!--The following four tokens create four navigation text buttons that jump to the first, previous, next, and last pages of a report.-- > <A HREF = "<!--AccessTemplate_FirstPage-->">First</A> <A HREF = "<!--AccessTemplate_PreviousPage-->">Previous</A> <A HREF = "<!--AccessTemplate_NextPage-->">Next</A> <A HREF = "<!--AccessTemplate_LastPage-->">Last</A> <!--The following token inserts the text "Page n" , where n is the current report page number.--> <P ALIGN = CENTER>Page <!--AccessTemplate_PageNumber-->.</P> <!--The following HTML tag adds a company logo to the bottom of the Web page.--> <IMG SRC = "company_logo.jpg"> -- Lexacorp Ltd http://www.lexacorp.com.pg Information Technology Consultancy, Software Development,System Support. _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com