Take a look at this video on sending emails from Access (which is less than 3 minutes long) highlighting one of the many new features of Microsoft Access 2010 using the ‘Collect Data’ feature integrating with Microsoft Outlook.
(original video no longer available – here’s a temporary 2007 version demo instead)
Sending Emails From Access Databases Using Access 2010 Outlook Collect Data
There are some rules however to note which includes obviously having Microsoft Outlook installed and configured ready for sending and receiving emails. Strange that I mention this because some users do not use Outlook for emails! So sending emails from Access uses the mail settings services as configured in Microsoft Outlook.
You will not be able to include certain field types in the form such as, AutoNumber, Attachment, OLE Object, or multi-valued lookup fields.
Designing an Access form (bound to a table) will be ideal for this sort of functionality and making sending emails from Access smooth to operate. Need to know how to build forms? Take a look at my eBook – How to build Microsoft Access Forms.
Tags: access 2007 email, Access Databases, ms access and outlook, send automatic email, sending emails from access, using access to send email
You may want to review this feature in a bit more detail by going to Microsoft’s page on Add the data collected through e-mails to your Access database.