.CSV Email issue

Helix242

Board Regular
Joined
Jun 28, 2016
Messages
76
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:

Code:
=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. :eek:

Can anyone provide assistance as to what may work?

Many thanks in advance.
 

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

stumac

Active Member
Joined
Jul 16, 2010
Messages
471
How about using the Hyperlink function along with 'mailto:':

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

Helix242

Board Regular
Joined
Jun 28, 2016
Messages
76
How about using the Hyperlink function along with 'mailto:':

Code:
=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

Active Member
Joined
Jul 16, 2010
Messages
471
You could try adding in a friendly name -
Code:
=HYPERLINK("mailto:"&E1,E1)
 

Helix242

Board Regular
Joined
Jun 28, 2016
Messages
76
You could try adding in a friendly name -
Code:
=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

Board Regular
Joined
Jun 28, 2016
Messages
76
You could try adding in a friendly name -
Code:
=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
 

Watch MrExcel Video

Forum statistics

Threads
1,099,471
Messages
5,468,814
Members
406,611
Latest member
hanman453

This Week's Hot Topics

Top