View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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