Access 2000

[[sarah]]

Does anyone know how to define an email field as a clickable event which then
opens up Outlook Express with the email address you have just clicked
appearing in the To: line?

 

[Al Campagna]

Sarah,

Does anyone know how to define an email field as a clickable event...

Every TextControl has a DoubleClick event. Any code you want to run when
the field is double-clicked should be placed in that event.
Given an Email field on the form named EMail1, the following code will
send an email to the email address contained in Email1. (Don't use the
Click event, as that will send an email every time you just click on the
field)

Private Sub Email1_DblClick(Cancel As Integer)
DoCmd.SendObject , , , Email1
End Sub

The Email will be sent through whatever email program you have as the
default in your Windows environment.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[[sarah]]

Thank you