Hello Everyone.

Currently want to build a VBA function that enables people to send emails using a group email address(e.g. person A has an email address [email protected] and he is also a member of "student" group and has access to send emails using the groups email address [email protected])

As of now they have to change the From Email address manually searching through many group email address which they usually make mistakes.

I want to automate this by creating a VBA Macro. If the user gets an email from company which has email address ending "@Adidasa.com" I would like the VBA Macro to automatically change the FROM Email address to "[email protected]"

Currently i have following code which I have found from other sites and a few update from my end. Can anyone help me out with the below and make it working. I am stuck and cannot think of anything else.

Please Login or Register  to view this content.