Using Ninox to send emails

Hi Alan

Yes perfectly possible - if like me you are on the public cloud version that you get a monthly allowance to send emails using sendEmail

Here is an extract form one of my scripts (i have removed all the repeated lines a sample script 

i have cut it down to remove most of the letter variables but left a couple of lines in.

let xEMSubject := Mailer;
let a := (select Contacts where GDPR_Status = 1 );
for myVar in slice(a, 0, 150) do (This line loops th emails in batchs of 150 - change as needed)
    let thisBody := first((select Contact_Mailing).xLetter2); (Points to a stored template letter - with variables for name etc)
    let xEmail := myVar.Email;
    let myEmail := userEmail();
    let log1 := first(select Quote_Settings).HTMLxLogo; (where my logo is stored)
    let log1 := replace(log1, "{UL1}", shareFile(first(select Quote_Settings).xLogo));
    let xFirstName := myVar.FirstName;
    let xMailDate := myVar.today();
    let xOptInDate := myVar.OptInDate;
    let myAtt := first((select Contact_Mailing).Advert4); (add an attachment location)
    thisBody := replace(thisBody, "{FirstName}", xFirstName);
    thisBody := replace(raw(thisBody), "{xLogo}", log1);
    let i := (create EmailSentLog); (this section write an email log in another table)
    i.(Email := xEmail);
    i.(FullName := xFullName);
    i.(MailerDate := xMailDate);
    i.(OptInDate := xOptInDate);
    i.(OptOutDate := xOptOutDate);
    i.(Mailer := xEMSubject);
    sendEmail({
        from: myEmail,
        to: myVar.Email,
        subject: Mailer,
        text: "text",
        html: thisBody,
        attachments: myAtt
    });
    myVar.(EmailSend := 0)
end