Hi Newbe

SendKeys can give different results and is not reliable
See if you can use CDO
http://www.rondebruin.nl/mail/prevent.htm


--
Regards Ron De Bruin
http://www.rondebruin.nl



"Newbie" wrote in message ...
I have used Ron de Bruin's code to send about 50 emails with xls attachments
direct from excel.

.Send

to supress the warnings i replaced code above with code below:

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

It works fine on 2000, but not on XP. Does anyone have any code that will
suppress warnings within XP?

Thanks in advance.