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!
Bookmarks