Send as specifc sender from Outlook - VBA

[Stridhan]

Hi

Got a urgent problem which I can't solve and haven't seen any solution in here.

Got different accounts in outlook and want to send some mails from a specific account through vba but it simply wont work.

I've tried .sendas , .senderemailaddress but the sender stays as default sender all the time..

Anyone got any idea what Im doing wrong here?

Below is what im currently testing..

For Each oAccount In OutApp.session.accounts                                       
  If oAccount = "xxx" Then
  With OutMail
    .sendas = oAccount
    .TO = Kundmail
    .BCC = ""
    .Subject = "xxx"
    .HTMLBody = Mymessage
   '.display
    .Send
End With
On Error GoTo 0
GoTo Nextone
End If
Next oAccount

 

[Stridhan]

I've allso tried to use .sendusingaccount with both accountnumber and account smtpaddress but still sending with default account..

Anyone?

 

[Excelmasters]

.SentOnBehalfOfName = "Emailadress" will help you.

 

[Stridhan]

Thank you but all I’ve read about behalfof is that it still shows wrong address.