Populate 'From' field when sending email from excel using VBA

[BigDelGooner]

I posted this recently but no-one was able to provide the answer I was after.

Basically I have access to more than one mailbox in outlook and when I send an email from excel using my macro I would like to populate the 'From' field.

I have already written the code to populate the 'Subject' and 'To' fields but cannot seem to find a way to populate 'From'.

Please help!