topic Re: How do I send a dynamic email in SAS Programming https://communities.sas.com/t5/SAS-Programming/How-do-I-send-a-dynamic-email/m-p/692392#M210926 <P>UP</P> Sun, 18 Oct 2020 19:54:19 GMT shlomiohana 2020-10-18T19:54:19Z How do I send a dynamic email https://communities.sas.com/t5/SAS-Programming/How-do-I-send-a-dynamic-email/m-p/692302#M210877 <P>Hello,</P><P><BR />I have the following final table (every day the table contents change):</P><TABLE border="1"><TBODY><TR><TD>Date</TD><TD>Bank_ID</TD><TD>Branch_ID</TD><TD>Account_Number</TD><TD>Credit_Card</TD><TD>Credit_Card_Group</TD><TD>ID_number</TD><TD>Mail_To</TD></TR><TR><TD>01/10/2020</TD><TD>20</TD><TD>1</TD><TD>1234567</TD><TD>2234</TD><TD>pix</TD><TD>4432252</TD><TD>pix@gmail.com</TD></TR><TR><TD>01/10/2020</TD><TD>20</TD><TD>112</TD><TD>3224334</TD><TD>3424</TD><TD>pix</TD><TD>2552367</TD><TD>pix@gmail.com</TD></TR><TR><TD>01/10/2020</TD><TD>20</TD><TD>1</TD><TD>1234567</TD><TD>5677</TD><TD>lum</TD><TD>4432252</TD><TD>lum@gmail.com</TD></TR><TR><TD>01/10/2020</TD><TD>20</TD><TD>34</TD><TD>2344523</TD><TD>4545</TD><TD>lum</TD><TD>3656890</TD><TD>lum@gmail.com</TD></TR><TR><TD>01/10/2020</TD><TD>20</TD><TD>1</TD><TD>1234567</TD><TD>4299</TD><TD>pix</TD><TD>4432252</TD><TD>pix@gmail.com</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I would like to send an email to each record in the table that the combination of the fields is an Account_Number and a Credit_Card_Group is different.</P><P>According to the example, I will send 4 emails.</P><P>&nbsp;</P><P><U>The&nbsp;Email:</U></P><P>From: <A href="mailto:freetalk@gmail.com" target="_blank" rel="noopener">freetalk@gmail.com</A></P><P>To: &lt;Mail_To&gt;</P><P>Subject:&nbsp;Closing &lt;Account_Number&gt; - &lt;Branch_ID&gt;</P><P>Email content:</P><P>&lt;Credit_Card_Group&gt; , &lt;Date&gt;</P><P>Cancel any instructions in the account &lt;Account_Number&gt; - &lt;Branch_ID&gt; -&lt;Bank_ID&gt;</P><P>credit cards-</P><P>1.&lt;Credit_Card&gt; - &lt;ID_number&gt;</P><P>2.&nbsp;&lt;Credit_Card&gt; - &lt;ID_number&gt;</P><P>Thanks.</P><P>&nbsp;</P><P><U>Example of an email from the table</U>:</P><P>From: <A href="mailto:freetalk@gmail.com" target="_blank" rel="noopener">freetalk@gmail.com</A></P><P>To: pix@gmail.com</P><P>Subject:&nbsp;Closing 1234567&nbsp;- 1</P><P>Email content:</P><P>pix, 01/10/2020</P><P>Cancel any instructions in the account 1234567 - 1 - 20</P><P>credit cards-</P><P>1.2234&nbsp;- 1234567</P><P>2.4299&nbsp;- 1234567</P><P>Thanks.</P><P>&nbsp;</P><P>I would appreciate your help.</P> Sat, 17 Oct 2020 16:16:22 GMT https://communities.sas.com/t5/SAS-Programming/How-do-I-send-a-dynamic-email/m-p/692302#M210877 shlomiohana 2020-10-17T16:16:22Z Re: How do I send a dynamic email https://communities.sas.com/t5/SAS-Programming/How-do-I-send-a-dynamic-email/m-p/692392#M210926 <P>UP</P> Sun, 18 Oct 2020 19:54:19 GMT https://communities.sas.com/t5/SAS-Programming/How-do-I-send-a-dynamic-email/m-p/692392#M210926 shlomiohana 2020-10-18T19:54:19Z Re: How do I send a dynamic email https://communities.sas.com/t5/SAS-Programming/How-do-I-send-a-dynamic-email/m-p/692415#M210941 <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/288727">@shlomiohana</a>&nbsp;- To get a better response I suggest you post what you have tried so far. Many contributors like to see an attempt before they reply.</P> Mon, 19 Oct 2020 03:37:47 GMT https://communities.sas.com/t5/SAS-Programming/How-do-I-send-a-dynamic-email/m-p/692415#M210941 SASKiwi 2020-10-19T03:37:47Z Re: How do I send a dynamic email https://communities.sas.com/t5/SAS-Programming/How-do-I-send-a-dynamic-email/m-p/692423#M210948 <P>Please provide data in usable form, if you want to see working code.</P> <P>Hints: sort the data by Mail_To an Account_Number, then use by-group-processing in a data-step.</P> Mon, 19 Oct 2020 05:20:44 GMT https://communities.sas.com/t5/SAS-Programming/How-do-I-send-a-dynamic-email/m-p/692423#M210948 andreas_lds 2020-10-19T05:20:44Z