Jan, You may use the LISTOF function to gather values in a variable separated by a comma delimiter. SELECT (LISTOF(ColumnName)) INTO VariableName INDICATOR IndVar FROM TableView WHERE ... SET VAR vValueList TEXT = NULL SELECT (LISTOF(ColumnName)) INTO vValueList INDIC IvValueList FROM TableName WHERE ... The variable vValueList will be a text string of the values separated by the current comma delimiter character. --Razzak
> On 08/08/2025 9:20 AM EDT jan johansen <[email protected]> wrote: > > Jim, > > I basically use the same idea. However, I have a question. > > I use the EMAIL_TO and send individually. Could be 5 individual emails. > How do you gather the email addresses to use the EMAIL_TO_LIST function? > > Jan > > From: "RDA Technician" <[email protected]> > To: <[email protected]> > Date: Wed, 06 Aug 2025 16:29:59 -0400 > Subject: Re: [RBASE-L] - Email delimma > > > > There was a few emails about this, if you want to look back and get some > > additional feedbacks. But here it is: > > > > PRINT email_report OPTION PDF|FILENAME ALERT.PDF + > > |EMAIL ON + > > |EMAIL_TO_LIST .vEmailToList mailto:[email protected] + > > |EMAIL_CC_LIST .vEmailCCList + > > |EMAIL_BCC_LIST .vEmailBCCList + > > |EMAIL_FROM_NAME From Name you want + > > |EMAIL_FROM_ADDRESS [email protected] > > mailto:[email protected] + > > |EMAIL_SUBJECT .vSubject + > > |EMAIL_BODY .vBody + > > |EMAIL_HOST .vemail_host + > > |EMAIL_AUTHENTICATION .vemail_authentication + > > |EMAIL_PORT .vemail_port + > > |EMAIL_USERID .vemail_userid + > > |EMAIL_PASSWORD .vemail_password + > > |EMAIL_DELETE_AFTER_SEND ON + > > |EMAIL_SHOW_DIALOG OFF + > > |SHOW_CANCEL_DIALOG OFF > > > > What I do to incorporate it into our Email system, is I made a SENT ITEMS > > RBASE Folder and a rule. I BCC the USERS that send that email in Rbase, > > and the email Rule, will receive the email, move it to the SENT ITEMS RBASE > > Folder. So that they have a copy of all emails sent from your Rbase > > program in their email system. If you have a CRM integrated with your > > email system, then you will see those emails in your email system. > > > > Hope that helps > > > > Robert Diaz > > >>> "'jim schmitt' via RBASE-L" <[email protected]> 8/6/2025 4:14 PM > > >>> >>> > > Hello , Group: > > Version RB11 > > > > Situation: customer wants to inquire on an account, which has an email > > address, and have a button on the screen labeled 'Email Statement' in > > order to print a statement and send it via email. I do have the inquiry > > working with a button labeled 'Print Statement' which works fine, but > > trying to get another button option to send via email is not working. > > > > I have never tried to send an email from R:base and today I am struggling > > badly using one of the samples from RB 11/Samples/RRBW21, and am stumped > > trying to get email to work. I guess on some things I am dense. > > > > Does anyone have something like this in their code, and can share it with > > me. > > My butt may be on the line on this....... > > > > Thanks in advance > > > > Jim Schmitt > > Ohio Software Services > > 1-614-361-3942 > > > > -- > > > > 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 visit > > https://groups.google.com/d/msgid/rbase-l/118601033.2711092.1754511247708%40mail.yahoo.com > > > > https://groups.google.com/d/msgid/rbase-l/118601033.2711092.1754511247708%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 visit > > https://groups.google.com/d/msgid/rbase-l/6893BB470200001D0000A3F7%40mail.mrsbaking.com > > > > https://groups.google.com/d/msgid/rbase-l/6893BB470200001D0000A3F7%40mail.mrsbaking.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 visit > https://groups.google.com/d/msgid/rbase-l/WC20250808132012.080151%40jjcalibrations.com > > https://groups.google.com/d/msgid/rbase-l/WC20250808132012.080151%40jjcalibrations.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 visit https://groups.google.com/d/msgid/rbase-l/1138668318.566970.1754662861167%40email.ionos.com.
