How to properly store e-mail addresses in Access table

G

Guest

I have an Access form that stores e-mail adresses into a table. They are
stored as Text rather than an email hyperlink. For example, when I export
them into Excel, they all come in as text (i.e., '(e-mail address removed)). Notice
the " ' " that makes it a text field. Is there a way to set the field format
with something like "mailto:" preceding the e-mail addresses so that either
in Access or when I export them to Excel, they are legitimate, clickable
e-mail addresses & not text fields?
 
G

Geof Wyght

How about writing a query like this:
Select 'mailto:' & emailaddress AS CompleteLink from ...
Then you'll be exporting something that looks like:
mailto:[email protected]
Geof Wyght.
-----Original Message-----
I have an Access form that stores e-mail adresses into a table. They are
stored as Text rather than an email hyperlink. For example, when I export
them into Excel, they all come in as text
Click to expand...
(i.e., '(e-mail address removed)). Notice
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

store urdu in ms access 1
One field, multiple e-mail addresses - mail merge? 12
Storing E-Mail Addresses in Access Tables 0
E-Mail Addresses 0
Export Access 2007 reports/queries to Word 2007 documents 1
storing e-mail addresses in table 1
Importing E-mail Addresses to Microsoft Outlook '03 1
how to get e-mail addresses from messages 1

Top