Text field contains email address

[Guest]

I am using Access 2003 to create a specialized Contact Manager for ads that
we do at differenent times of the year. One of the fields contains the email
address for the contact that we are dealing with. Is there a way set the
field up so when you double click on it, Outlook will start up with the email
address in "To" and preset text in the subject area? Any help would be very
much appreciated.

 

[Steve Schapel]

H Godwin,

You could try code like this on the Dbl Click event...
DoCmd.SendObject , , , Me.Email, , , "Your Subject Text", , True
(replace Email with the name of your email address textbox)

 

[Guest]

Thank you - this worked great.
Is there a similar command to do the same thing if you had the url address
for a website in a text field and wanted to double click on it?
I really appreciate your assistance.

 

[Steve Schapel]

H Godwin,

One way to do this is go to the design of the table, and set this field
as a Hyperlink data type.