Creating emails via Outlook automation is an extremely common task. Adapting
the code is typically straightforward as the examples usually include the
most commonly used properties of the MailItem such as .To, .From, .Subject,
..Body as well as common methods suchas .Send and .Display
This article shows how to send an email from within Excel, but you should be
able to copy and past it directly into Access simply because its Outlook
that you're Automating. Excel, Access, Word, Powerpoint are merely the
applications running the code. Based on the code, you'll need to set a
reference to the Outlook Object Library. The code uses several Outlook
constants which Access won't be able to recognize without the reference. (In
the VBA Editor TOOLS > REFERENCES).
http://www.exceltip.com/st/Control_Outlook_from_Excel_using_VBA_in_Microsoft_Excel/464.html
Full documentation on the MailItem object is here if you need to dig into
the properties and methods
http://msdn.microsoft.com/en-us/library/aa210946(office.11).aspx
If you have problems with it post back to the
[microsoft.public.outlook.general] newsgroup.