Thanks again jasotastic81 - Your coding works like a charm and I have a very happy internal customer who love their new form!

Gosh, jasotastic81, let me say sarcastically that I sort of hate you for answering this question... now I gotta at least try to make it work instead of telling them to just stick with their Excel spreadsheet version! :-)But seriously, thank you, and apologies for the late thanks (but lucky me I've b...

Thank you so much. Perfect. And thank you for the brilliant way you presented the answer - nice and easy to follow for a newbie like me and most importantly helps me understand WHY we are doing things that way.

Thank you - works great for most times I'd want to use it.Problem is, for one particular form I'm working on, I have two submit buttons, and when I use the script, even though I set it on the 2nd email button, users still get the message when they click the 1st email button (which is in a separate s...