| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting Up a "Reply-To" Email Address In MAPI
Does anyone know a way to setup a "Reply-To" email address in MAPI/VBA constructed emails??
Dennis |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Setting Up a "Reply-To" Email Address In MAPI
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Setting Up a "Reply-To" Email Address In MAPI
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Setting Up a "Reply-To" Email Address In MAPI
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Setting Up a "Reply-To" Email Address In MAPI
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 |
|
#6
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),QuoteNotes, | Excel Worksheet Functions | |||
| Using "@" unrelated to email address | Excel Worksheet Functions | |||
| Excel Email Macro - "From" Address. | Excel Programming | |||
| Why does Outlook.Application.GetNamespace("MAPI") Fail? | Excel Programming | |||
| setting address in "mail as attachment" macro | Excel Programming | |||
Linear Mode
