How do set an e-mail link in access to open outlook?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

Creating a database to hold some information about clients. One of the
fields has a text box that asks the user to input the clients e-mail address.
As part of the spec, i need the text box, when clicked on, to open up a
serperate outlook e-mail with the required e-mail that is in the text box to
appear in the e-mail.

Cant seem to achive this, the closes i can get to is the link opens up in
IE, and puts the e-mail in the URL box.

Really Anoying, any ideas guys and gals?

Thanks
 
Hello Daniel.

Daniel said:
Creating a database to hold some information about clients. One of
the fields has a text box that asks the user to input the clients e-mail
address. As part of the spec, i need the text box, when clicked on,
to open up a serperate outlook e-mail with the required e-mail that
is in the text box to appear in the e-mail.
Click to expand...

First, configure Outlook to be the default email handler.
I'd use the DblClick event with an event procedure:

Private Sub txtEmail_DblClick(Cancel As Integer)
On Error Resume Next
Cancel = True ' makes the DblClick a single Click
DoCmd.SendObject ObjectType:=acSendNoObject, To:=txtEmail
End Sub
 
Hi - found this post which matches a query I have BUT having used Wolfgang's
coding when I then double click a new email box opens with the email address
ready but the email won't send - the actual email window does not seem to be
linked to my email account as it were - what does the line 'configure Outlook
to be the default email handler.' mean and how do I do this?? Wil this solve
the problem do you think? Thank you
 
Back
Top