Cheers Kiwiman!
The code works but I also had to remove the "mailto:" so I modified the code as follows:
'Get everything after first :
Email = mid(Me!Email,InStr(1, Me!Email, ":")+1)
'Remove the last #
Email = left(Email,InStr(1, Email, "#")-1)Should I be saving emails as Hyperlinks or just...