Send Email to X if Target Cell equals Y

[BGL]

Good Afternoon,

My expertise of VBA is still intermediate so any help concerning this matter is much appreciated.

I have created a VBA Script (As per Below) to send an email to an individual recipient however I'm finding it difficult to ascertain the means to send an email to a particular user depending on the data in a given cell.

For instance if Target.Cell.Offset (0,-2).value = A then an email needs to be send to [email protected]

There are 8 alternative variables, each of which given an alternative email address.

Please see the below script.

Please could someone provide me with a solution to this problem.

Thank you in advance.

Please Login or Register  to view this content.

[joris moerings]

Hi,

I don't have a full incorporated solution but have a look at this. perhaps it will help you in the right direction.

Please Login or Register  to view this content.