Emailing from Access 2002/Win XP/Outlook Express. 1

[BrianOg]

I have a field in a table (type Hyperlink) in which I store email addresses.
If I click on the textbox with this field as a source, I get an error:

“unable to open

http://johnsmith@yahoo.com

If I define an OnClick handler and put a breakpoint in it, the contents of the text box is:
johnsmith@yahoo.com//http:johnsmith@yahoo.com

I have tried copying the email address from the hyperlink field into a text field with a corresponding textbox txtEmailStr and defining an OnClick event :

Dim strEmail As String
strEmail = "MailTo:" & CStr(Nz(Me.txtEmailStr))
Application.FollowHyperlink strEmail

The Outlook Express window then opens ok, though the form in the background flashes. When I close the OE window, I get an error:

Unable to open

http://johnsmith@yahoo.com

Can anyone suggest how I can simply have a textbox with an email address in it, click on it and open Outlook Express with the email address in the To box and my address in the From box?

 

[PHV]

Have a look at the Application.HyperlinkPart method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886