Display underlying hyperlink

M

Mintyman

Hi there,

I have been given a list of email addresses that I need to import into my
database. There is a column called 'Email' which has the value 'Email' in
every cell. When you click on one, it opens a new Outlook email with the
contact's name in it so I know the real address is there. At the moment I
click on the link and copy and paste the email address back into the
spreadsheet but this is far too slow considering the number of rows I have.

I want to be able to display the REAL email address in the field, instead of
a link saying 'Email'.

How can I do this?
 
M

Mintyman

Hi Anne,

Thanks for that. Works a treat :eek:)

However, it's led to a new problem for me to deal with. All my fields now
display the email address but are preceeded by 'mailto:' e.g.

mailto:[email protected]

Do you know how I can strip off the 'mailto' at the start of each field?

Thanks,

Mintyman
 
M

Mintyman

Hi again,

I think i've found a solution. I'm using the 'mid' function and telling it
to count from character 8 onwards. Seems to work ;oP
 
Top