Who has set up email sending via SMTP in Ninox? Please share your experience!

Ninox, cloud version only, does have email capabilities it is called sendEmail().

You can use the mail-module in a make.com scenario.

Don't use the Sendmail() function. More and more Email providers block the receiving of this mails without any notice. Use make.com and everything is fine.

Yes that is just one of one of the options we use. So will post some of what we do below fro this type of option. You should be able to follow this okay for multiple emails sent in bulk.

We used 2 primary buttons (emails ON and emails OFF) to set a condition to set all contacts as available to send letters or not in addition to a GDPR setting.

Screenshot 2024-12-13 at 18.05.09

script in Emails OFF

do as server
    for a in select Contacts where EmailSend = 1 do
        a.(EmailSend := 0)
    end
end

script in Emails On button

do as server
    for a in select Contacts where GDPR_Status = 1 and Email > " " and EmailSend != 1 do
        a.(EmailSend := 1)
    end
end

Main email ALL button

let xEMSubject := Mailer;
let a := (select Contacts where GDPR_Status = 1 and EmailSend); checks fully for GDPR setting as well as on off switch

for myVar in slice(a, 0, 150) do (NOTE the value 150 = send 150 emails in a batch - adjust this to suit)
    let thisBody := first((select Contact_Mailing).xLetter2); (location and name of of letter template)
    let xEmail := myVar.Email;
    let myEmail := userEmail();
    let log1 := first(select System_Settings).HTMLxLogo; (location of our company logo logo)
    let log1 := replace(log1, "{UL1}", shareFile(first(select System_Settings).xLogo));
    let xFirstName := myVar.FirstName;
    let xFullName := myVar.FullName;
    let xMailDate := myVar.today();
    let xOptInDate := myVar.OptInDate;
    let xOptOutDate := myVar.OptOutDate;
    let myAtt := first((select Contact_Mailing).Advert4); (advertisement image selection)
    thisBody := replace(thisBody, "{FirstName}", xFirstName);
    thisBody := replace(raw(thisBody), "{xLogo}", log1);
    let i := (create EmailSentLog);
    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 (advert attachement)
    });
    myVar.(EmailSend := 0) (set emails ON to OFF)
end

Screenshot 2024-12-13 at 18.22.45Screenshot 2024-12-13 at 18.23.44

iliper LTD

As requested- A very stripped down DB file

Kind regards

Mel