Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Does anyone know how to create an alert in Excel/Acces ie email al nell Excel Discussion (Misc queries) 1 October 19th 09 07:25 PM
How do I create a sound alert in excel spreadsheet shaun t Excel Discussion (Misc queries) 8 November 23rd 08 12:09 AM
How to Create Sound Alert and Email Alert when Macro is Finish Bob Phillips Excel Programming 0 November 30th 06 09:21 PM
How to Create Sound Alert and Email Alert when Macro is Finished Bob Davison Excel Programming 0 November 30th 06 08:14 PM
How can I make a sound alert using macro in Excel! (But not use speaker) bookworm98 Excel Programming 5 December 11th 03 08:49 AM


All times are GMT +1. The time now is 07:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"