Connecting Tech Pros Worldwide Help | Site Map

How do I open email dialog box

  #1  
Old November 13th, 2005, 05:04 AM
GGerard
Guest
 
Posts: n/a
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


  #2  
Old November 13th, 2005, 05:04 AM
fredg
Guest
 
Posts: n/a

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.
Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
Exporting & opening the Save As Dialog Box paquer@gmail.com answers 8 May 4th, 2007 02:35 PM
File Open dialog box charles@home.com answers 5 January 16th, 2007 05:25 PM
Standard Yes / No Windows Dialog box creation flaus.a@wanadoo.fr answers 6 June 22nd, 2006 02:45 AM
download dialog box ACaunter answers 4 November 19th, 2005 01:29 AM