ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Changing the From: in an email (https://www.excelbanter.com/excel-programming/392423-changing-email.html)

David A.

Changing the From: in an email
 
I am trying to send a sheet to users. I have to set the FROM: address to
something other then my email address, a general inbox we have set up so if
theey "Reply" it goes there. EX: I am sending to Joe Shoe and I need it to
appear that ABC Company is sending it to him even though its me David
Abercrombie that is sending it. I have tried .Item.From=ABC Company but this
doesn't do anything but give me an error....Help
Thanx.

Ron de Bruin

Changing the From: in an email
 
Hi David

If you try one of my Outlook examples here
http://www.rondebruin.nl/sendmail.htm

From my Tips page

If you want to change the sender name and reply address add this code line

'The receiver can see the original mail address in the properties if he want
..SentOnBehalfOfName = """SenderName"" "



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"David A." wrote in message ...
I am trying to send a sheet to users. I have to set the FROM: address to
something other then my email address, a general inbox we have set up so if
theey "Reply" it goes there. EX: I am sending to Joe Shoe and I need it to
appear that ABC Company is sending it to him even though its me David
Abercrombie that is sending it. I have tried .Item.From=ABC Company but this
doesn't do anything but give me an error....Help
Thanx.


blackbox via OfficeKB.com

Changing the From: in an email
 
or if you use a CDO, bypassing Outlook all together you can send it from who
ever you want

Ron de Bruin wrote:
Hi David

If you try one of my Outlook examples here
http://www.rondebruin.nl/sendmail.htm

From my Tips page

If you want to change the sender name and reply address add this code line

'The receiver can see the original mail address in the properties if he want
.SentOnBehalfOfName = """SenderName"" "


I am trying to send a sheet to users. I have to set the FROM: address to
something other then my email address, a general inbox we have set up so if

[quoted text clipped - 3 lines]
doesn't do anything but give me an error....Help
Thanx.


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200706/1


Ron de Bruin

Changing the From: in an email
 
or if you use a CDO, bypassing Outlook all together you can send it from who
ever you want


See
http://www.rondebruin.nl/cdo.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"blackbox via OfficeKB.com" <u20390@uwe wrote in message news:747169a211500@uwe...
or if you use a CDO, bypassing Outlook all together you can send it from who
ever you want

Ron de Bruin wrote:
Hi David

If you try one of my Outlook examples here
http://www.rondebruin.nl/sendmail.htm

From my Tips page

If you want to change the sender name and reply address add this code line

'The receiver can see the original mail address in the properties if he want
.SentOnBehalfOfName = """SenderName"" "


I am trying to send a sheet to users. I have to set the FROM: address to
something other then my email address, a general inbox we have set up so if

[quoted text clipped - 3 lines]
doesn't do anything but give me an error....Help
Thanx.


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200706/1



All times are GMT +1. The time now is 03:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com