Hi, I'm very new to excel and was wondering if it's possible to set up an excel code in a way that would send an email to a specific person when a value in a column is marked as completed. For example, if JobX is in A2, and in the same row the project managers initials are in that row, B2, this job gets marked completed in C2, when column C gets marked completed, an email should be sent to the PM whose initials are in that row. I found a code that can send an email when a column's cell gets marked as completed, but was wondering if I can be more specific like sending an email to a specific person when certain conditions are met. Thanks,
- Page :
There are no replies made for this post yet.