Since the advent of Access 97, it has been possible to store hyperlink data type fields in an Access table. Chances are that you may use a hyperlink field to point to your suppliers' Web addresses, or to a file location on your intranet. However, if you tried to store email addresses in the hyperlink field, you may have run into problems. If you simply enter the email address in a hyperlink field, Access will try to resolve it as a Web address, resulting in the error "Unable to open http://(the email address). Cannot locate the Internet server or proxy server." There is a way to launch your email program and address the email using a hyperlink field. To do so, simply enter the data in the format "mailto:<emailaddress>" (without the quotes or <> characters),  substituting the complete email address that you want to use. Once the data is entered, click on the hyperlink to launch your default email handler (Outlook), and start a new message with the "To:" line already filled in.

Access Index

Main Index