Email Specific Cell Values When Cell in Row is Changed to "Yes"

I need to have the attached spreadsheet automatically send an email when a cell in the range is changed to "Yes".

I've been able to get the email to send, but I cannot figure out how to get values from other cells in the row of the changed cell to the email body and subject.

When Column L is changed to "Yes" the email should automatically send to an email with the subject: *Column A Value* "ready to schedule processing training."

Body should include: *Column A Value*", CO:"*Column B Value* "is ready to schedule training for the switch to online processing. Your contact is *Column K Value* and their next processing date is" *Column M Value*.

Please let me know if you need any other information.

Thank you in advance!

You need to pass the row number of the changed cell in from the Change event to the email proc. Then just use it to retrieve the data in the various columns on the same row.
i.e. change this:

Please Login or Register  to view this content.

to something like this:

Please Login or Register  to view this content.

and change this:

Please Login or Register  to view this content.

to something like this:

Please Login or Register  to view this content.

and use that to retrieve your data and construct your message.
MM.

Thank you! Are you able to give me an example of how I would pull this? I'm a little turned around because its not as simple as pulling A1 for example. I have followed your directions thus far.

Try this:

Please Login or Register  to view this content.

MM

I don't know why this line:

Please Login or Register  to view this content.

... is not generating an error for you. xMailBody is a string not an object.

What happens when you step through the code line by line?

This is working for me ...

Please Login or Register  to view this content.

What happens at your end?

You could trigger it using a Worksheet_Change event; test for the cells you want to be complete and, when they are, call the sub.

Sure - no problem. Although this is a closed thread marked complete and a little off topic for your specific question so I suggest you start a new thread if you have questions about event macros.