.CSV Email issue

[Helix242]

Morning all,

I have a .CSV with contact information and in column E is the email address. The source of the emails (another Workbook) shows them as a none active link - i.e. if you click the email, or hold Alt and click nothing happens. So when these are copied over they are still a none active email and when importing them in to Outlook they are not recognised as an actual email.

I have tried:

=E1&";"

but this does not work. The only think I have found that does work is to click in to the cell with the email and press return, which then makes it an active email link, however there are over 1,000 of them so this just isn't an option.

Can anyone provide assistance as to what may work?

Many thanks in advance.

 

[stumac]

How about using the Hyperlink function along with 'mailto:':

=HYPERLINK("mailto:"&E1)

 

[Helix242]

How about using the Hyperlink function along with 'mailto:':

=HYPERLINK("mailto:"&E1)

Thank you for this. It does create an active email, and then I can copy and Special Paste to keep the hyperlink, however as the email then reads mailto:me@me.com Outlook does not recognise this as an active email.

Is there any way to keep the active email but without the mailto: ?

Thank you

 

[stumac]

You could try adding in a friendly name -

=HYPERLINK("mailto:"&E1,E1)

 

[Helix242]

You could try adding in a friendly name -

=HYPERLINK("mailto:"&E1,E1)

Hi,

Thank you again. When I enter this, it does create an active email. However when re-opening the .CSV file it removed the code and just replaces it with the email address, which is again inactive. I presume this is something to do with saving a .CSV file. Do you know if there is a way to allow the email to remain active when saving the .CSV file?

I thought importing this file to Outlook would be straight forward, but it does not appear to be.

Any help would be appreciated.

Thank you

 

[Helix242]

You could try adding in a friendly name -

=HYPERLINK("mailto:"&E1,E1)

Hi,

Apologies!! The original file works fine. It was the way the email was being mapped when importing the file. By manually mapping the email the issue has now been resolved. Thank you for your help though, it is much appreciated! Every day is a school day!

Many thanks