Send E-Mail using CDO
Although Access has the capability to send out email messages through the SendObject method or the EmailDatabaseObject macro action, there may be situations where the user might not have Outlook or any email client installed on the machine. However, one well-known technique to send an email message through a remote SMTP server is by using Collaboration Data Objects (CDO).
You will need to know several configuration settings for the SMTP server, such as its address and port number, before you can use this demo. You can contact your Internet Service Provider (ISP) to get these information.
This demo was created using Access 2010 and tested using Access 2010 (but it should also work with 2007 and 2013.)
Please report all bugs to theDBguy@gmail.com.