Send Email from Access ~ DataPig

This video demonstrates the step by step use of the SendObject macro to add some email functionality to an application without code. In this example a weekly invoice report is created, and is automatically sent from Access to identified email recipients. In addition, the video shows how to loop through a recordset and send individual reports to individuals. The presenter uses step debugging to highlight the logic flow of the code. He also provides some sample situations where sending an email from within Access may be applicable.

In more recent versions of Access, the SendObject macro action appears to have been replaced with EMailDatabaseObject, but the concepts presented here still apply. Even though SendObject is no longer on the macro action list, it is still available in VBA and older macros that use it will still work.

Another macro action that got renamed is MsgBox to MessageBox.

This video has been resurrected from an older Access tutorial series by DataPigTechnologies. Even though Access looks different now, the concepts and functionality persist. Thanks to owner, Mike Alexander, for making these videos available for presentation once again. Thanks also to Jack Drawbridge and John Clark for helping get these valuable lessons back online.