Forum Discussion
Kenneth Rushton
Nov 24, 2017Copper Contributor
automatic e-mail composition
I have an Excel spreadsheet containing e-mail addresses. How can I stop my e-mail program (Thunderbird) composing an e-mail when I click on a cell?
Kenneth Rushton
Nov 24, 2017Copper Contributor
Thank you for your answer, but they are not hyperlinks, just plain text, and the CheckBox labelled:(Internet and network paths with hyperlinks). is clear.
Haytham Amairah
Nov 24, 2017Silver Contributor
If so, then something is wrong with the Thunderbird itself!
- Kenneth RushtonNov 25, 2017Copper Contributor
If I make Windows Mail the default e-mail app the same thing happens
- SergeiBaklanNov 25, 2017Diamond Contributor
Yes, that doesn't matter, default email client is triggered by something. Is it possible to receive some sample file?
- Kenneth RushtonNov 25, 2017Copper ContributorI have found the problem. In some of the cells containing an e-mail address, when the cursor hovers over the cell, a window appears: "mailto:kenneth.rushton2@btinternet.com - Click once to follow. Click and hold to select this cell", although the formula bar shows only the e-mail address as the content of the cell without the 'mailto:'. These were originally hyperlinks. So I shall simply delete them and re-enter the text. I can't send you a screenshot as the file is confidential. Thank you for your help.
- SergeiBaklanNov 24, 2017Diamond Contributor
If that macro-enabled workbook it could be on click macro which opens email client
- Kenneth RushtonNov 25, 2017Copper Contributor
Macros are disabled.
- SergeiBaklanNov 25, 2017Diamond Contributor
Other words your file is in *.xlsx format?