I would like to be able to send an email out from Excel VBA and control who the email is sent from - so that when a reply is sent it will go to that specified person.

Thanks in advance.