HomeTechnical Support » E-mailing

E-mailing

PB# Assign EmailBody query Messages in this topic - RSS

Eva
Posts: 6


3/25/2011
Eva
Posts: 6
Hi,
I am trying to get PB# Assign EmailBody to work. If I put the formula into Crystal which is simply one long sentence, then it works however I need that formula to be a conditional one as per the one following and all it does is print the first line. Is there any way to have a formatted body that relies on information from the data files?

This is a portion of the formula

PB# Assign EmailBody,"+
(if {ARCUS.CODETERR} = "ENG"
then ( "Dear Customer,"+ chr(13) +
" "+ chr(13) +
"Please find attached your invoice for sales in February 2011."+ chr(13) +
" "+ chr(13) +
"Should you have any queries please do not hesitate to contact us. "+ chr(13) +
" "+ chr(13) +
"Barbara C ")
else
if {ARCUS.PRICLIST} = "NOKTAG"
then " Kjaere XYZ,"+ chr(13) +
" "+ chr(13) +
"Vedlagt finner du fakturaen ."+ chr(13) +
" "+ chr(13) +
"Takk,"+ chr(13) +
" "+ chr(13) +
"Med vennlig hilsen,"+ chr(13) +
" "+ chr(13) +
" "+ chr(13) +
"AS"
Else
if {ARCUS.PRICLIST} = "EURTAG" and {ARCUS.CODETERR} = "ITA"
then " Vi ringraziamo per appoggiare il nostro Servizio

and so on and it continues for about 20 different options.


Any assistance would be very much appreciated.
Regards
Eva
0 link






Powered by Jitbit Forum 8.3.8.0 © 2006-2013 Jitbit Software