Send Email from Excel VBA – Outlook Automation Macro | ComTools

VBA macro to send email from Excel via Outlook: attach workbook, HTML body from range, send to list in column A.

Outlook vs CDO

CreateObject("Outlook.Application") is standard on Windows with Outlook installed. Warn users about macro security and trust center settings.