On 11/7/07, NoOp <[EMAIL PROTECTED]> wrote: > > On 11/06/2007 06:03 PM, Allen wrote: > > Hi gang, > > > > I inherited an .ods spreadsheet that has hyperlinks to an e-mail > > address. About 10,000 of them. > > > > The text says "Email Me" but when you look at the hyperlink it > > says "mailto:[EMAIL PROTECTED]". > > > > I want to create a column next to it that has just the email > > address without having to collect them one by one so that I can > > send out group emails to a few people at a time when a subject > > comes up that would interest those people. > > > > So how do I de-link them in bulk, not 10,000 one at a time? > > > > Thanks, > > > [snip lots of stuff] > > OOo Help is your friend... > > Help|OpenOffice.org Help F1| enter hyper in the search bar then go to > 'turning off automatic recognition' & double-click. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > Hello Allen,
As I see it you should *not* do what NoOP is suggesting because this will simply transform the hyperlink into normal text which is not what you want. I am afraid you will need to write a macro to do what you want. Basically you have to inspect the hyperlink properties and extract the target. I am not very good with Calc macros so I am not sure I would be able to do it, but if you have time you can check out the free macro document of Andrew Pitonyak as well as have a look at the oooforum where there are plenty of examples. You may even find someone who offers to write the macro for you. Cheers, Michele
