I have a macro tied to a button in a worksheet that spawns e-mail to submit
the sheet as an attachment; but here's what I'd like to do in addition to
that:

- Use the macro to check that all data validation in sheet has been completed.
- Not allow saving of the file if any data validation fields have been left
blank.

Also, I'd like the e-mail submission to include additional info - like a
subject - and I'd like to pre-populate the e-mail address.

I know this a lot, so thanks in advance!