Hi Jim

I think I need more info to understand what you really want

But you can look on my site for creating a mail with body and...........
http://www.rondebruin.nl/sendmail.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Jim" wrote in message . net...
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.