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
