email in XL XP
 

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.

email in XL XP
 

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.