I Need to send email by triggered Email to all list in Table

My problem is that the code sends emails to the first email in the table, not all emails


export function button11_click(event) {
    let rows=$w("#table1").rows;
    let i=0;
    rows.forEach(function(item,index,rows){
        if(item.name){i++;
console.log(item.name+"-"+item.courseName+"-"+item.startDate);
wixData.query("Members/PrivateMembersData")
.eq("loginEmail",item.email)
.find()
.then((results) => {
if(results.length > 0){
let user=results.items[0];
let id=user._id;
triggeredEmails.emailMember("T0Rthcz", id, {
"variables": {
"name": item.name,
"courseName":item.courseName,
"startDate":item.startDate
}
})
.then(() => {
    $w("#msg").text="تم ارسال الشهادات بنجاح";
    $w("#msg").expand();
$w("#text74").show();
console.log("تم ارسال الشهادات بنجاح");
})
.catch((err) => {
        $w("#msg").text="لم يتم ارسال الشهادات   "+err+"";
    $w("#msg").expand();
    $w("#text75").text=err;
$w("#text75").show();
console.log("لم يتم ارسال الشهادات");
});
    }
})
.catch((err) => {
   console.log(err);
});
    
}
    });
    console.log(i);
}


Any help

1 Like