View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
JP[_4_] JP[_4_] is offline
external usenet poster
 
Posts: 897
Default E-mailing from Excel Q

There was a thread about changing the sending account in one of the
Outlook newsgroups (I believe microsoft.public.outlook.program_vba),
I'll try to find it and send you a link, but I believe the response
was that it isn't possible without CDO/Redemption.


--JP

On Jan 23, 11:24*am, Sean wrote:
Thanks Ron, the .sendonbehalfofname works great except I just wish to
see the other A/c as the "From name & address" rather than the
default.

I tried various suggestions you have made on past post such as
* * * * * * .SenderName = """ABC Company"""
* * * * * * .SenderEmailAddress = "

But they just send from the name on the default a/c

If the above were to work on a valid outlook a/c, is it the "Log in"
information which controls where it is sent from and hence must be
included within the VB?