SendMail From specified user

[tstevens]

Is there a function in "SendMail" that allows me to change the sender? Here is my code that I'm using. This will use the account of whoever is logged on and I want it sent from one default account. I'm not familiar with iMail and would perfer to use SendMail unless it's not possible.

Dim name As String
    Dim borrower As String
    name = Range("A87")
    borrower = Range("B13")
    ActiveWorkbook.SendMail _
    Recipients:=name, _
    Subject:="Loan Reconciliation for " + borrower
    ActiveWorkbook.Save
    ActiveWorkbook.Close

 

[Norie]

As far as I'm aware SendMail wouldn't allow you to do anything like that.

It's pretty much restricted to specifying Subject and Recipients.

If you want more control over emailing you'll probably need code that's specific to your email client.

 

[tstevens]

I was afraid of that.
Thanks.