Email Hyperlink

D

DD

I have a hyperlink field in a table. On the user form I
want the user to be able to click the hyperlink and have
Outlook open a new email with that address in it. I posted
yesterday and got a response that in the field it should
say MailTo:[email protected]. This works great, thank
you. Now I want to prevent the user from entering MailTo
preceeding the email address. I tried to set an input mask
but the link just does not work. Thanks in advance for
your help. These newsgroups have never failed me :)
 
W

Wayne Morgan

In the AfterUpdate event of the control bound to the email field try
something like:

If Left(Me.txtEmail, 7) <> "MailTo:" And Nz(Me.txtEmail, "") <> "" Then
Me.txtEmail = "MailTo:" & Me.txtEmail
End If
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Blocking junk email 0
Outlook - Catgorizing emails by names 0
Have 4 email addresses Want to auto forward all in one of them 0
hyperlink field to send email 6
Hyperlink Issues 0
Validation of e-mail entries in a hyperlink field, Access 2003 4
mail merge 1
Synchronization problems while moving folders to new email 1

Top