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

  • Thread starter Thread starter PINTO-malta
  • Start date Start date
P

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?
 
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?
 
Back
Top