E-mailing
PB# Assign EmailBody query
Eva Posts: 6
3/25/2011
|
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
|