I am working on a database in Access 97 where I have 2 fields for email addresses.  Is there a way to make it so that when you double click the field, it opens a mailto: with the specified email address in the TO: field of the message?

I have tried by means of a macro using runapp "mailto:" just to see if it would bring up the new message window, but that won't work.

I have also tried a macro using sendkeys to open the Run box and type in the mailto: command, but that had the same effect, it wouldn't work.

Anybody have any ideas?

Many thanks for any help you might be able to offer.  

~Brock~

Hi, the easiest method i found was:
create a form with fields for the to, subject, message, etc.
use the SendMail method in access to send the email. that way you control the list of people it goes to, graphix, etc.
i think it's DoCmd.SendMail (although, that may be obsolete now in 2k, however it's probably Application.Docmd.SendMail, or something)
Double_Clic is trapped by your form:
ie.
public sub MyEmailAddressLabel_DblClick
  dim frm as new mymailform
  frm.to = me.mymailaddresslabel.caption
  frm.from = currentuser()
  frm.show vbmodal
  set frm=nothing
end sub

____________________________
Build it better, faster, quicker, easier.. then fix it (non-offical MS mission statement)