[Solved] Hyperlink e-mail list

Discuss the spreadsheet application
Post Reply
Jorus
Posts: 21
Joined: Sat Jan 03, 2015 1:11 pm

[Solved] Hyperlink e-mail list

Post by Jorus »

Hello,

Is it possible to hyperlink several e-mail addresses at once? I have a large list with e-mail addresses and would be able to click on them. It's to much to link them one by one.

EDIT: Solved by this website. It's for Excel though, but once the addresses are hyperlinked, you can easily copy and paste them to Calc.
Last edited by Jorus on Fri Jul 14, 2017 9:50 pm, edited 1 time in total.
Openoffice 4.1.1 on Windows 7
User avatar
Lupp
Volunteer
Posts: 3542
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

Re: Hyperlink e-mail list

Post by Lupp »

Why weren't the e-mail addresses recognised when entered?

If the e-mail addresses are the only content of the respective cells:
To get a link for the e-mail address contained in cell A2 enter into B2 (or somewhere)

Code: Select all

[code]=HYPERLINK("mailto:"&A2)
[/code]
If not: What else is contained in the cells?
On Windows 10: LibreOffice 24.2 (new numbering) and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
Jorus
Posts: 21
Joined: Sat Jan 03, 2015 1:11 pm

Re: Hyperlink e-mail list

Post by Jorus »

I copy/paste them from excel and then they were recognised as email. But i didnt like it and changed it to standard layout(only know the dutch word). But now i would like it to be clickable again.
Openoffice 4.1.1 on Windows 7
Post Reply