Use SendObject to Email a Report in MS Access

In this Microsoft Access tutorial I'm going to teach you how to use the SendObject command to email an invoice or any other report with just one click.

James from Cheyenne, Wyoming (a Platinum Member) asks: Is it possible to send an invoice directly to a customer by just clicking on a button on the order form itself. Right now I've got a click to open the invoice report and then click the send the button and then copy and paste their email address and type in a little message and a subject and it's just a big pain. Can all of this be automated?

Update

Please note that this technique only works with the original Microsoft Outlook application that comes with Office, not the new Outlook app found in the Microsoft App Store. Nor does it work with the online-only version of Outlook. They fundamentally changed the way it sends emails for "security" purposes. 

Members

Members will learn how to customize the invoice so that the attachment has a custom file name, check to make sure there is an email address for this customer before sending, and deal with the error if the user cancels sending.

•  01. Free Video
•  02. Extended Cut Video - Silver Members
•  Database Download - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Prerequisites

• Intro to VBA: https://599cd.com/IntroVBA
• Value From a Form: https://599cd.com/FormName

Links

• Send Email: https://599cd.com/SendOutlookEmail
• Microsoft SendObject Page: https://tinyurl.com/2bnzfp77

Recommended Courses

• Access Email Seminar: https://599cd.com/EmailSeminar

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Merch Store - Get your swag here! Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, email report from ms access, email ms access report using outlook, docmd.sendobject, sendobject, acformatpdf, email pdf file from ms access, ms access send report via email as pdf