title: How to change sender name in Outlook ?
body: <p>I am sending an email using <code>Outlook</code> object from a subroutine <code>vba</code>  </p>
  
  <p>The email gets send from my email and the recipients see : <code>myemail@xxx.com</code> . Is there any way I can make those recipients get an email that would have <code>MyfirstName MylastName</code> instead of my email   </p>
  
  <pre><code>Sub Mail_Workbook_1()
  
      Dim OutApp As Object
      Dim OutMail As Object
  
      Set OutApp = CreateObject("Outlook.Application")
      Set OutMail = OutApp.CreateItem(0)
  
      On Error Resume Next
  
      With OutMail
          .From = "MyfirstName MylastName" 'something like this
          .To = "ron@debruin.nl"
          .CC = ""
          .BCC = ""
          .Subject = "This is the Subject line"
          .Body = "Hello World!"
      ....
      Set OutMail = Nothing
      Set OutApp = Nothing
  End Sub
  </code></pre>