Access XP and email hyperlinks detected as website links

  • Thread starter Thread starter SEFL
  • Start date Start date
S

SEFL

Hi there,

I've got a database I'm trying to fix up. I changed the email field
from a text field to a hyperlink field.

The problem is that every time I enter information into the email
field, it thinks that the email address is a webpage (the same thing
goes for the existing information). Since there's about 2500 records
containing email addresses, is there an easy way to convert them all to
email hyperlinks?

I can do an update query or something similar if there is such an
animal.

Thanks.



Adam
http://www.searchenginefriendlylayouts.com
 
Hi Adam,

My recommendation is to change this field back to a text field. It will be a
lot easier to edit the e-mail address in the future, without a hyperlink
attempting to activate. Add a small command button next to this text field,
with an e-mail picture, to allow the user to click the button to send a
message. Name the command button cmdSendEmail. Add the following code for the
On Click event procedure:


Private Sub cmdSendEmail_Click()
On Error GoTo ProcError

DoCmd.SendObject To:=Nz(Me.txtEmail, "")

ExitProc:
Exit Sub
ProcError:
MsgBox "Error " & Err.Number & ": " & Err.Description, _
vbCritical, "Error in procedure cmdSendEmail_Click..."
Resume ExitProc

End Sub


You can also provide other parameters, such as CC, BCC, Subject and text of
the message body. See the VBA help for SendObject.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
 
Back
Top