Hyperlink to text creates http#\\\

[skkorrp]

I have a database that was given to me and all the E-mail records are formatted to Hyperlink by accident i'm sure. I need to convert those records to text to preform a Send object Action. When I change the feilds format to text i get the whole Hyperlink string{ Http\\# } you Know.
I could really use some advice!!

Rodney

 

[Francescina]

The only way to ged rid of this is using the INSTR,MID,LEFT.. string functions.

 

[sathandle]

Use a make table query to generate a new table using the expression of HyperlinkPart Function as outlined in Access's help.
The following post explains how to change the http to e-mail:thread181-13925
See my post at: thread181-256930

Good luck!