You neet to output your html to a disk file first using
OUTPUT SomeFile.htm
-- then your Select Clause HTML
Output Screen
-- Then set a VarChar Variable to your DiskFile
Set var vMyHTML varchar = ['SomeFile.htm']
I don't use R:Mail, so I am uncertain at this point of the usability of the
varchar variable in the email, but the above will get you to the varchar OK.
----- Original Message -----
From: "James W. Kim" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Wednesday, December 30, 2009 9:47 PM
Subject: [RBASE-L] - Storing results of SELECT... HTML statement into
variable
I am currently transitioning from using R:Mail 2.6 to R:Mail 3.0 and have
run into a bit of a problem that needs to be resolved.
Under version 2.6, I output various components into a single text file
that is submitted to R:Mail 2.6. Among the items I add to the single text
file are some HTML fragments that are result of SELECT ... HTML
statements.
Under version 3.0, I need to use ADD_TO_MESSAGE_BODY followed by content
to be added. (e.g. PLUGIN RMail30_75.rbl 'v1|ADD_TO_MESSAGE_BODY
<div>Seasons Greetings from all of us at MyISP! </div>') One way I can do
this well is to have the content in a variable.
However, what I do not know how to do is to store the result of SELECT
...HTML into a variable (hopefully varchar).
Is there a way I could do this?
Thanks in advance,
James Kim
--
This message has been scanned for viruses and dangerous content by
MailScanner, and is believed to be clean.
