Emailing in access 97

D

Dave

I have a table with one column devoted to email
addresses. I currently have it set up as a hyperlink
field with the data being mailto:[email protected].
If you click the link from the table, it works by bringing
up my default email program (outlook) with the email name
in the To list. However, when you click the same link
from a form that populates the email address, it brings up
internet explorer with the following address:
http://[email protected]. The actual page that is
loaded is the somewhere.com page (say it is
[email protected]....it will bring up aol's home page). How
can I get this resolved? Thanks!
 
V

Van T. Dinh

I hardly ever used the Hyperlink Field in Access. I simply store addresses
as Text and then use the FollowHyperlink Method of the Application Object
(adding "mailto:" or "http://" as appropriate for what I need).

See Access VB Help for the FollowHyperlink Method.
 
D

Dave

The information I have autopopulates in the text box from
a query ran though and that seems to open a specefic
address. How, in the code, would I tell it to call
whatever information is in my text box?
 
D

Dave

Was messing around and Application.FollowHyperlink
txtMam, , True works also...thanks for your help!
 
Top