How to store email addresses in an Access table

E

Ervbo

I have an Access form that stores user e-mail addresses into a table. Is
there a way to set the Data Type and Format so the addresses are strored as
Email and not just Text? 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 rather than a clickable e-mail link. Is there a way to set the
field format with something like "mailto:" preceding the e-mail addresses so
when I export them to Excel, they come in as e-mail addresses?
 

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

How to properly store e-mail addresses in Access table 1
Can not export e-mail addresses from Access to Excel 0
Can not export e-mails from Access to Excel 0
Can not export emails from Access to Excel 0
One field, multiple e-mail addresses - mail merge? 6
VBA - exporting serial letters to single documents 0
Email notifications without opening application 1
store urdu in ms access 1

Top