I need to create an app, either a Console or a Web, that will automate creating reports and then sending via email to one or more addresses. I plan to use BKS Shorts, which I already use quite nicely in a Web API1 app.
There will be no interaction with any users, so either app can be headless.
I add all the necessary items into a database (in Desktop/Web/iOS apps), then call a WebApp via URLConnection to read the database and send the email via HandleURL (it doesn’t even get so far as creating a Session), and writes any sending error into the database plus a Boolean field that the email has been sent. This way I have a complete record of the sent emails and can easily resend it if needed.