E
Ervbo
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?
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?