Hi I have a database of about 10,000 names and email addresses. I am not sure why, but the hyperlinks don't address correctly. In other words, if the field value is jdoe@access.com and I click on it I want it to open outlook. The existing ones don't. Instead it will open the browser to http://jdoe@dehar.com/ and ultimately arrive at "Page Not Found".

Were these email address hyperlinks not properly set up- and if so can they be fixed?

Thanks

What you need is a mailtto link rather than what you have.

Yes and if I go into each one ("edit hyperlink") I can change it and make that particular one work.
I am wondering if there is a way to change all 10K?

Sure, run an UPDATE query:

UPDATE table SET field = "mailto:" & field