exporting email addresses

D

DAC

I have an email address field (live) that I need to export into a text
format for use with a broadcast email utility. The Access email format is
#mailto:[email protected]

Question is, how can I strip out the #mailto: so the text file ends up with
only the email address?

Thanks for any help

Doug
 
C

Cheryl Fischer

The following should work as a calculated field in a query:

Mid(,9,Len([email])-9)
 

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

Have 4 email addresses Want to auto forward all in one of them 0
Synchronization problems while moving folders to new email 1
Can't send emails on new PC 1
Chase Emails (Non Responses) 0
VBA Export to PDF 0
Solved Disk Full error message when exporting PDF 0
VBA - exporting serial letters to single documents 0
Images are pixelated when saving to PDF 0

Top