Create an Email Client within an Access Application

[George0726]

I need to create an Email Client WITHIN an Access application for SENDING Emails (not receiving) WITHOUT USING OUTLOOK.

Does anyone know how to do this?

[jimatqsi]

Search the site for sending CDO email. There's been quite a bit of that over the years.

[zmbd]

There are a few methods; however, the CDO method is one of the more common for use without using Outlook automation.
If you search on "Email, CDO, Microsoft" you will find tons of code snipits for sending the message.
As for getting the information into your emails, standard recordset manipulations to pull the desired information.

Also, please do yell - which is what all caps is taken to mean.