| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing email notification address | Excel Discussion (Misc queries) | |||
| Changing font for incoming email | Excel Discussion (Misc queries) | |||
| Changing font color in email | Excel Programming | |||
| Changing subject line in email | Excel Programming | |||
| changing email addresses | Excel Discussion (Misc queries) | |||
Hybrid Mode
