Send Email with CDO in Access, Without Outlook

In this Microsoft Access tutorial, I will show you how to send email using CDO instead of DoCmd.SendObject and Outlook. We will cover configuring SMTP settings, and creating a form to send emails directly from Access, logging sent emails, and basic error handling. Best of all... No mail program required!

Mallory from Edina, Minnesota (a Platinum Member) asks: Recently, I've encountered issues with DoCmd.SendObject when trying to send emails from Access, especially with the newer versions of Outlook. It seems like this method is no longer available. Could you recommend any alternative methods for sending emails directly from Access?

Members

There is no extended cut, but here is the database download:

•  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
• Value From a Form
• If Then

Links

• Microsoft What Version of Outlook
• Gmail App Passwords

Recommended Courses

• Access Email Seminar
• Access Developer Courses

Up Next

• Send Email with CDO, Part 2

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 Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, CDO email Microsoft Access, send email without Outlook, send email Access VBA, CDO SMTP tutorial, Collaboration Data Objects Access, CDO setup Gmail, VBA email Microsoft Access, migrate DoCmd.SendObject CDO, automate email Access Gmail, bypass Outlook Access email, VBA email script Access