Send Email from Access changing email address in From to be different than sending address

[tomlebold]

I have an Access form that sends an email to the email address in a
text box on the form.
Would like the From in the email received to be different than who sent
it.
The SentOnBehalfOfName properties results in System Administrator
invalid email address.

Dim objOutlook As Outlook.Application

Dim objOutlookMsg As Outlook.MailItem
Dim objOutlookRecip As Outlook.Recipient
Dim objOutlookAttach As Outlook.Attachment

' Create the Outlook session.
Set objOutlook = CreateObject("Outlook.Application")

' Create the message.
Set objOutlookMsg = objOutlook.CreateItem(olMailItem)

objOutlookMsg.To = Me.EmailAddress
objOutlookMsg.Body = Me.Comments

objOutlookMsg.SentOnBehalfOfName = "(e-mail address removed)"

objOutlookMsg.Send
<