How do I open email dialog box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

GGerard - 03 Nov 2004 01:09 GMT

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

Reply to this Message

fredg - 03 Nov 2004 05:30 GMT

> Hello
>
[quoted text clipped - 12 lines]
> Thanks
> G.Gerard

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.FollowHyperlink "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:

Signature

Fred
Please only reply to this newsgroup.
I do not reply to personal email.

Reply to this Message