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 <[email protected]>
Sent: Monday, December 16, 2019 4:44 PM
To: [email protected]
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 <[email protected] <mailto:[email protected]> >
To: rbase-l <[email protected] <mailto:[email protected]> >
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 <[email protected]
<mailto:[email protected]> >
Sent: Monday, December 16, 2019 2:55 PM
To: [email protected] <mailto:[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] <mailto:[email protected]> >
To: rbase-l <[email protected] <mailto:[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]
<mailto:[email protected]> >
Sent: Monday, December 16, 2019 2:23 PM
To: [email protected] <mailto:[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] <mailto:[email protected]> >
To: rbase-l <[email protected] <mailto:[email protected]> >
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 <[email protected]
<mailto:[email protected]> >
Sent: Monday, December 16, 2019 12:28 PM
To: [email protected] <mailto:[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
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 [email protected]
<mailto:[email protected]> .
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 [email protected]
<mailto:[email protected]> .
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 [email protected]
<mailto:[email protected]> .
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 [email protected]
<mailto:[email protected]> .
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 [email protected]
<mailto:[email protected]> .
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 [email protected]
<mailto:[email protected]> .
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 [email protected]
<mailto:[email protected]> .
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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/001001d5b4e0%24719bd650%2454d382f0%24%40comcast.net.
