Through update query "mailto:"&[email] converts all the emails with a prefix
mailto:
However, clicking the field continues to open the web browser, instead of
email programme. Any further suggestions please? Thanks.
-arasu
"Pieter Linden" <pi********@hotmail.com> wrote in message
news:bf**************************@posting.google.c om...
"abcd" <ar****@yahoo.com> wrote in message
news:<40********@news.jcu.edu.au>...
Thanks it works. But I have another problem. I used the field property
as hyperlink and have a field with lots of records I need to change with a
prefix mailto:
Is there any simple procedure to covert all of my data? Thanks again.
-abcd
how about an update query?
update MyTable
Set myfield = "mailto:" & myfield;
or something along those lines...
but make a backup copy of your table before doing this... I wouldn't
want to be wrong and have no back door...