View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default How to Create Sound Alert and Email Alert when Macro is Finish

If you are on a corporate lan and working through and exchange server, I
believe you can remove this warning-but you might want to check in an
outlook group.


--
Regards,
Tom Ogilvy


"SteveC" wrote in message
...
http://www.rondebruin.nl/mail/prevent.htm

thanks...

I tried replaced ".send" with:

.Display
Application.Wait (Now + TimeValue("0:00:02"))
Application.SendKeys "%S"

but didn't work to me... It creates an email message, but I need to
press
the Send Button. I'm assuming the "%S" is the code for pressing Alt S,
but
if it is it doesn't do that for me.

and the CDO method looks too complicated for me to quickly figure out...

as per Ron's suggestino, I used
http://www.contextmagic.com/express-clickyes/
and it works, but would prefer not to use a third party program if I can
help it..

Thanks for your time and help. SteveC