Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Does anyone know how to create an alert in Excel/Acces ie email al | Excel Discussion (Misc queries) | |||
How do I create a sound alert in excel spreadsheet | Excel Discussion (Misc queries) | |||
How to Create Sound Alert and Email Alert when Macro is Finish | Excel Programming | |||
How to Create Sound Alert and Email Alert when Macro is Finished | Excel Programming | |||
How can I make a sound alert using macro in Excel! (But not use speaker) | Excel Programming |