I did it!!! I cant believe it!!!!
I was trying to fix the problem of the hyperlink issue, changing it from http:// to mailto: if you want to send email by outlook do the following:
1. Temporarily change the datatype of your field to TEXT
2. Run the following update statement (changing the table name and field
name appropriately):
UPDATE HyperLinks SET HyperLinks.EmailAddress = "#Mailto:" &
Mid([EmailAddress],9);
3. Change the datatype of y our field back to Hyperlink.
I did it and worked!!!
Hope this can help anyone stuck in this problem!!!
Best Regards,
Suzan