On Tue, 4 Sep 2018, at 7:35 PM, Kevin J Cully wrote:
Instead of using Outlook automation, and risking it breaking during every upgrade, and potentially being marked as a spammer, perhaps using a transactional email service might be an approach to consider.
This is definitely the way to go these days for bulk sending. Outlook, and specifically Outlook connected to hosted Exchange, is not designed to do bulk sends.
If you look at a service like SendGrid, you can set up HTML templates to handle your company logos and stationery and achieve mail-merge type functionality, it has an excellent API that you can pump the raw email information and attachments into, it will handle all the re-sending and reporting on failed sends, and it's inexpensive even for hundreds of thousands of mails. There is a small pain point in setting up DKIM\SPF so that they can send emails on your domain's behalf but beyond that it works extremely well.