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.
[Solved] Hyperlink e-mail list
[Solved] Hyperlink e-mail list
Last edited by Jorus on Fri Jul 14, 2017 9:50 pm, edited 1 time in total.
Openoffice 4.1.1 on Windows 7
Re: Hyperlink e-mail list
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]
If not: What else is contained in the cells?
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)
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
---
Lupp from München
Re: Hyperlink e-mail list
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