Send an Email when a Cell Contains the Desired Text

Hi all, TIA for any help.

I have a cell that contains a drop down with two options; Accept or Reject. When Accept is selected, I would like an Outlook email window to pop up ready to send, and the same for Reject. The emails will only contain different text bodies.

Any help is appreciated.

You've not gone into any detail so I've set the Drop Down box as A1

Can you work with this?

Please Login or Register  to view this content.

Thank you for your help.

The cell that contains the dropdown is G4. However, the table will often add new rows, each of which will have the Accept/Reject drop down cell (G5, G6, G7 etc. etc.). So can the code recognise this or will something need to be changed?

Try;

Please Login or Register  to view this content.

This is perfect! Thank you very much for your help.

Am I correct in saying that I can use the Target.Offset(Y, X) to pick out values from the row to then use in the email body?

No worries at all, glad to help.

Yes you can do that,

Please Login or Register  to view this content.

Or I'd do it like this if I'm honest to keep it more "readable";

Please Login or Register  to view this content.

The choice is yours, whatever you feel comfortable with like anything else

Brilliant, cheers!