email Column in table - utility to convert into mailto: addresses

[©®]

I have a table in my document (name, phone, email) and have about
150-200 different email addresses in the "email" column. They are in
plain text with no links.
Is there an automated way (in Dreamweaver or a 3rd party add-on) that I
can convert that whole column into linkable email addresses so that when
someone clicks on the address, it will open their email program?

I am hoping I don't have to manually copy each address and then add
"mailto:" to each address.
Each address field corresponds to the name of the person. Some names are
husband/wife and they are in alphabetical order.

e.g.
adam bullin (e-mail address removed)
tom gregg (e-mail address removed)
betty smith (e-mail address removed)
john smith (e-mail address removed)
tommy tomlin (e-mail address removed)

I want it to be:

adam bullin (e-mail address removed)
tom gregg (e-mail address removed)
betty smith (e-mail address removed)
john smith (e-mail address removed)
tommy tomlin (e-mail address removed)

 

[©®]

Sorry...the first set of names were not supposed to be hyperlinked. I
hope you understand what I was meaning!

 

[Els]

I have a table in my document (name, phone, email) and have about
150-200 different email addresses in the "email" column. They are in
plain text with no links.
Is there an automated way (in Dreamweaver or a 3rd party add-on) that I
can convert that whole column into linkable email addresses so that when
someone clicks on the address, it will open their email program?

I am hoping I don't have to manually copy each address and then add
"mailto:" to each address.

Probably possible in Dreamweaver, but I don't know that
program. I find it very easy to do in TextPad, using the
macro function.
http://textpad.com/

 

[Shahid Juma]

One way that I can think of is you can past the three columns into Excel

4th column: <a href="mailto:
5th column: "</a>
6th column: concat (4th column, email column, 6th column)

Then just copy the first 2 columns and the 6th one and paste it into an
editor like Dreamweaver which will recognize the columns/rows...

Shahid
(remove NOSPAM from the email address when replying to my email address)

 

[Beauregard T. Shagnasty]

Quoth the raven ©®:

I have a table in my document (name, phone, email) and have about
150-200 different email addresses in the "email" column.

Since these addresses will become "harvestable" by the spambots, have
these people given their permission for you to publish them?

 

[Clive Moss]

Quoth the raven ©®:


Since these addresses will become "harvestable" by the spambots, have
these people given their permission for you to publish them?

-bts

And even if they do give permission you should 'munge' the address
(http://www.mways.co.uk/prog/hidemail.php)

CM

 

[©®]

And even if they do give permission you should 'munge' the address
(http://www.mways.co.uk/prog/hidemail.php)

Sorry - forgot to mention - it is an intranet so only the organisation
can access it. (Private phone list!)

 

[©®]

One way that I can think of is you can past the three columns into
Excel

4th column: <a href="mailto:
5th column: "</a>
6th column: concat (4th column, email column, 6th column)

Then just copy the first 2 columns and the 6th one and paste it into
an editor like Dreamweaver which will recognize the columns/rows...

Thanks - that was what I needed. FYI the 5th column should be: ' "</a>
as without the ' it will be right aligned and have no closing quote
(unless of course I misunderstood your info!)

 

[Foofy (formerly known as Spaghetti)]

I am hoping I don't have to manually copy each address and then add
"mailto:" to each address.
Each address field corresponds to the name of the person. Some names are
husband/wife and they are in alphabetical order.

It seems like you already got your problem solved, but I did this sort of
thing once in EditPlus with it's regular expression find and replace
thingy.

Find: <td>(.+)@(.+)</td>
Replace with: <td><a href="mailto:\1@\2">\1@\2</a>

I wish more apps supported regular expressions in find and replace.

 

[Toby A Inkster]

I wish more apps supported regular expressions in find and replace.

http://www.openoffice.org/

 

[Foofy (formerly known as Spaghetti)]

http://www.openoffice.org/

I finally got around to trying this a few weeks ago, it's pretty nice! It
has some weird bits though... but nothing I can't get used to. Miss
"outline view" in Writer though.