Actually, I am still struggling with making this work.
It seems that order of dbr.mail options makes a significant difference and I am probably not using the correct one.
I have tried to switch things around, but still get an error.
Here is the sample code:
SELECT 'dbr.mail', 0;
SELECT 'dbr.mail.debug', 1;
SELECT 'dbr.mail.smtp.server', 'smtp.office365.com', 587, 1;
SELECT 'dbr.mail.smtp.authentication', 'firstname.lastname@example.org', 'mypassword';
SELECT 'dbr.mail.recipient', 'email@example.com', 'FirstName LastName';
SELECT email, name, subject, body FROM mytable;
Here is the error:
Invalid address: dbr.mail.smtp.authentication
I know that parameters I am passing to dbr.mail.smtp.authentication are valid, email address and password work when logging into Microsoft hosted Office365 exchange server.
I am not sure if I am using dbr.mail.smtp.server correctly though... Encryption method used is TLS, but I am not sure how to indicate that.
I also tried removing dbr.mail.smtp.server in order to use mail server from mydbr options, but the error is still the same - Invalid address: dbr.mail.smtp.authentication