email field in access

[Guest]

How do I set up an EMAIL FIELD so when I click on it , it opens up my Outlook
new message box and inserts the actual email address from the record that I
cliked on.

 

[Guest]

Create a field (format hyperlink) in the clients table (or where ever) and
add the email addresses in to this field.

Note the email address must start
MailTo:
Like
MailTo:[email protected]

On the form click the hyperlink field and outlook shoud open will the
address in the right place

Hope this helps

 

[Guest]

In the table, put the e-mail addresses in a text field.
In the form, enter design mode and go to the text box that shows the e-mail
address. In the text box's property sheet add an Event Procedure to the On
Click event with the following code:

Private Sub E_Mail_Click()

DoCmd.SendObject acSendNoObject, , , [E-Mail]

End Sub

E-Mail is the name of my e-mail field, if yours is different, you need to
use that instead of "E-Mail".

That'll open a new message in your default e-mail client with the e-mail
address in the To field.