Explore sample code as you learn to use Automation to create Outlook 2007 contacts from a contact list in Access 2007, and then send Outlook 2007 e-mail from within Access.
Read the rest here:
Sample: Adding Contacts and Sending E-mail in Access 2007 by Using Outlook 2007 (Visual How To)