Send Email Using CDO in Microsoft Access Instead of DoCmd.SendObject and Outlook, Part 2

In this Microsoft Access tutorial, I will show you how to send email using CDO by communicating directly with the mail server, bypassing programs like Outlook. We'll set up configuration and code modules, handle email settings for providers like Gmail, and test the process. This is part 2.

BECOME A MEMBER:

LEARN MORE:

PREREQUISITES:

LINKS:

UP NEXT:

RECOMMENDED COURSES:

FREE TEMPLATE DOWNLOADS:

ADDITIONAL RESOURCES:

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, send email using CDO in Microsoft Access, VBA email without Outlook, Access CDO email, Microsoft Access email tutorial, sending mail from Access, VBA send email CDO, Microsoft Access CDO configuration, Access CDO SMTP settings, CDO email module Access, VBA send email Gmail, Access custom email VBA, CDO email troubleshooting

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

[Shadow.Dragon]

Thanks Richard (and Juan) for the great series!

[rtatt]

Good stuff again, Richard. But I do disagree with what you said @6:35. By all means copy/paste code someone else has made public, but I ALWAYS ensure I understand what it's doing and how it's doing it, otherwise you never know what problems you might encounter as a consequence.

[dzuvksh]

Thank you very much Rick!
Why do I get an error on this line?? Public Const TIMEOUT = 10 (expected end of statment)

[joeroske]

Is there a way to automatically add a signature block to the body?

[omegacodedeveloper]

sir, how did you set up the gmail app password?