Thread: Populating FROM field in Outlook from Excel

Hi,

First time poster. I have a little application that send an e-mail from the users account to a specified e-mail address (lots of help on the forums on To and Body etc). This has all been very easy, until it was requested to have the "From" field populated. The department wants the replies to go to a central address. Current code, but it falls over at .From.

Sub SimpleMail()

    
    Set olApp = CreateObject("Outlook.application")

    Set m = olApp.CreateItem(olMailItem)
    
     
    
    With m

        .Subject = Sheets("Master").[H4].Value

        .To = "email1@domain.com"

        .Body = ActiveSheet.Range("C7").Text & vbCrLft
        
        .From = "email3@domain.com"

        .Send
        

    End With

End Sub

Try:

.SentOnBehalfOfName = "email3@domain.com"

Dom