.Display (One for Ron De Bruin maybe!!)

J

John

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

I get an error message "Object Doesn't support this property or method"
Background to this is using Ron's VBA code to mail out avoiding Security.

If i use Windows.Application.ActivateMicrosoftApp (xlMicrosoftMail) then
Outlook becomes the active Window but i also get the Calculator!!!

Any ideas on this please?

Thanks
John
 

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

email in XL XP 1
Ron de Bruin's instructions on Excel 2007 ribbon 0
SendKeys on a locked PC 1
Help...Automate send e-mail code.... 5
Attaching a Read Receipt to Outlook E-mail 2
Questions on Ron de Bruin's Excel Email Macro 4
Disable spell check in outgoing email 4
SendKeys problem 5

Top