I want to create and send an email from Excel but I want replies to go to a different account to the default Outlook mail account. The following code works perfectly if I do set the Object Library

Please Login or Register  to view this content.
However, I cannot set the Microsoft Outlook object library in the "Tools" "References" as some of my users have different versions of Outlook running.

So I have developed this way instead

Please Login or Register  to view this content.
The second vesrion appears to work perfectly but when I actually send the email it goes from the Default account rather than the SentOnBehalfOfName account

Any help would be much appreciated