Using the HTA method, you can prepend or append the output as you desire using write statements. The reason the I use the <PRE></PRE> tags in the html is it forces fixed font so spacing is not a mess. Otherwise, in displays before the report output, you could use any html tags to create text formatted as you wish.
From: [email protected] [mailto:[email protected]] On Behalf Of Mike Byerley Sent: Wednesday, February 10, 2016 3:53 PM To: [email protected] Subject: [RBASE-L] - Re: Email dummy Try the following code. Put the contents in an RMD file and run it against the RRBYW17 Database. When the output window comes up, you can right click and “view source” so see what the HTML looks like. I use this for quick columular output reports just for viewing although when you save it as an *.HTA file, then ALL the things that are available in HTML Applications are available like Javascript and VBScript, if you want to get inventive. {begin Code} { To Be used with RRBYW17 Database 02102016 mbyerley } {The contents of the QuickHTML.HTA file can be used as the body of an email} OUTPUT quickhtml.hta SET WIDTH 200 SET HEADINGS OFF WRITE '<html><HEAD>' WRITE '<TITLE>My Custom Quickie HTA Report That Can Be Used In Email Body</TITLE>' WRITE ' <HTA:APPLICATION ID="oHTA"' WRITE ' APPLICATIONNAME=""' WRITE ' BORDER="thin"' WRITE ' BORDERSTYLE="normal"' WRITE ' CAPTION="yes"' WRITE ' ICON=""' WRITE ' MAXIMIZEBUTTON="yes"' WRITE ' MINIMIZEBUTTON="yes"' WRITE ' SHOWINTASKBAR="yes"' WRITE ' SINGLEINSTANCE="no"' WRITE ' SYSMENU="yes"' WRITE ' VERSION="1.0"' WRITE ' WINDOWSTATE="NORMAL"/>' WRITE '</HEAD><body width="200"><pre>' WRITE 'Trans Detail Model Units Price Discount Sale Extended' WRITE 'ID Number Price Price' WRITE '------------------------------------------------------------------------------' SELECT (CTXT(transid))=4,' '=4,(CTXT(detailnum))=3,' '=2,model=6,' '=2, + (RJS((CTXT(units)),3))=3,price=10,' '=1,discount=3,' '=1,saleprice=10, + extprice=14=S FROM invoicedetail WRITE '</pre></body></html>' OUTPUT SCREEN LAUNCH quickhtml.hta SET WIDTH 120 RETURN {end Code} From: [email protected] [mailto:[email protected]] On Behalf Of Karen Tellef Sent: Wednesday, February 10, 2016 11:20 AM To: [email protected] Subject: [RBASE-L] - Re: Email dummy I know back in 7.6 days that was not possible. I would sure love to hear that it's possible now! Same thing, they didn't want an attachment, but rather the report as the body. What they did to get by was for me to print the report as an RTF. They brought up the RTF in Word, did a "copy all" and pasted it into the outlook email. It actually worked really well! Karen -----Original Message----- From: Carpet Broker, Dick Fey <[email protected]> To: karentellef <[email protected]> Sent: Wed, Feb 10, 2016 10:11 am Subject: [RBASE-L] - Email dummy I have a report that I would like to email to customers. I would like the report to be the body of the email, not an attachment. Any wisdom out there? I know we get things from our vendors every day that are like that. Must be a way. -- Dick Fey Carpet Broker Inc P: 913-894-9211 F: 913-894-0138
