I've been working on a project for buyers to get data using a userform. If the data they want isn't there they can send a request to me via email to get the data entered.
In the sendmail sub I used
sUserName = Environ("UserName") & "@company.com"
and it worked while I was testing it...