sending emails from access

[megan]

I have a database with clients in it. I want to be able to
click on and email address and automatically open ms
outlook message with the address already in the mailto
box. is there a code to do this?

 

[DL]

Might be better put to one of the 'microsoft.public.access.' newsgroups

 

[Cheryl Fischer]

Megan,

The simplest way to do this is to create a field in a table: for example,
Email_Addr. Its DataType should be Hyperlink.

In your table, as you input email addresses, they should be input as
follows: mailto:[email protected] When you click on that value in
your form or table, it will open Outlook and have the email address in the
To: line.