Can not export emails from Access to Excel

E

Ervbo

I have an Access form that stores e-mails into a table. They are stored as
text as their does not seem to be a way to store them as emaal addreses).
Anyway, 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 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

Top