Email addresses in access?

[Garry Jones]

I am importing an address register from Excel to Access 2003. I have a
list of email addresses and links in the Excel file. When I go into
table design I can tell Access that it is a "hyperlink" but I can not
specify "email". I chose hyperlink anyway and it is trying to open
http://[email protected]

How do I get access to treat email addresses as email addresses. The
fact that I am importing has little to do with this question. I have
seen a function in formular design so I know that I can edit each link
one by one but I do not want to do this.

Thanks for any help....

Garry Jones
Sweden

 

[John Vinson]

I am importing an address register from Excel to Access 2003. I have a
list of email addresses and links in the Excel file. When I go into
table design I can tell Access that it is a "hyperlink" but I can not
specify "email". I chose hyperlink anyway and it is trying to open
http://[email protected]

Run an Update query updating the hyperlink field to

Replace([fieldname], "http://", "mailto:")

John W. Vinson[MVP]

 

[Garry Jones]

I am importing an address register from Excel to Access 2003. I have a
list of email addresses and links in the Excel file. When I go into
table design I can tell Access that it is a "hyperlink" but I can not
specify "email". I chose hyperlink anyway and it is trying to open
http://[email protected]

Run an Update query updating the hyperlink field to

Replace([fieldname], "http://", "mailto:")

Yes, I can even do that from "search and replace" of course for existing
data. However, I did not give enough information in my initial question.
The purpose of this database is to allow users to enter additional
information through a form(ula)?. Is there a way of just having a field
that will be recognised as an email and be automatically linked as an
email? (as when entering data in ms word document).

? Sorry, I am unsure if it is called "formular" or "form" in English.
(On Swedish Office).

Thanks for your answer.

Garry Jones
Sweden

 

[Arvin Meyer [MVP]]

Yes you can set the property as email by right-clicking on the textbox
(assuming the underlying field is a hyperlink) choosing edit, then choosing
the mailto: protocol. I prefer to not use a hyperlink and just use a regular
text field instead, then I can index and search it as well as keep a smaller
footprint for the data. You can still use it to mail by coding the textbox.
Here's an example using the double-click event:

Private Sub txtEmail_DblClick(Cancel As Integer)
Dim strMail As String

strMail = "#MailTo:" & Me.txtEmail & "#"
Application.FollowHyperlink HyperlinkPart(strMail, acAddress)

End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

I am importing an address register from Excel to Access 2003. I have a
list of email addresses and links in the Excel file. When I go into
table design I can tell Access that it is a "hyperlink" but I can not
specify "email". I chose hyperlink anyway and it is trying to open
http://[email protected]

Run an Update query updating the hyperlink field to

Replace([fieldname], "http://", "mailto:")

Yes, I can even do that from "search and replace" of course for existing
data. However, I did not give enough information in my initial question.
The purpose of this database is to allow users to enter additional
information through a form(ula)?. Is there a way of just having a field
that will be recognised as an email and be automatically linked as an
email? (as when entering data in ms word document).

? Sorry, I am unsure if it is called "formular" or "form" in English.
(On Swedish Office).

Thanks for your answer.

Garry Jones
Sweden