I am trying to have each individual worksheet in my workbook able to be sent via email when selecting the "Submit" button at the top of each sheet. I have the code written to where the email works fine. However, I have added other bits of code to where the system checks for missing information and requires the user to send before submitting. That portion of the code works excellently. The problem I'm now running into is that when the user completes all the required cells and hits submit the email does not get sent.

Also, is it possible to reference multiple cells in a message box that do not have information? For example, if the user did not fill out cells H5, H9, and H30 could the message box list all of those cells in one message? Currently I have it set up to where only the first cell in the column is flagged and the rest are highlighted but no prompt is given.

Please Login or Register  to view this content.