email addresses

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

Guest

I have a field called email in one of my tables/forms - i want to enter the email address as normal but once it is added i want to be able to click on it an launch into a new email message

Is this possible

Thanks in advance
 
I got this from aprevious post from Fred. I use often.

You do not need to use the hyperlink datatype to send an
email to the address. Use a regular Text DataType instead.

Code the Double-click event of the form control that shows
the field:

Application.FollowHyperlink "Mailto:" & [ControlName]

Making corrections to the text field is much easier than
editing a hyperlink field.

Jim
-----Original Message-----
I have a field called email in one of my tables/forms - i
Click to expand...
want to enter the email address as normal but once it is
added i want to be able to click on it an launch into a new
email message.
 
thank you very much for replying - please forgive me if this enquiry sounds basic but I am a new user to access and trying to learn as I build. This is what I have done

highlighted email field in form design view - opened properties, selected event tab and typed the line you have given me in the "on dbl click" box - is this right? I don't seem to be able to get it to work. I also have the "hyerlink" option set to yes

Thanks in advanc


----- Jim/Chris wrote: ----

I got this from aprevious post from Fred. I use often

You do not need to use the hyperlink datatype to send a
email to the address. Use a regular Text DataType instead

Code the Double-click event of the form control that show
the field

Application.FollowHyperlink "Mailto:" & [ControlName]

Making corrections to the text field is much easier tha
editing a hyperlink field

Ji
-----Original Message----
I have a field called email in one of my tables/forms -
Click to expand...
want to enter the email address as normal but once it i
added i want to be able to click on it an launch into a ne
email message
 
highlighted email field in form design view - opened properties, selected event tab and typed the line you have given me in the "on dbl click" box - is this right?
Click to expand...

close but not quite.

Instead, clear the On Dbl Click line; click the ... icon by it, and
select "Code Builder". Put the suggested code between the Sub and End
Sub lines that Access will give you.
 
Back
Top