On Thu, May 12, 2011 at 7:21 PM, Dan Goldberg <[email protected]> wrote:
> I have a report which I email as a pdf. > > Based on the example below I want to have a multi-line body in the email > > Sample Body: > > Part: EP200 > Description: Plug > Cause: out > > Sample report to pdf/email: > > PRINT Invoice WHERE TransID = 1031 + > OPTION PDF|FILENAME Invoice_1031.PDF + > |EMAIL ON + > |EMAIL_TO_LIST [email protected], [email protected] + > |EMAIL_FROM_NAME John D. Johnson + > |EMAIL_FROM_ADDRESS [email protected] + > |EMAIL_SUBJECT Imagine The Possibilities! + > |EMAIL_BODY &vbody + > |EMAIL_DELETE_AFTER_SEND ON + > |EMAIL_SHOW_DIALOG OFF > > If I use a variable with the (CHAR(013)) as carriage returns it still shows > up on one line. > > set var vreturn = (CHAR(013)) > set var vbody = (.vbody1 & .vreturn + vbody2 + .vreturn + .vbody3) > > Has anyone been able to put multiple lines in the body? Dan, What is the data type of vBody variable? You may try the following examples and see what you get: -- Example 01 (Using Data Type as NOTE) SET VAR vBody1 TEXT = NULL SET VAR vBody2 TEXT = NULL SET VAR vBody3 TEXT = NULL SET VAR vBody NOTE = NULL SET VAR vBody1 = 'Part: EP200' SET VAR vBody2 = 'Description: Plug' SET VAR vBody3 = 'Cause: Out' SET VAR vBody = (.vBody1+(CHAR(013))+.vBody2+(CHAR(013))+.vBody3+(CHAR(013))) CLEAR VARIABLES vBody? -- Example 02 (Using Data Type as VARCHAR) SET VAR vBody1 TEXT = NULL SET VAR vBody2 TEXT = NULL SET VAR vBody3 TEXT = NULL SET VAR vBody VARCHAR = NULL SET VAR vBody1 = 'Part: EP200' SET VAR vBody2 = 'Description: Plug' SET VAR vBody3 = 'Cause: Out' SET VAR vBody = (.vBody1+(CHAR(013))+.vBody2+(CHAR(013))+.vBody3+(CHAR(013))) CLEAR VARIABLES vBody? Very Best R:egards, Razzak.
