I found my mistake,
I was cutting and pasting code from examples and
SET VAR vquote TEXT = null was after
SET VAR vquote TEXT = (CVAL('QUOTES'))
Of course silly mistake on me but hard to see.
Thanks
Marc
----- Original Message -----
From: "Marc" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Thursday, August 14, 2008 8:14 AM
Subject: [RBASE-L] - Re: Email boddy
HI
If I run Dawn's code it works fine, so I have tried cutting and pasting
parts
of her code into mine but mine still would not work. I am using a While
loop so I pasted her code inside mine to test.
The first pass the body of my email does not have the line feeds but hers
does. Then on the second pass mine stays formatted. So it seems there
is something in Dawn's code that forces mine to format on the second pass
through the loop but I have not spotted yet.
WHILE SQLCODE <> 100 THEN
-- my code does not format the body the first pass but second pass works
-- I guess my code is teachable and learns from the master!!!
SET VAR vbody TEXT = +
(.vfname & .vlname +.vreturn + +
'Your estimate balance is..'& (CTXT(.vtotpt)) +.vreturn + .vreturn+ +
'Your last visit was on ...'& (CTXT(.vdatelch)) + .vreturn + .vreturn + +
'Last personal payment on ...'& (CTXT(.vdatelpay)) + .vreturn + +
'Amount of payment ....'& (CTXT(.vamtperpd)) +(CHAR(013)) )
SET VAR vbody = ('Body:' + .vbody)
SET VAR vparameters = +
(.vquote+'vResult' +.vpipe + 'To: '+.vpatemail + .vpipe + +
'Subject: '+.vsubject + .vpipe + +
'Body: '+.vbody + .vquote)
PLUGINS mapimail2.rbl &vparameters
-- Dawns code.... of course works each time Notice vbody2 and vparameters2
on Dawn's code
-- I am going to keep changing Dawn's code one var at a time to see which
one makes the
-- difference
SET VAR vresult TEXT
SET VAR vreturn TEXT = ((CHAR(13))+(CHAR(10)))
SET VAR vemailaddress = '"Dawn Hast" <[EMAIL PROTECTED]>'
SET VAR vquote TEXT = (CVAL('QUOTES'))
SET VAR vpipe TEXT = '|'
SET VAR vto TEXT = ('To:'+.vemailaddress)
SET VAR vsubject = 'Subject: Test'
SET VAR vfname = 'Dawn'
SET VAR vlname = 'Hast'
SET VAR vtotpt = '$100.00'
SET VAR vdatelch DATE = 08/12/08
SET VAR vdatelpay DATE = 08/11/08
SET VAR vamtperpd = '$20.00'
SET VAR vbody2 TEXT = +
(.vfname & .vlname +.vreturn + +
'Your estimate balance is..'& (CTXT(.vtotpt)) +.vreturn + .vreturn+ +
'Your last visit was on ...'& (CTXT(.vdatelch)) + .vreturn + .vreturn + +
'Last personal payment on ...'& (CTXT(.vdatelpay)) + .vreturn + +
'Amount of payment ....'& (CTXT(.vamtperpd)) +(CHAR(013)) )
SET VAR vbody2 = ('Body:' + .vbody2)
SET VAR vparameters2 TEXT = (.vquote+'vResult' + .vpipe + .vto + .vpipe +
+
.vsubject + .vpipe + .vbody2 + .vquote)
PLUGINS mapimail2.rbl &vparameters2
FETCH c2 +
----- Original Message -----
From: "Stephen Markson" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Wednesday, August 13, 2008 6:27 PM
Subject: [RBASE-L] - Re: Email boddy
Have you tried using CHAR(10) + CHAR(13) or just CHAR(10) by itself?
I believe only MAC OS uses CHAR(13) alone as the newline character.
Regards,
Stephen Markson
ForenSys The Forensic Systems Group
www.ForenSys.ca
416 512 6950
-----Original Message-----
From: "Marc" < [EMAIL PROTECTED]>
To: [email protected] (RBASE-L Mailing List)
Date: Tue, 12 Aug 2008 11:32:00 -0500
Subject: [RBASE-L] - Email boddy
Hi
I am having problems getting the body of the email to format
the way I want.
This is my last try
SET VAR vReturn TEXT = ((CHAR(13))+(CHAR(10)))
SET VAR vbody TEXT = +
(.vfname & .vlname +(CHAR(013))+ +
'Your estimate balance is..'& (CTXT(.vtotpt)) +.vReturn + .vReturn+ +
'Your last visit was on ...'& (CTXT(.vdatelch)) + .vReturn + .vReturn + +
'Last personal payment on ...'& (CTXT(.vdatelpay)) + .vReturn + +
'Amount of payment ....'& (CTXT(.vamtperpd)) +(CHAR(013)) )
I want to have 5 lines
Name ...
Your estimate balance is ...
and so on.
What am I missing?
Thanks
Marc
