I have a small Excel 2000 workbook with a database of about 2100 records
accessed via dialog boxes. The database is inaccessible to general users
because they tend to screw it up, hence, they interact with the database via
dialog boxes only. There is a main opening Excel sheet that underlies all
dialogs which are accessed via custom main menu options.

I do need User input, however, when they see things that need correcting or
updating. I have an email hyperlink on the Excel sheet and Users can access
it directly or via the following code in a command button click event on the
dialogs.

Sheets("Main").Range("H34").Hyperlinks(1).Follow

Is there any way I can change the subject in the email form that pops up
and, hopefully, add the contents of the particular dialog text boxes the
user is viewing. The user, of course, can change this if they want but
that's okay since they probably won't.. They can add additional message
below, then send.. I'm just trying to make sure I have all the information I
need when they send me an email. Instead of the usual, "Smith's badge number
is wrong."

Thanks in advance for any help you can offer.