Access 2000 Email field format

[Guest]

I have an .mdb of names, addresses and email addresses that I want to be able
to create an online web directory.

I have set the format of the email field as a hyperlink, but when I create a
report and export it - the email address shows incorrectly - as a website
link and not as a email address.

It shows up as http://[email protected]
and I want it to be mailto:[email protected]

How/where do I do this?

Thanks

Frank in Spokane

 

[Guest]

There is a difference between a hyperlink and an e mail address.

To use the click to send an e mail (opens outlook on most d bases) you need
to store the data as a mailto.

mailto:[email protected]

Hope this helps

 

[Guest]

Do you mean that when I enter any new email addy I have to add the mailto: in
front of the regular addy?

 

[Guest]

I changed one record - added the mailto: to the beginning of an existing
email address in the email field, and the report generated worked correctly,
in that someone can click on the email address in the online report and send
the person email.
Would you have a suggestion as to how I can change the other 3000+ records I
have in my .mdb now?
Logic would be in the email field - add mailto: to the beginning of the
existing email addy

Thanks

 

[Guest]

Yes - you can do it in VBA or by an update query. In the query "update to"
field specify an expression "Mailto: " & emailfieldname.