Posted to microsoft.public.excel.programming
|
|
Setting Up a "Reply-To" Email Address In MAPI
Hi Dennis
Is there a way, in VBA, to force this IE window to stay as the active window
during the form fill??
Sorry that's not my area
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Dennis Tucker" wrote in message ...
Ron,
Thank you. I will try it again.
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??
Dennis
"Ron de Bruin" wrote in message
...
However, I tried this and it did not work.
Use it like this
.SentOnBehalfOfName = """SenderName"" "
Maybe the other person must use a few extra lines when he use CDO
See this page for more info
http://www.rondebruin.nl/cdo.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Dennis Tucker" wrote in message
...
Ron,
Thanks for the help.
However, I tried this and it did not work.
I entered it as
.SentOnBehalfOfName "
Next, I tried using this
Set objMessage = CreateObject("CDO.Message")
objMessage.subject = "My Subject Line"
objMessage.From = "
objMessage.To = "
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.
Dennis
"Ron de Bruin" wrote in message
...
Hi Dennis
In Outlook code you can use
.SentOnBehalfOfName = """SenderName"" "
In Outlook 2007 you can change the account
http://www.rondebruin.nl/mail/account.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Dennis Tucker" wrote in message
...
Does anyone know a way to setup a "Reply-To" email address in MAPI/VBA
constructed emails??
Dennis
|