I am using the code below to send an e-mail from excel. When using this code it sends the e-mail from my personal e-mail. I need this e-mail to go out from a group mailbox. Is there anyway to populate the from field? Possibly some other way? Thanks in advance for your help.
Sub Send_Range()
ActiveSheet.Range("I4:I37").Select
ActiveWorkbook.EnvelopeVisible = True
With ActiveSheet.MailEnvelope
.Introduction = ""
.Item.To = "test list"
.Item.Subject = ActiveSheet.Range("I2")
End With
End Sub
Sub Send_Range()
ActiveSheet.Range("I4:I37").Select
ActiveWorkbook.EnvelopeVisible = True
With ActiveSheet.MailEnvelope
.Introduction = ""
.Item.To = "test list"
.Item.Subject = ActiveSheet.Range("I2")
End With
End Sub