Compose Email Message

[JamesJ]

Hi. I created a field in my contacts table that I want to display
the email address of the contact but so far I'm not having any
luck. I want the link to open Outlook Express with the email address
in the To: field. The link opens IE to the ip of the recipient.
I'm using Access 2003

Thanks,
James

 

[John Nurick]

Hi James,

If this is a hyperlink field, you need to store the addresses in the
form
mailto:[email protected]
so Windows knows it's an email address and not a web page (if you don't
specify the protocol it interprets
(e-mail address removed)
as
http://[email protected]

Alternatively, store the addresses in a text field (let's call it
EmailAddress), and use a VBA statement like this
Application.FollowHyperlink Me.EmailAddress
to create a new message in the default email client.

 

[JamesJ]

The field is a Hyperlink. When I use the mailto:[email protected]
Internet Explore says:
Could not perform this operation because the default mail
client isn't installed properly installed.
There must be some setting in Outlook Express??
When I try Application.FollowHyperlink Me.EmailAddress
in the On Click of the field I get a syntax error or a data member
not found.
One more thing. How do I edit the email address in the field
once I insert the address?

Thanks,
James

 

[JamesJ]

The hyperlink to email works fine now, it was a setting
in internet options programs tab.
I still would like to figure out how to edit the email
address if possible.

Thanks,
James

 

[John Nurick]

Use F2, or the Edit|Hyperlink menu command, or maybe right-click and
select Edit Hyperlink.

The hyperlink to email works fine now, it was a setting
in internet options programs tab.
I still would like to figure out how to edit the email
address if possible.

Thanks,
James

 

[JamesJ]

Thanks, the right click worked fine. I had the shortcut
menu for the form set to no.

Thanks again,

James

Use F2, or the Edit|Hyperlink menu command, or maybe right-click and
select Edit Hyperlink.