How do I send an email using Microsoft Access?

Can you send email from MS Access?

Sending emails from Microsoft Access databases is a very powerful feature. Disseminating data and reports to your contacts can significantly improve your service and communications, and save paper and postage. Microsoft Access lets you send emails using VBA module code or a macro with the DoCmd. SendObject method.

How do I automatically send email from Access?

4 Ways to Automate Sending Emails from Microsoft Access1Access & Email. ... 2vbMAPI - Outlook Security Evader for Visual Basic. ... 3Sending Emails from Access with VBA and CDO. ... 4Microsoft Access Email Add-in program emails messages with PDF reports from your MS Access Databases, HTML and text. ... 5DoCmd.SendObject method (Access)

How do I email a report from Access?

Send a report by using the Email command With just a few mouse clicks, Access exports the report, and then creates a new e-mail message with the file attached to it. In the Navigation Pane, select the report that you want to send. Select External Data > Email.