How to Create Sound Alert and Email Alert when Macro is Finish
 

Search Google for a product called Redemption.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
"SteveC" wrote in message
...
Tom, thanks.

I tried de Bruin's code, but I ran into a small problem:

MS Outlook provides the following alert msg:

"A program is trying to automatically send email on your behalf. Do you
want to allow this? If this is unexpected, it may be a virus and you
should
choose 'No.'"

Any clue how to disable this... since I'm trying to notify myself from the
public workstation computer, it's not really feasible to keep this caution
function enabled... the help button provided no clue...

"Tom Ogilvy" wrote:

for information on emailing with code (Ron de Bruin's site)


http://www.rondebruin.nl/sendmail.htm

--
Regards,
Tom Ogilvy


"SteveC" wrote:

Hi, wondering if anyone has code that would play a sound for 30 seconds
once
a macro is finished running. Better yet, send an email to someone
alerting
that a macro is finished. I need this alert because a macro I created
calls
upon some other programs that take eons to finish (not excel's fault),
and I
use this particular program at a computer open to everyone in our
office (not
at my desk).

I guess you could assume that a 30 second sound-clip could be be saved
to
the c:\, where macro would access it.

Maybe I could add a worksheet with a list of name contacts... starting
at
cell A1, maybe wtih the possibility of adding a few more contacts...

Thanks for thinking about this...

SteveC

Basically:

Sub test()
oringal code here
sound and/or email alert code here
end sub