Get client domains when sending email. PAID

[mihai666g]

Hi,

I want to send an email to all of my customers and list in the email all the domains with the extension .XX that they have.
I see that whmcs has something like {foreach from=$array_data item=data} {$data.option}: {$data.value} {/foreach} but I dont know how to create a foreach querry.

The output of the foreach query should look like this in the email

<tr>                 
       <th>$domain</th>
       <td>{$domain_expiry_date}</td>
 </tr>    

<tr>                 
       <th>$domain</th>
       <td>{$domain_expiry_date}</td>
 </tr>    

 

Can somebody help me with this? I can pay $10 via paypal.