Send email from excel BUT need to populate 'From' field in email

[BigDelGooner]

Hi there I have posted this question a couple of times but no-one has been able to answer. Even if someone could confirm this cannot be done I would be very grateful!

I was wondering if there was a way to fill in the 'from' field as there is with the 'to' field when sending an email from excel vba.

Basically something like

ActiveWorkbook.SendMail
Recipients:="helpmeplease@stuck.com"
From:="MySharedMailbox"

Ideas anyone?

 

[Andrew Poulsom]

Maybe this will help you:

http://support.microsoft.com/kb/232309

 

[BigDelGooner]

That is very helpful, thank you so much!!!