Send out mails to different individuals with separate info.

tahsin

Number	City	Arrival	Airport	Name	Email
234	New York	2:39 PM	JFK	Alex	alex@email.com
221	Alabama	7:21 AM	ALB	John	john@email.com
122	Maine	7:07 PM	LGA	Chris	chris@email.com

I have a dataset like this, I want to use the email of the dataset to send out mails to each individual with their  information. I have used the Send Mail operator before but not quite sure how to email each individual with the info.  Each individual only get their own info in the email. 

Any help is appreciated. Thanks. 

Marco_Barradas

Hi @tahsin,

You can use this example to build what you need.

You might need to install the Converters Extension to use the html macro to covert an example set to HTML table.

Please contact me if you have further questions on how you can use the operator.

It would be a great use of AI Hub since you can schedule a task to execute daily or ever x days to send data.

<?xml version="1.0" encoding="UTF-8"?><process version="9.10.000">
  <context>
    <input/>
    <output/>
    <macros/>
  </context>
  <operator activated="true" class="process" compatibility="9.10.000" expanded="true" name="Process">
    <parameter key="logverbosity" value="init"/>
    <parameter key="random_seed" value="-1"/>
    <parameter key="send_mail" value="never"/>
    <parameter key="notification_email" value=""/>
    <parameter key="process_duration_for_mail" value="30"/>
    <parameter key="encoding" value="SYSTEM"/>
    <process expanded="true">
      <operator activated="true" class="generate_direct_mailing_data" compatibility="9.10.000" expanded="true" height="68" name="Generate Direct Mailing Data" width="90" x="179" y="34">
        <parameter key="number_examples" value="100"/>
        <parameter key="use_local_random_seed" value="false"/>
        <parameter key="local_random_seed" value="1992"/>
      </operator>
      <operator activated="true" class="generate_attributes" compatibility="9.10.000" expanded="true" height="82" name="Generate Attributes" width="90" x="313" y="34">
        <list key="function_descriptions">
          <parameter key="email" value="concat(name,&quot;@somedomain.com&quot;)"/>
        </list>
        <parameter key="keep_all" value="true"/>
      </operator>
      <operator activated="true" class="loop_examples" compatibility="9.10.000" expanded="true" height="82" name="Loop Examples" width="90" x="514" y="34">
        <parameter key="iteration_macro" value="example"/>
        <process expanded="true">
          <operator activated="true" class="extract_macro" compatibility="9.10.000" expanded="true" height="68" name="Extract Macro" width="90" x="45" y="34">
            <parameter key="macro" value="name"/>
            <parameter key="macro_type" value="data_value"/>
            <parameter key="statistics" value="average"/>
            <parameter key="attribute_name" value="name"/>
            <parameter key="example_index" value="%{example}"/>
            <list key="additional_macros">
              <parameter key="age" value="age"/>
              <parameter key="car" value="car"/>
              <parameter key="zipcode" value="zip code"/>
              <parameter key="email" value="email"/>
            </list>
          </operator>
          <operator activated="true" class="filter_example_range" compatibility="9.10.000" expanded="true" height="82" name="Filter Example Range" width="90" x="179" y="34">
            <parameter key="first_example" value="%{example}"/>
            <parameter key="last_example" value="%{example}"/>
            <parameter key="invert_filter" value="false"/>
          </operator>
          <operator activated="true" class="converters:example_set_2_html" compatibility="0.9.000" expanded="true" height="82" name="ExampleSet to HTML" width="90" x="313" y="34">
            <parameter key="macro" value="htmlMacro"/>
            <parameter key="Use a limit on Digits" value="false"/>
            <parameter key="Number of Digits" value="3"/>
            <parameter key="HTML class name for the table" value="rapidminer-table"/>
          </operator>
          <operator activated="true" class="send_mail_attachments" compatibility="9.10.000" expanded="true" height="82" name="Send Mail" width="90" x="648" y="34">
            <parameter key="to" value="%{email}"/>
            <parameter key="subject" value="Hello %{name} this if for you."/>
            <parameter key="use_html" value="true"/>
            <parameter key="body_html" value="&lt;html&gt;&#10;&#9;&lt;head&gt;&#10;&#9;&#9;&lt;title&gt;RapidMiner Mail Message&lt;/title&gt;&#10;&#9;&lt;/head&gt;&#10;&#9;&lt;body&gt;&#10;&#9;&#9;&lt;p&gt;&#10;&#9;&#9;Hello %{name};&#10;&#10;&#9;&#9;Now that your are %{age} old you are ready to buy your %{car}. Please find the best dealer close to %{zipcode} your zipcode.&#10;&#9;&#9;Also please use the following info.&#10;&#9;&#9;&lt;/p&gt;&#10;&#9;&#9;%{htmlMacro}&#10;&#9;&lt;/body&gt;&#10;&lt;/html&gt;&#10;"/>
            <list key="filenames"/>
            <list key="headers"/>
          </operator>
          <connect from_port="example set" to_op="Extract Macro" to_port="example set"/>
          <connect from_op="Extract Macro" from_port="example set" to_op="Filter Example Range" to_port="example set input"/>
          <connect from_op="Filter Example Range" from_port="example set output" to_op="ExampleSet to HTML" to_port="example set input"/>
          <portSpacing port="source_example set" spacing="0"/>
          <portSpacing port="sink_example set" spacing="0"/>
          <portSpacing port="sink_output 1" spacing="0"/>
        </process>
      </operator>
      <connect from_op="Generate Direct Mailing Data" from_port="output" to_op="Generate Attributes" to_port="example set input"/>
      <connect from_op="Generate Attributes" from_port="example set output" to_op="Loop Examples" to_port="example set"/>
      <connect from_op="Loop Examples" from_port="example set" to_port="result 1"/>
      <portSpacing port="source_input 1" spacing="0"/>
      <portSpacing port="sink_result 1" spacing="0"/>
      <portSpacing port="sink_result 2" spacing="0"/>
    </process>
  </operator>
</process>