VBA – Automating Outlook

Automating Outlook from Access has become a more and more requested feature. The link provided below is the best source of information on this subject with complete code examples. However, before launching into automating Outlook to send emails from Access make sure that the DoCmd.SendObject method does not suffice your needs as it is much simpler to code.

https://web.archive.org/web/20061218070602/http://msdn2.microsoft.com/en-us/library/aa159619(office.11).aspx (Web Archive version as Microsoft has removed the original page)