Thread: email in XL XP
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
newbie newbie is offline
external usenet poster
 
Posts: 137
Default 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.