Sending an email from Access

[Tim]

I have a field on a form in which the user can type an email address.
I would like to be able to double-click the field and it will open a
blank email to that address.

If you set it as a Hyperlink, it thinks it is a web address and tries
to open a web page.

Does anyone know some VBA that would enable this? I'm guessing it
would take the value from the field/record and pass it to a some kind
of SendEmail method that opens the default email program and inserts
the value as the "to" address.
Alternatively a command button could do it. I've found how to set up a
command button that will open a blank email to a predetermined
address. Is there a way of dynamically (runtime) updating that address
if the value in a field is changed (ie. the user changes the email
address)?

I am using Access 2000 on Windows 2000 and my email client is Lotus
Notes.

[Mike Storr]

Make sure the link is formatted as MailTo:pe****@address.ext?Subject=, Body=
etc.
You can create this string in code and apply it to the Hyperlink Address
property.

Mike Storr
www.veraccess.com
"Tim" <ti**************@hotmail.com> wrote in message
news:b3**************************@posting.google.c om...

I have a field on a form in which the user can type an email address.
I would like to be able to double-click the field and it will open a
blank email to that address.

If you set it as a Hyperlink, it thinks it is a web address and tries
to open a web page.

Does anyone know some VBA that would enable this? I'm guessing it
would take the value from the field/record and pass it to a some kind
of SendEmail method that opens the default email program and inserts
the value as the "to" address.
Alternatively a command button could do it. I've found how to set up a
command button that will open a blank email to a predetermined
address. Is there a way of dynamically (runtime) updating that address
if the value in a field is changed (ie. the user changes the email
address)?

I am using Access 2000 on Windows 2000 and my email client is Lotus
Notes.