Karen I did find that sometimes the Email client did restrict the size of the body. When that happened I just created a report and saved it as PDF and sent that.
Buddy From: 'Karen Tellef' via RBASE-L <rbase-l@googlegroups.com> Sent: Tuesday, December 17, 2019 9:25 AM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Long embedded files in RMail Ah, I see what you're doing! Is it your experience that as you keep adding to a row in the body that there's no limit to the length of that row, before you have to start another row? I suppose it's possible for me to set up a cursor thru every row in the table and write each column one at a time.... I'm also wondering if it's the email client that's responsible for deciding where to wrap a row when the user receives the email. Karen -----Original Message----- From: Buddy Walker <walker.bu...@comcast.net <mailto:walker.bu...@comcast.net> > To: rbase-l <rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> > Sent: Tue, Dec 17, 2019 7:46 am Subject: RE: [RBASE-L] - Long embedded files in RMail Karen This is part of the code I used in the past. This was for R:Mail X Buddy SET VAR vcol1 NOTE SET VAR vcol2 NOTE SET VAR vownerfname = ‘Karen’ SET VAR vgreeting TEXT = ('v1|ADD_TO_MESSAGE_BODY Dear ' + .vownerfname + ',') SELECT Col1 INTO vcol1 FROM …….. SELECT Col2 INTO vcol2 FROM …….. SET VAR vbody1 TEXT = ('v1|ADD_TO_MESSAGE_BODY ' + .vcol1 + ',') SET VAR vbody2 TEXT = ('v1|ADD_TO_MESSAGE_BODY ' + .vcol2 + ',') --Skipped all of the preliminary RMail stuff just showing the body part … PLUGINS rmail .vgreeting PLUGINS rmail 'v1|ADD_TO_MESSAGE_BODY ' PLUGINS rmail .vbody1 PLUGINS rmail 'v1|ADD_TO_MESSAGE_BODY ' PLUGINS rmail .vbody2 PLUGINS rmail 'v1|ADD_TO_MESSAGE_BODY ' PLUGINS rmail 'v1|ADD_TO_MESSAGE_BODY Thank you.' PLUGINS rmail 'v1|ADD_TO_MESSAGE_BODY ' PLUGINS rmail 'v1|ADD_TO_MESSAGE_BODY Buddy ' From: 'Karen Tellef' via RBASE-L <rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> > Sent: Monday, December 16, 2019 4:44 PM To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> Subject: Re: [RBASE-L] - Long embedded files in RMail 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.txt select Col1, Col2, Col3... Col10 FROM table output screen or output test.txt select NoteColumn FROM table output screen It's still gonna wrap that text file at the same place. Karen -----Original Message----- From: Buddy Walker <walker.bu...@comcast.net <mailto:walker.bu...@comcast.net> > To: rbase-l <rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> > Sent: Mon, Dec 16, 2019 2:10 pm Subject: RE: [RBASE-L] - Long embedded files in RMail 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 <rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> > Sent: Monday, December 16, 2019 2:55 PM To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 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 <walker.bu...@comcast.net <mailto:walker.bu...@comcast.net> > To: rbase-l <rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> > 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 <rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> > Sent: Monday, December 16, 2019 2:23 PM To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> 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 <walker.bu...@comcast.net <mailto:walker.bu...@comcast.net> > To: rbase-l <rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> > Sent: Mon, Dec 16, 2019 1:07 pm Subject: RE: [RBASE-L] - Long embedded files in RMail 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 <rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> > Sent: Monday, December 16, 2019 12:28 PM To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> Subject: [RBASE-L] - Long embedded files in RMail We create text files with select statements in them which will be used as the body of an RMail email. Before doing the select we set the width to 200 and the resulting text 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 the rmail 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 rbase-l+unsubscr...@googlegroups.com <mailto:rbase-l+unsubscr...@googlegroups.com> . To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1793718183.9281758.1576517295143%40mail.yahoo.com <https://groups.google.com/d/msgid/rbase-l/1793718183.9281758.1576517295143%40mail.yahoo.com?utm_medium=email&utm_source=footer> . -- 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 rbase-l+unsubscr...@googlegroups.com <mailto:rbase-l+unsubscr...@googlegroups.com> . To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/002b01d5b444%241ebdf900%245c39eb00%24%40comcast.net <https://groups.google.com/d/msgid/rbase-l/002b01d5b444%241ebdf900%245c39eb00%24%40comcast.net?utm_medium=email&utm_source=footer> . -- 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 rbase-l+unsubscr...@googlegroups.com <mailto:rbase-l+unsubscr...@googlegroups.com> . To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/2055323552.9393587.1576524160959%40mail.yahoo.com <https://groups.google.com/d/msgid/rbase-l/2055323552.9393587.1576524160959%40mail.yahoo.com?utm_medium=email&utm_source=footer> . -- 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 rbase-l+unsubscr...@googlegroups.com <mailto:rbase-l+unsubscr...@googlegroups.com> . To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/003401d5b449%2439f09ca0%24add1d5e0%24%40comcast.net <https://groups.google.com/d/msgid/rbase-l/003401d5b449%2439f09ca0%24add1d5e0%24%40comcast.net?utm_medium=email&utm_source=footer> . -- 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 rbase-l+unsubscr...@googlegroups.com <mailto:rbase-l+unsubscr...@googlegroups.com> . To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/501490761.9383680.1576526107722%40mail.yahoo.com <https://groups.google.com/d/msgid/rbase-l/501490761.9383680.1576526107722%40mail.yahoo.com?utm_medium=email&utm_source=footer> . -- 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 rbase-l+unsubscr...@googlegroups.com <mailto:rbase-l+unsubscr...@googlegroups.com> . To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/003d01d5b44c%24c99c3730%245cd4a590%24%40comcast.net <https://groups.google.com/d/msgid/rbase-l/003d01d5b44c%24c99c3730%245cd4a590%24%40comcast.net?utm_medium=email&utm_source=footer> . -- 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 rbase-l+unsubscr...@googlegroups.com <mailto:rbase-l+unsubscr...@googlegroups.com> . To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/2122187295.9378978.1576532620477%40mail.yahoo.com <https://groups.google.com/d/msgid/rbase-l/2122187295.9378978.1576532620477%40mail.yahoo.com?utm_medium=email&utm_source=footer> . -- 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 rbase-l+unsubscr...@googlegroups.com <mailto:rbase-l+unsubscr...@googlegroups.com> . To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/001001d5b4e0%24719bd650%2454d382f0%24%40comcast.net <https://groups.google.com/d/msgid/rbase-l/001001d5b4e0%24719bd650%2454d382f0%24%40comcast.net?utm_medium=email&utm_source=footer> . -- 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 rbase-l+unsubscr...@googlegroups.com <mailto:rbase-l+unsubscr...@googlegroups.com> . To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/532437874.282096.1576592672592%40mail.yahoo.com <https://groups.google.com/d/msgid/rbase-l/532437874.282096.1576592672592%40mail.yahoo.com?utm_medium=email&utm_source=footer> . -- 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 rbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/001d01d5b4ea%24af2e9430%240d8bbc90%24%40comcast.net.
