Yeah but the only way to get data from a table into an Rmail body is to output it to a text file (as far as I know)
So whether you do: output test.txtselect Col1, Col2, Col3... Col10 FROM tableoutput screen or output test.txtselect NoteColumn FROM tableoutput screen It's still gonna wrap that text file at the same place. Karen -----Original Message----- From: Buddy Walker <[email protected]> To: rbase-l <[email protected]> Sent: Mon, Dec 16, 2019 2:10 pm Subject: RE: [RBASE-L] - Long embedded files in RMail #yiv0344804022 -- filtered {panose-1:2 4 5 3 5 4 6 3 2 4;}#yiv0344804022 filtered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}#yiv0344804022 p.yiv0344804022MsoNormal, #yiv0344804022 li.yiv0344804022MsoNormal, #yiv0344804022 div.yiv0344804022MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:sans-serif;}#yiv0344804022 a:link, #yiv0344804022 span.yiv0344804022MsoHyperlink {color:blue;text-decoration:underline;}#yiv0344804022 a:visited, #yiv0344804022 span.yiv0344804022MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv0344804022 p.yiv0344804022msonormal0, #yiv0344804022 li.yiv0344804022msonormal0, #yiv0344804022 div.yiv0344804022msonormal0 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:sans-serif;}#yiv0344804022 p.yiv0344804022msonormal0, #yiv0344804022 li.yiv0344804022msonormal0, #yiv0344804022 div.yiv0344804022msonormal0 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:sans-serif;}#yiv0344804022 p.yiv0344804022msonormal, #yiv0344804022 li.yiv0344804022msonormal, #yiv0344804022 div.yiv0344804022msonormal {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:sans-serif;}#yiv0344804022 p.yiv0344804022msochpdefault, #yiv0344804022 li.yiv0344804022msochpdefault, #yiv0344804022 div.yiv0344804022msochpdefault {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:sans-serif;}#yiv0344804022 p.yiv0344804022msonormal1, #yiv0344804022 li.yiv0344804022msonormal1, #yiv0344804022 div.yiv0344804022msonormal1 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:sans-serif;}#yiv0344804022 p.yiv0344804022msonormal2, #yiv0344804022 li.yiv0344804022msonormal2, #yiv0344804022 div.yiv0344804022msonormal2 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:sans-serif;}#yiv0344804022 p.yiv0344804022msonormal01, #yiv0344804022 li.yiv0344804022msonormal01, #yiv0344804022 div.yiv0344804022msonormal01 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:sans-serif;}#yiv0344804022 p.yiv0344804022msonormal02, #yiv0344804022 li.yiv0344804022msonormal02, #yiv0344804022 div.yiv0344804022msonormal02 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:sans-serif;}#yiv0344804022 p.yiv0344804022msochpdefault1, #yiv0344804022 li.yiv0344804022msochpdefault1, #yiv0344804022 div.yiv0344804022msochpdefault1 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:sans-serif;}#yiv0344804022 span.yiv0344804022msohyperlink {}#yiv0344804022 span.yiv0344804022msohyperlinkfollowed {}#yiv0344804022 span.yiv0344804022msohyperlink1 {}#yiv0344804022 span.yiv0344804022msohyperlinkfollowed1 {}#yiv0344804022 span.yiv0344804022emailstyle191 {}#yiv0344804022 span.yiv0344804022emailstyle34 {}#yiv0344804022 p.yiv0344804022msonormal3, #yiv0344804022 li.yiv0344804022msonormal3, #yiv0344804022 div.yiv0344804022msonormal3 {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:sans-serif;}#yiv0344804022 p.yiv0344804022msonormal4, #yiv0344804022 li.yiv0344804022msonormal4, #yiv0344804022 div.yiv0344804022msonormal4 {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:sans-serif;}#yiv0344804022 span.yiv0344804022msohyperlink2 {color:blue;text-decoration:underline;}#yiv0344804022 span.yiv0344804022msohyperlinkfollowed2 {color:purple;text-decoration:underline;}#yiv0344804022 p.yiv0344804022msonormal03, #yiv0344804022 li.yiv0344804022msonormal03, #yiv0344804022 div.yiv0344804022msonormal03 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:sans-serif;}#yiv0344804022 p.yiv0344804022msonormal04, #yiv0344804022 li.yiv0344804022msonormal04, #yiv0344804022 div.yiv0344804022msonormal04 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:sans-serif;}#yiv0344804022 p.yiv0344804022msonormal5, #yiv0344804022 li.yiv0344804022msonormal5, #yiv0344804022 div.yiv0344804022msonormal5 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:sans-serif;}#yiv0344804022 p.yiv0344804022msochpdefault2, #yiv0344804022 li.yiv0344804022msochpdefault2, #yiv0344804022 div.yiv0344804022msochpdefault2 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:sans-serif;}#yiv0344804022 p.yiv0344804022msochpdefault3, #yiv0344804022 li.yiv0344804022msochpdefault3, #yiv0344804022 div.yiv0344804022msochpdefault3 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:sans-serif;}#yiv0344804022 p.yiv0344804022msonormal11, #yiv0344804022 li.yiv0344804022msonormal11, #yiv0344804022 div.yiv0344804022msonormal11 {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:sans-serif;}#yiv0344804022 p.yiv0344804022msonormal12, #yiv0344804022 li.yiv0344804022msonormal12, #yiv0344804022 div.yiv0344804022msonormal12 {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:sans-serif;}#yiv0344804022 p.yiv0344804022msonormal21, #yiv0344804022 li.yiv0344804022msonormal21, #yiv0344804022 div.yiv0344804022msonormal21 {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:sans-serif;}#yiv0344804022 p.yiv0344804022msonormal22, #yiv0344804022 li.yiv0344804022msonormal22, #yiv0344804022 div.yiv0344804022msonormal22 {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:sans-serif;}#yiv0344804022 span.yiv0344804022msohyperlink11 {color:blue;text-decoration:underline;}#yiv0344804022 span.yiv0344804022msohyperlinkfollowed11 {color:purple;text-decoration:underline;}#yiv0344804022 p.yiv0344804022msonormal011, #yiv0344804022 li.yiv0344804022msonormal011, #yiv0344804022 div.yiv0344804022msonormal011 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:sans-serif;}#yiv0344804022 p.yiv0344804022msonormal012, #yiv0344804022 li.yiv0344804022msonormal012, #yiv0344804022 div.yiv0344804022msonormal012 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:sans-serif;}#yiv0344804022 p.yiv0344804022msonormal021, #yiv0344804022 li.yiv0344804022msonormal021, #yiv0344804022 div.yiv0344804022msonormal021 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:sans-serif;}#yiv0344804022 p.yiv0344804022msonormal022, #yiv0344804022 li.yiv0344804022msonormal022, #yiv0344804022 div.yiv0344804022msonormal022 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:sans-serif;}#yiv0344804022 span.yiv0344804022emailstyle1911 {font-family:sans-serif;color:windowtext;}#yiv0344804022 p.yiv0344804022msochpdefault11, #yiv0344804022 li.yiv0344804022msochpdefault11, #yiv0344804022 div.yiv0344804022msochpdefault11 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:sans-serif;}#yiv0344804022 p.yiv0344804022msochpdefault12, #yiv0344804022 li.yiv0344804022msochpdefault12, #yiv0344804022 div.yiv0344804022msochpdefault12 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:sans-serif;}#yiv0344804022 span.yiv0344804022emailstyle341 {font-family:sans-serif;color:windowtext;}#yiv0344804022 span.yiv0344804022EmailStyle57 {font-family:sans-serif;color:windowtext;}#yiv0344804022 p.yiv0344804022pnormal, #yiv0344804022 li.yiv0344804022pnormal, #yiv0344804022 div.yiv0344804022pnormal {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:sans-serif;}#yiv0344804022 .yiv0344804022MsoChpDefault {font-family:sans-serif;}#yiv0344804022 filtered {margin:1.0in 1.0in 1.0in 1.0in;}#yiv0344804022 div.yiv0344804022WordSection1 {}#yiv0344804022 Ok, assuming you have 10 columns and each row (100) is a different body. So you would be sending out 100 with 10 columns in each email. I would still create a temporary table with an IdColumn and NoteColumn INSERT INTO TemporaryTable (IdColumn,NoteColumn) + SELECT IdColumn, (Col1 & Col2 & Col3 & Col4….) + FROM someTable WHERE ……. Then doing your RMail code select information from TemporaryTable. Buddy From: 'Karen Tellef' via RBASE-L <[email protected]> Sent: Monday, December 16, 2019 2:55 PM To: [email protected] Subject: Re: [RBASE-L] - Long embedded files in RMail Sorry just not understanding. I'm doing a select of 10 columns from a table, could have 100 rows. A select of 10 columns exceeds the 79 characters or so that's getting written to one line I'm doing this: SELECT col1, col2, col3,....col10 FROM table WHERE..... Karen -----Original Message----- From: Buddy Walker <[email protected]> To: rbase-l <[email protected]> Sent: Mon, Dec 16, 2019 1:44 pm Subject: RE: [RBASE-L] - Long embedded files in RMail You select the information into a variable then build your body as such So if you have three selects for your body I would do this SET VAR vBody = (.vSelect1 + (CHAR(013)) + .vSelect2 + (CHAR(013)) + .vSelect3) Then just use the variable vBody for your body. Buddy From: 'Karen Tellef' via RBASE-L <[email protected]> Sent: Monday, December 16, 2019 2:23 PM To: [email protected] Subject: Re: [RBASE-L] - Long embedded files in RMail 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 RMailKaren 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.-- 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/003401d5b449%2439f09ca0%24add1d5e0%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/501490761.9383680.1576526107722%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/003d01d5b44c%24c99c3730%245cd4a590%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/2122187295.9378978.1576532620477%40mail.yahoo.com.
