prompt help message prompt where user can input e-mail text

[CV899000]

Hi,

I have a document that several users are going to use.

I have a sheet called "Information" that I uses as a form of homepage.
I have a commandbutton called "Help" in this sheet.

Is it possible to prompt a message box that functions as seen on some homepages where the user is asked to input:
Reason:
"User writes text into this box"
Description:
"User enters text into this box"

and then have a button that says "Send e-mail" which then sends an e-mail to my e-mail address from the user stating the "Reason" as the Subject in outlook and the "Description" as the actual e-mail text?

and a button called "Cancel" or something similar if the user hit the help button by mistake?

 

[FormR]

Hi, you could create a small userform with the two text boxes and command buttons, and use some code to generate and send the email.

This link might help to get you started with the userform:

• Userform Tutorial

This link might help you get started with the email:

Mail a small message