Make sure the link is formatted as MailTo:person@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" <timothy_chadwick@hotmail.com> wrote in message
news:b386c42a.0402190503.27264442@posting.google.c om...[color=blue]
> 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.[/color]
