I have a working VBA script, but I require it to do more than it currently does. This script is based on criteria in column G as a trigger ("Yes" is required) and a name is required in Column F for any corresponding Yes in column G. My sample shows Yes in 3 rows (2, 9, and 13), however the way this macro is currently working it sends 2 seperate emails (to the same address hard coded in the VBA) rather than listing all info in one like I would prefer. In addition, I would like to ensure that any variation of "yes" will still cause this trigger, this is NOT case sensative, and there are all different end users that will fill this out. Also for instances like row 13 where Yes is listed in Column G but there is NOT a name listed in column F to correspond, I would like a message box to appear giving the user the option to add the name or send the emails (message box: "The DM is a required field for any new clients. Would you like to add the DM now or send the other updates now? Add DM / Send Now" (obviously if a row number could be referenced for this that would be great, but not a requirement"
Column G = Yes
AND
Column F = NOT blank
Also there is a pop-up message that appear when I attempt to send a message using this current macro. I want to avoid having this message appear, as I have no control over the end users. I am attaching a sample file which contains my existing working macro that simply requires an "upgrade" and also a screen shot of that pop-up message that I want to avoid seeing, or having my users see. Thanks in advance for all your help it is greatly appreciated!