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.

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.

Hi Ron,

What I'd like to do is this:
When the user has pulled up a record in a dialog box and sees incorrect
information on it or has an update or note they'd like to add to the record,
they could click a command button that connects to an email link. This link
opens their email program and puts the email form on the screen. The To:
address is mine. I'd like to be able to change the subject to the particular
person whose record they are currently viewing. And, in the message area of
the email form, I'd like to put information from the current record text and
label boxes. This way I'd have a positive match on which record they are
referring to and they'd have an on-screen reminder of the particular fields
information is in. The user can add any comments in the message section
below the dialog box info.

When I receive the email, I can go into the administrator mode of the .xls
program and edit the particular record the email refers to if that's what's
required.

I prefer this way over copying the information to a temp email sheet and
mailing the entire workbook. One reason I dislike this method is because,
even though most of the database users use computers everyday, this method
tends to confuse them and secondly, it's kind of a pain in the neck on my
end when I receive the emailed sheet.

I need to make this as painless as possible for my users. They're all
lawyers and paralegals whose computer experience is primarily email, the web
and word processing programs. Painless for them means painless for me in
fewer phone calls for help and fewer instruction sessions.

Thanks for you interest. I appreciate any help you can offer.


"Ron de Bruin" wrote in message
...
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.

Hi Jim

Start here
http://www.rondebruin.nl/sendmail.htm

If you use Outlook then see the Body Examples
Try the test workbook

If not you can try
http://www.rondebruin.nl/mail/oebody.htm


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



"Jim" wrote in message om...
Hi Ron,

What I'd like to do is this:
When the user has pulled up a record in a dialog box and sees incorrect information on it or has an update or note they'd like to
add to the record, they could click a command button that connects to an email link. This link opens their email program and puts
the email form on the screen. The To: address is mine. I'd like to be able to change the subject to the particular person whose
record they are currently viewing. And, in the message area of the email form, I'd like to put information from the current record
text and label boxes. This way I'd have a positive match on which record they are referring to and they'd have an on-screen
reminder of the particular fields information is in. The user can add any comments in the message section below the dialog box
info.

When I receive the email, I can go into the administrator mode of the .xls program and edit the particular record the email refers
to if that's what's required.

I prefer this way over copying the information to a temp email sheet and mailing the entire workbook. One reason I dislike this
method is because, even though most of the database users use computers everyday, this method tends to confuse them and secondly,
it's kind of a pain in the neck on my end when I receive the emailed sheet.

I need to make this as painless as possible for my users. They're all lawyers and paralegals whose computer experience is
primarily email, the web and word processing programs. Painless for them means painless for me in fewer phone calls for help and
fewer instruction sessions.

Thanks for you interest. I appreciate any help you can offer.


"Ron de Bruin" wrote in message ...
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.