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

http://www.intelliadmin.com/index.ph...-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?

David C. Holley wrote:
> I ran across this blog post and was a bit intrigued by it.
>
> http://www.intelliadmin.com/index.ph...-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.

"David C. Holley" <David.C.Holley> wrote in message
news:(E-Mail Removed)...
>I ran across this blog post and was a bit intrigued by it.
>
> http://www.intelliadmin.com/index.ph...-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

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...


"David C. Holley" wrote:

> I ran across this blog post and was a bit intrigued by it.
>
> http://www.intelliadmin.com/index.ph...-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?
>
>
> .
>