How do I open email dialog box

[GGerard]

Hello

I have a datasheet that has one of the columns dedicated to email address.

The hyperlink (of the text box) of that column set to yes so that the text
in the column appears in blue and the cursor turns into a hand when moved on
top of the text.



I would like to be able to click on the text in the column to open the
default email new message window with the email address from the datasheet
already written in the TO box.

I am using Access 2000

Thanks
G.Gerard

[fredg]

Re: How do I open email dialog box

On Wed, 03 Nov 2004 00:09:25 GMT, GGerard wrote:
[color=blue]
> Hello
>
> I have a datasheet that has one of the columns dedicated to email address.
>
> The hyperlink (of the text box) of that column set to yes so that the text
> in the column appears in blue and the cursor turns into a hand when moved on
> top of the text.
>
> I would like to be able to click on the text in the column to open the
> default email new message window with the email address from the datasheet
> already written in the TO box.
>
> I am using Access 2000
>
> Thanks
> G.Gerard[/color]

You are using a form for this (not a table), aren't you (I hope)!

Change that field's datatype from Hyperlink to Text.
Code the form control's Double-Click event:
Application.Fol lowHyperlink "MailTo:" & [ControlName]

Double-click on the control and your default mail program will open,
with the address filled in.

If you were to use a hyperlink datatype you would need to preface each
mail address with
MailTo:
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.