email in XL XP

[Guest]

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.

 

[Ron de Bruin]

Hi Newbe

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