email addresses in a record, click to open email program

[Grahamf]

How do I enter an email address in a record and then be
able to click on it to open Outlook/Outlook Express with
the email address filled in?
Inserting a Hyperlink inserts the same email address in
all records.

 

[Steve Schapel]

Grahamf,

What do you mean by "inserting a Hyperlink"? You can make it a
Hyperlink data type, which is done in design view of your table... but
that surely won't mean you have the same email address in all records.
If you want it to automatically function as an email address, you should
precede it in your data with the email protocol identifier, i.e. mailto:
e.g.
mailto:[email protected]

 

[Guest]

Hi Steve

I have thet same problem as Grahamf. I have a Customer
Database that includes an email address field. I was
hoping to be able to simply click on the email address
for any customer and have Outlook Express open with that
persons address in the To: section. This is what would
happen from Word or Excel if you add an email address to
a document or cell. How do I get the same thing to
happen in Access?

Regards

John

 

[Steve Schapel]

John,

My answer is the same as in my reply to Grahamf. You can make the email
address field a Hyperlink data type, in the design view of your Customer
table. And precede the email address when you enter your data with the
email protocol identifier, i.e. mailto: e.g.
mailto:[email protected]

 

[Jim/Chris]

I got this one from Fred

You do not need to use the hyperlink datatype to send an
email to the address. Use a regular Text DataType instead.

Code the Double-click event of the form control that shows
the field:

Application.FollowHyperlink "Mailto:" & [ControlName]

Making corrections to the text field is much easier than
editing a hyperlink field.

Jim