Email from Access without Outlook

[ahmed_optom]

Hi everyone,

I want to automatically send an email in the background from a form. Its a simple Customer service type email once a client has reached a certain point.

I am aware of the CDO option, however I believe it has now been retired. I did not want to use outlook as not all FE users have this.

Is there any way of sending an email from access using vba?

 

[CJ_London]

I am aware of the CDO option, however I believe it has now been retired

not so far as I am aware, what evidence to do you have?

 

[isladogs]

Agree with CJ London. CDO is definitely still available & in widespread use.
There are no signs of it being retired

See here for an email tester utility for checking settings for sending emails from Access using CDO:
https://www.access-programmers.co.uk/forums/showthread.php?t=293368

 

[ahmed_optom]

Apologies, your both correct, CDO is working fine.

I googled and found some conflicting information, but I have implemented a working cdo emailer today, and its great

 

[waynehiggins]

I want to send emails (Which I need to edit before I send, WITHOUT Outlook.
Any help please.

 

[isladogs]

As previously explained, you can do this using CDO.
This allows you to create and send emails from Access without using any external email application.
Suggest you try my Example app -see link in post #3 or use the latest version from my website http://www.mendipdatasystems.co.uk/email-tester/4594365455