Stupid question regarding linking Outlook with Access

[Guest]

I have a customer database and filed Email_address where i store customer
email as a hyperlink. I would like to click on hyperlink and Outlook should
open selecting customer email in To: field in Outlook. Outlook is set as
default email program but when I placed code on DblClick:
Application.FollowHyperlink "mailto:" & Me.Email_Address my yahoo home page
is opening insted. Thanks

 

[JK]

Greg,

Use DoCmd.SendObject and put the e-mail address in the [To]

Regards/JK

 

[Van T. Dinh]

Application.FollowHyperlink "mailto:" & ...

works fine (opeing a new email msg prefilled with given address) on my
work-station (Windows XP / Office XP).

Go to Control Panel / Internet Options / Porams tab and make sure Ooutlook
is the default E-mail program.

 

[Ron2006]

I also get the proper/same results as Van.

Ron

 

[Guest]

I also get the proper/same results as Van.

Ron

Thanks for all your replies, but i't still not working. I put the following
code in Dbl Click: Application.FollowHyperlink "mailto:" & Me.Email_Address
the I created procedure:
Private Sub Email_Address_DblClick(Cancel As Integer)

On Error GoTo ProcError

Application.FollowHyperlink "mailto:" & Me.Email_Address

ExitProc:
Exit Sub
ProcError:
MsgBox "Error " & Err.Number & ": " & Err.Description, _
vbCritical, "Error in procedure Email_Address_DblClick..."
Resume ExitProc

End Sub


If I double click on email hyperlink my yahoo home page is opening. I use
Firefox as default browser and even if I change to explorer same page opens
in explorer browser. Outlook is configured as default email from Control
panel\Internet Options\Programs and it is set as default in
outlook\tools\options\other