simple email button

[kpo]

Hello,

I am wanting to add a button to my forms that will send me an email when clicked. A lot of my database users will be not so tech savvy so I am hoping to make asking me a question via email as simple as possible.

Is there a way to have a message box pop up where they can enter their question and send without getting into outlook? Some of our employees don't have/use outlook.

I have searched this forum and others but all those threads deal with attaching forms and other objects which I don't need. I have seen some stuff about an add-in for outlook (I use outlook). Will I need to download that? if so, where can I find it.

Thanks for the help in advance!

[June7]

This thread http://www.tek-tips.com/viewthread.cfm?qid=1311726 has link to an article offering code that will send email regardless of the default email software.

I have not tested.

[Subwind]

How about creating a user request table and form so rather than send you an email, the whole process is based in access.

I would go about it as below.

tblUserRequest

• useRequestID (Autonumber)
• useRequestDate (Date/Time)
• useRequestUser (Text) or (Number) if you have user ID's
• useRequestDetail (Memo)
• useRequestStatus (Yes/No) or (Number) with a second related table list, ie 1 - Open, 2 - Pending, 3 - Completed

Might be worth thinking about. Takes away the need for any emails.

~Matt

[kpo]

Thanks! I will check these out!