Enter a hyperlink that creates an e-mail message in Form view or Datasheet view

1. Do one of the following:
   • In a Microsoft Access database (.mdb), open the table or query in Datasheet view.
     
     
   • In an Access database or Microsoft Access project (.adp), open the form in Datasheet or Form view.
2. Place the insertion point in the hyperlink field in the datasheet or in the text box or combo box that accepts hyperlinks on the form.
   
   
3. Click Insert Hyperlink on the toolbar.
   
   
4. In the Insert Hyperlink dialog box, click E-mail Address under Link to.
   
   
5. In the Text to display box, type the text that you want displayed in the field or text box. If you leave the box blank, then Microsoft Access will use the e-mail address and subject as the display text.
   
   
6. Click ScreenTip, and type the text that you want to appear when the pointer hovers over the hyperlink. If you leave the ScreenTip box blank, then Microsoft Access will display the e-mail address and subject as the ScreenTip.
   
   
7. In the E-mail address box, type an e-mail address. Or select an address from the Recently used e-mail addresses list.
   
   
8. In the Subject box, type the information that you want to appear in the Subject field of the e-mail message.

   Note   Some Web browsers and e-mail programs might not recognize the subject line.

9. Click OK.

   When you click the hyperlink, Microsoft Access opens your mail program and creates a new message, with the address and subject filled in.