Hyperlink

[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

 

[Allen Browne]

Garry, I've found that a Hyperlink is not a good choice for storing email
addresses in Access.

The issue you describe keeps hitting you in the face at every turn, so I
just find it easier to use a Text type field. You can format it in your form
so it looks like a hyperlink (e.g. blue underlined), and use its Click (or
DblClick) event procedure to fire up an email message via SendObject.

Tony Toews has an Access Email FAQ with further suggestions:
http://www.granite.ab.ca/access/email.htm

 

[Garry Jones]

Garry, I've found that a Hyperlink is not a good choice for storing email
addresses in Access.

The issue you describe keeps hitting you in the face at every turn, so I
just find it easier to use a Text type field. You can format it in your form
so it looks like a hyperlink (e.g. blue underlined), and use its Click (or
DblClick) event procedure to fire up an email message via SendObject.

In its simplest form I am not sending anything from Access via email.
Its a contact list and when I click the email address I would just like
to open a blank email window with the email address already inplace.

So using vb code double click I wonder what needs to go in here.

Private Sub email_DblClick(Cancel As Integer)
End Sub

Any help appreciated.

Garry Jones
Sweden

 

[Garry Jones]

You can format it in your form so it looks like a hyperlink (e.g. blue underlined), and use its Click (or DblClick) event procedure to fire up an email message via SendObject.

Thanks for the tip about blue/underlined. I did the rest of it with this
code as I do not understand enough about SendObject, would that have
been for sending data from the database?

Private Sub email_DblClick(Cancel As Integer)
Dim SndEmail As String
SndEmail = "mailto:" & Me.
Application.FollowHyperlink Address:=SndEmail
End Sub

Seems to work....

Garry Jones

 

[Allen Browne]

That's fine.

The idea with SendObject is:
DoCmd.SendObject acSendNoObject,,,Me.Email,,, _
"My subject line", "Here's your email, blah, blah", True

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

You can format it in your form so it looks like a hyperlink (e.g. blue
underlined), and use its Click (or DblClick) event procedure to fire up
an email message via SendObject.

Thanks for the tip about blue/underlined. I did the rest of it with this
code as I do not understand enough about SendObject, would that have
been for sending data from the database?

Private Sub email_DblClick(Cancel As Integer)
Dim SndEmail As String
SndEmail = "mailto:" & Me.
Application.FollowHyperlink Address:=SndEmail
End Sub

Seems to work....

Garry Jones[/QUOTE]