exporting email addresses

  • Thread starter Thread starter DAC
  • Start date Start date
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
 
The following should work as a calculated field in a query:

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