- Sep 1, 2006
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