Edit Multiple Hyperlinks

[Guest]

I have entered my e-mail addresses (About 1600) into my DB, using the
"Hyperlink" datatype. Now all the e-mails come up as web page hyperlinks
rather than e-mail. I tried changing the datatype to text, this didn't work.
I can edit each hyperlink individually changing it from a webpage to e-mail,
then copying the e-mail address into the mail to box, but this will take me
forever!!! Anyone have a fast easy way to change them all at once?

 

[Kevin K. Sullivan]

Use an update query.

I'd recommend adding a new, blank Hyperlink field, NewEmail, so you
don't muck up your old field.

Use an update query something like (untested air SQL):

UPDATE Contacts SET [NewEmail] = & "#mailto:" & [Email] & "#";