Email Form to specific email addresses based on values selected in MultiSelect Box
$sql="SELECT addr1, city, status FROM listings WHERE status<>'Hidden' ";
$result=mysql_query($sql) or die(mysql_error());
$options="";

 while ($row=mysql_fetch_array($result)) {

     $addr1=$row["addr1"];
     $city=$row["city"];
     $status=$row["status"];
     $options.="<OPTION VALUE="$addr1">".$addr1 . ', ' . $city . ' - ' . $status;
 }

<select multiple name="unit" id="unit" size="10" validate="required:true, rangelength:[1,5]">
    <?=$options ?>
</select>

addr1        city        status        manager
address      somecity    available     John Citizen
addresstwo   city2       not available Jack Citizen
addressthree city3       available     Jill Citizen

mail($emailaddresses,$subject,$html,"From: info@#####rnContent-type: text/htmlrn");