modifying the From parameter in an email

[talytech]

Is there a way I can use the Outlook email function in Access to send an email. I would like to change the "From" box. I don't want the email to come from me. In outlook I can manually change who the email is coming from. I want to do that in VBA. Please let me know if this is possible.

[OBP]

I know how to send an email in Access, but not how to change the "From" name.
You could open Outlook from access populate the message and manually change the From name.