/vba-email

VBA script sending email

Primary LanguageVisual Basic .NET

VBA-email

A simple VBA script to help send email using Excel, using CDO object or Outlook.

Usage

Read the code

Notes

While using Gmail SMTP server with CDO object, you will have to "Allow less secure apps"
https://support.google.com/accounts/answer/6010255?hl=en

Reference

https://www.makeuseof.com/tag/send-emails-excel-vba/

https://blog.xuite.net/saladoil/excel/8771822-%E4%BB%A5VBA%E5%82%B3%E9%80%81%E9%83%B5%E4%BB%B6--CDO%E7%89%A9%E4%BB%B6

https://stackoverflow.com/questions/46155/how-to-validate-an-email-address-in-javascript

https://officeguide.cc/excel-vba-regular-expressions-regex-tutorial/

https://docs.microsoft.com/en-us/office/vba/excel/concepts/working-with-other-applications/sending-email-to-a-list-of-recipients-using-excel-and-outlook