UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Email addresses and hyperlinks    
 
   
snyperj
post Nov 19 2004, 12:48 PM
Post #1

UtterAccess Veteran
Posts: 345
From: New England
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
Go to the top of the page
 
+
ScottGem
post Nov 19 2004, 01:19 PM
Post #2

UtterAccess VIP / UA Clown
Posts: 25,075
From: LI, NY
What you need is a mailtto link rather than what you have.
Go to the top of the page
 
+
snyperj
post Nov 19 2004, 01:22 PM
Post #3

UtterAccess Veteran
Posts: 345
From: New England
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?
Go to the top of the page
 
+
ScottGem
post Nov 19 2004, 01:56 PM
Post #4

UtterAccess VIP / UA Clown
Posts: 25,075
From: LI, NY
Sure, run an UPDATE query:

UPDATE table SET field = "mailto:" & field
Go to the top of the page
 
+
« Next Oldest · Access Q and A · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 22nd May 2013 - 09:34 AM