New VBA Mailer: plug and play substitute for legacy Outlook automation. Check it out
Based on that, here’s a practical response: