Using VBA Automation to send external Email using Outlook Express

[tunsarod]

I've read a lot today from the archives about sending email's internally over networks using Outlook.

But of using VBA Automation to control the sending of EXTERNAL emails via Outlook Express - absodamlutely nothing, zilch.

Why'zat if its not a stupid question?

Can anyone offer a solution to sending an email over the internet from an Access application via Outlook Express? Preferablly without having Outlook Express deploy on screen. i.e. in the background - if not quite in the dark.

Rod

 

[rdeleon]

Unless I am totally misunderstanding you, I have used the SendObject command to launch/send the default email program based on the computer being used. In my case it is Outlook Express.

DoCmd.SendObject [objecttype][, objectname][, outputformat][, to][, cc][, bcc][, subject][, messagetext][, editmessage][, templatefile]

If you set the [editmessage] argument to "false", the email should send in the background.

Rene'

 

[danvlas]

You can use Automation only with ActiveX objects that expose their collections and objects for this purpose.
Outlook Express is not controllable programatically. It is practically a 'system' mail client, created for this particular purpose. Maybe it is possible to use it, but I haven't seen any documentation about its syntax, collections, objects, methods or properties.

There is an alternate solution for sending mail: use a server rather than a client. A free mail server that supports Automation.
can be downloaded here:

http://www.argosoft.com/applications/mailserver/

Daniel Vlas
Systems Consultant
danvlas@yahoo.com