The problem is that this is a 'select' of multiple columns of a table so each line really cannot wrap at all. So if I stick my select result into a NoteColumn and it wraps again in the email at 79 characters, it's going to wrap in the middle of my select statement.
And if the data is in a temp table, the only way to get it into an email (as far as I know) is to write the data to a text file, which is basically what I'm doing now. Or is there another way to get a "select" statement as the body of an email? Karen -----Original Message----- From: Buddy Walker <[email protected]> To: rbase-l <[email protected]> Sent: Mon, Dec 16, 2019 1:07 pm Subject: RE: [RBASE-L] - Long embedded files in RMail #yiv6156018379 #yiv6156018379 -- _filtered #yiv6156018379 {panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv6156018379 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} #yiv6156018379 #yiv6156018379 p.yiv6156018379MsoNormal, #yiv6156018379 li.yiv6156018379MsoNormal, #yiv6156018379 div.yiv6156018379MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:sans-serif;} #yiv6156018379 a:link, #yiv6156018379 span.yiv6156018379MsoHyperlink {color:blue;text-decoration:underline;} #yiv6156018379 a:visited, #yiv6156018379 span.yiv6156018379MsoHyperlinkFollowed {color:purple;text-decoration:underline;} #yiv6156018379 p.yiv6156018379msonormal0, #yiv6156018379 li.yiv6156018379msonormal0, #yiv6156018379 div.yiv6156018379msonormal0 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:sans-serif;} #yiv6156018379 span.yiv6156018379EmailStyle19 {font-family:sans-serif;color:windowtext;} #yiv6156018379 .yiv6156018379MsoChpDefault {font-family:sans-serif;} _filtered #yiv6156018379 {margin:1.0in 1.0in 1.0in 1.0in;} #yiv6156018379 div.yiv6156018379WordSection1 {} #yiv6156018379 Karen Instead of creating text files I would create a Temporary Table IDcolumn and either NoteColumn or VarCharColumn. Depending on size of body data. Insert info into Temp table Then when you select the body for your email you will select NoteColumn/VarCharColumn as your body base on a where clause if necessary. This way you shouldn’t have to change the length and when inserted into email it should wrap naturally. It has been a while since I did this so make sure to test. Buddy From: 'Karen Tellef' via RBASE-L <[email protected]> Sent: Monday, December 16, 2019 12:28 PM To: [email protected] Subject: [RBASE-L] - Long embedded files in RMail We create text files with select statements in them which will be used as the bodyof an RMail email. Before doing the select we set the width to 200 and the resultingtext file looks perfect. However, when embedding it as the body (see command below)it wraps at 79 characters. I added a "set width 200" command right before all thermail code but that doesn't make a difference. V1|LOAD_MESSAGE_BODY_FROM_FILE DashBoardRefresh.txt Is there a way I can do this? Thanks! Karen -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1793718183.9281758.1576517295143%40mail.yahoo.com.-- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/002b01d5b444%241ebdf900%245c39eb00%24%40comcast.net. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/2055323552.9393587.1576524160959%40mail.yahoo.com.
