How to enter e-mail addresses on an Access 2003 table?

[Stonehill]

I have a table in Access 2003 which contains details of members of a society.
One of the columns lists their e-mail addresses. How can I use these e-mail
addresses with Outlook Express? If I make the column into a hyperlink column
this does not help because if one cliclks on the address the system only
tries to connect to a web page.

 

[Allen Browne]

Just use a Text field to store the email addresses.

In the lower pane of table design, you can set a Validation Rule on the
field, such as:
Is Null Or Like "*?@?*.?*"

In your form, use SendObject to fire off the email in the DblClick event of
the text box.

More info on approaches to email in Access:
http://www.granite.ab.ca/access/email.htm