Have you worked with Outlook automation ? it's not that different to create an email than to create a task, just need a different object. You may start by creating the Outlook Reference in Excel, and then all objects, properties and methods will appear in the Object Browser (F2)