title: email using Access and VBA without MAPI
body: <p>I would like to send email from Microsoft Access unattended using VBA.  I understand that the built-in method “SendObject” uses MAPI meaning security prompts and something like Outlook configured.  Since I want to use the Task Scheduler to kick off different reports, I’m leaning away from MAPI and would prefer some other solution.  Not an application for shipping but just in-house.  Ideas?</p>