Thanks Allen. That works splendidly.
I changed it to:
HyperlinkPart([Email_Address],1)
to get rid of the mailto: and the http://
I tried using a text field, but then its not an active link.
I like being able to send the person an email while browsing records.
Of course, now the field header names are Expr1 and Expr2 rather than
Email_Address and Website... but I can live with it.
Thanks again.
James
Allen Browne said:
If you just want the address part of the hyperlink exported, type an
expression like this into the Field row in query design:
HyperlinkPart([MyField], 2)
Alternatively, just use a Text field instead of a hyperlink.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
James Ivey said:
Access Newbie here.
I've got email addresses and website URLs formatted in the form as
hyperlinks.
When I export the data as a text file, the URL and mailto link have a #
sign on either side of them.
How do I export the data without the # signs?