title: vba - sending email from a different user
body: <p>My client wants to distribute excel/vba to his clients and the vba will automatically send emails. </p>
  
  <p>Maybe the sender should be some other account, not the outlook account of the person using the vba, because some private stuff might be in the email. Is it really possible? </p>
  
  <p>Another thing is the infamous pop-up warning when automating such tasks. I heard Application.SendKeys doesn't always work when computer's locked. </p>
  
  <p>How is CDO for this task? </p>