View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Sean Sean is offline
external usenet poster
 
Posts: 454
Default E-mailing from Excel Q

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?