| 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.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:
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
| 
