How to send an email via an Address in an Access2003 field?

[PINTO-malta]

In Access 2003 i have a field in table as Hyperlink so that I could use the
email address inputted in this firld. It works but instead of using the
email outlook, it is using the website by using the end part of the email
address, that is after @. Can anyone tell me how to use the email outlook
via the form field?

 

[Boyd Trimmell aka HiTechCoach via AccessMonster.co]

Are you using mailto: at the start of the email address?:

Like:
mailto:[email protected]

 

[Jean-Paul]

I have the sam problem:

In my table my email-adresses are stored like (e-mail address removed)

I stored it as a txt field...
Now I changed the fields property into "hyperlink"

When I navigate through the different records, the field-content is now
underlined and blue (which is correct)

Now I wrote:

Private Sub mailadres_Click()

SUBJECTBOX = "Mailing 4-parts"
MESSAGEBOX = ""
DoCmd.SendObject , , , "MAILTO:" & Me!mailadres, , , [SUBJECTBOX],
[MESSAGEBOX], -1
End Sub

My mail program opens and in the TO-screen I get:

MAILTO:[email protected]#http://[email protected]#

Which of course isn't correct...

What did I do wrong?

 

[Boyd Trimmell aka HiTechCoach via AccessMonster.co]

I have the sam problem:

In my table my email-adresses are stored like (e-mail address removed)

I stored it as a txt field...
Now I changed the fields property into "hyperlink"

When I navigate through the different records, the field-content is now
underlined and blue (which is correct)

Now I wrote:

Private Sub mailadres_Click()

SUBJECTBOX = "Mailing 4-parts"
MESSAGEBOX = ""
DoCmd.SendObject , , , "MAILTO:" & Me!mailadres, , , [SUBJECTBOX],
[MESSAGEBOX], -1
End Sub

My mail program opens and in the TO-screen I get:

MAILTO:[email protected]#http://[email protected]#

Which of course isn't correct...

What did I do wrong?

Are you using mailto: at the start of the email address?:

[quoted text clipped - 6 lines]

You said: Now I changed the fields property into "hyperlink"

A "field" would mean that you are changing this is the table. This is the
cause. I find it best to store email addresses as a text field. Then your on
click code should work.