Email Notification of a completed VBA process

[ibeetb]

Would anyone know how I can automatically generate a text message to be sent
via email at the completion of a scheduled Excel VBA process that was run
automatically without user intervention?

 

[Andrew Cushen]

I would imagine you could do this quite easily using Excel
VBA to automate Outlook. Just add some Excel VBA to check
if your process was successful, then some lines to call
Outlook to send the mail.

There are numerous examples of how to send e-mail from
Outlook using VBA in the Outlook VBA Help itself- press
Alt-F11 in Outlook to open the VBA editor, then press F1
to open VBA Help. You may need to do a re-install/add
components of Office to add VBA Help if you didn't install
it when you installed Office.
Also see www.slipstick.com, and Microsoft's www.msdn.com
web site for samples.

You may run into issues with Macro Security, too-
www.slipstick.com is the site to search for tips on that.
Probably you'll wind up using the Selfcert.exe program to
certify your Macro code. Slipstick has explicit
instructions.

If you are already developing Excel VBA code, you should
have no problems with Outlook. Just follow the examnples;
and you'll want to add a Reference to the Outlook Object
Library.

-Andrew
=========================================

 

[ali kwok]

I have successfully used the CDO for Exchange 2000 Server interface to accomplish unattended SMTP mail notification from VBA. In addition, try the Office Solutions Dev>Access>Moduledaovba newsgroup for several recent posts on this topic which where MVPs list other potential solutions

----- ibeetb wrote: ----

Would anyone know how I can automatically generate a text message to be sen
via email at the completion of a scheduled Excel VBA process that was ru
automatically without user intervention