email in XL XP

N

Newbie

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Send unattended email from Outlook using Excel macro 3
SendKeys on a locked PC 1
Email with Outlook Express Problem 1
Loop +2, +4, etc. help 5
.Display (One for Ron De Bruin maybe!!) 0
Attaching a Read Receipt to Outlook E-mail 2
Disable spell check in outgoing email 4
Help...Automate send e-mail code.... 5

Top