ATTN MVPS - Sending Emails From Access

[David C. Holley]

I ran across this blog post and was a bit intrigued by it.

http://www.intelliadmin.com/index.php/2009/11/send-email-from-the-command-line/

It details a .DLL that's available which allows emails to be sent via a
command line. It intrigues me because I'm wondering if it would be less
prone to fail as opposed to the other techniques for sending an email, such
as Outlook Automation. Granted you wouldn't be able to trap any errors from
the .DLL, but would it be more likely to succeed even though you'd still
have to have VBA code to run the command line.

Thoughts?

 

[Banana]

I ran across this blog post and was a bit intrigued by it.

http://www.intelliadmin.com/index.php/2009/11/send-email-from-the-command-line/

It details a .DLL that's available which allows emails to be sent via a
command line. It intrigues me because I'm wondering if it would be less
prone to fail as opposed to the other techniques for sending an email, such
as Outlook Automation. Granted you wouldn't be able to trap any errors from
the .DLL, but would it be more likely to succeed even though you'd still
have to have VBA code to run the command line.

Thoughts?

FWIW- If I don't want to depend on having Outlook or whatever, I use
CDO, which is going to be much more robust than using command line.

A well-designed .dll is supposed to return errors to the calling
clients, and since CDO can be used directly in VBA without resorting to
command line... why not CDO?

You can even expose a simple interface to enable custom configuration
(e.g. set up the SMTP server) so it can then be used by whatever email
they use.

 

[Stuart McCall]

I ran across this blog post and was a bit intrigued by it.

http://www.intelliadmin.com/index.php/2009/11/send-email-from-the-command-line/

It details a .DLL that's available which allows emails to be sent via a
command line. It intrigues me because I'm wondering if it would be less
prone to fail as opposed to the other techniques for sending an email,
such as Outlook Automation. Granted you wouldn't be able to trap any
errors from the .DLL, but would it be more likely to succeed even though
you'd still have to have VBA code to run the command line.

Thoughts?

I echo Banana's comments re CDO. In case you'd like to try it out, here is a
'starter pack':

http://www.smccall.demon.co.uk/Downloads.htm#cdo

 

[theDBguy]

Hi David,

In my humble opinion, that utility is perfect for network admins who use a
lot of command line tools. But if you're using Access, I agree with the
others that there are better options available without having to Shell out to
the OS for a simple send email task.

Just my 2 cents...