Set objMessage = CreateObject("CDO.Message")
objMessage.subject = "My Subject Line"
objMessage.From = ="(e-mail address removed)"
objMessage.To = ="(e-mail address removed)"
objMessage.TextBody = ="My body text here."
objMessage.Send
This works better on my system. It does not give me the security prompt
either. However, this same code on another persons computer does not do so
well.
On another topic. I am trying to send data to a web form. I am able to set
the focus on each control(on the web form). I am able to "SendKeys" too.
However, if the IE window containing the web form does not stay as the
active window, the form filling gets screwed up.
Is there a way, in VBA, to force this IE window to stay as the active window
during the form fill??
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.