Send Email Using CDO in Microsoft Access Instead of DoCmd.SendObject and 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!

Thank you for reading this post, don't forget to subscribe!

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?

BECOME A MEMBER:
YouTube:
or My Site:

LEARN MORE:
Send Email with CDO:

PREREQUISITES:
Intro to VBA:
Value From a Form:
If Then:

LINKS:
Microsoft What Version of Outlook:
Gmail App Passwords:

UP NEXT:
Send Email with CDO, Part 2:

RECOMMENDED COURSES:
Access Email Seminar:
Access Developer Courses:

FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates:
Blank Template:
Contact Management:
Order Entry & Invoicing:
More Access Templates:

ADDITIONAL RESOURCES:
FREE Access Beginner Level 1:
How to Use Access in 30 Minutes:
$1 Access Level 2:
Donate to my Tip Jar:
Get on my Mailing List:
Contact Me:
TechHelp:
Consulting Help:
Twitter:

KEYWORDS:
TechHelp, Access 2016, Access 2019, Access 2021, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, 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

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.