I have code where VBA will attach files and send e-mail to users. But all emails are going through my E-mail ID. i need help to know on how can i change the From address before sending email? Below is my existing code.
Dim olApp As Object Dim olMail As Object Dim olRecip As Object Dim olAtmt As Object Dim iRow As Long Dim Recip As String Dim Subject As String Dim Atmt As String Dim sMsgBody As String
iRow = 2
Set olApp = CreateObject("Outlook.Application")
Dim Sht As Worksheet Set Sht = ThisWorkbook.Worksheets("Sheet1")