Remember Me?

#1
May 3rd 05, 05:22 PM
 littleellisdude Posts: n/a

How can I separate (extract) ALL of the email addresses from a column of
MULTIPLE "email data hyperlinks" when they are all embedded in a "mail to:"
hyperlink? There is only one per row, but about 2000 in the total column.
Doing them one at a time will take a year to extract (
Thank you!!!
Example:
clicking on John Doe in a column opens Outlook "mail to:" to the persons

#2
May 3rd 05, 05:39 PM
 Ron de Bruin Posts: n/a

Hi

Try this with the hyperlinks in column A

Sub test3()
hlnk.Parent.Offset(0, 1).Value = Mid(hlnk.Address, 8, 255)
Next
End Sub

--
Regards Ron de Bruin
http://www.rondebruin.nl

"littleellisdude" wrote in message
...
How can I separate (extract) ALL of the email addresses from a column of
MULTIPLE "email data hyperlinks" when they are all embedded in a "mail to:"
hyperlink? There is only one per row, but about 2000 in the total column.
Doing them one at a time will take a year to extract (
Thank you!!!
Example:
clicking on John Doe in a column opens Outlook "mail to:" to the persons

#3
May 3rd 05, 05:42 PM
 Ron de Bruin Posts: n/a

It will copy the email address in column B

--
Regards Ron de Bruin
http://www.rondebruin.nl

"Ron de Bruin" wrote in message ...
Hi

Try this with the hyperlinks in column A

Sub test3()
hlnk.Parent.Offset(0, 1).Value = Mid(hlnk.Address, 8, 255)
Next
End Sub

--
Regards Ron de Bruin
http://www.rondebruin.nl

"littleellisdude" wrote in message
...
How can I separate (extract) ALL of the email addresses from a column of
MULTIPLE "email data hyperlinks" when they are all embedded in a "mail to:"
hyperlink? There is only one per row, but about 2000 in the total column.
Doing them one at a time will take a year to extract (
Thank you!!!
Example:
clicking on John Doe in a column opens Outlook "mail to:" to the persons

#4
May 3rd 05, 05:51 PM
 patrick Posts: n/a

This is ugly-but quick!-Use this formula in an mt column to add a space after
the .com or .net. It is not longer recognized as hypertext. Then do a copy,
paste special to get rid of the formula and it is now yours to do with as you
=A1 & " ". If this doesn't work, repost.
Pat

"littleellisdude" wrote:

How can I separate (extract) ALL of the email addresses from a column of
MULTIPLE "email data hyperlinks" when they are all embedded in a "mail to:"
hyperlink? There is only one per row, but about 2000 in the total column.
Doing them one at a time will take a year to extract (
Thank you!!!
Example:
clicking on John Doe in a column opens Outlook "mail to:" to the persons

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Ulti Excel Worksheet Functions 1 March 1st 05 04:18 AM dustin New Users to Excel 1 January 13th 05 09:59 PM Dustin Excel Discussion (Misc queries) 0 January 13th 05 02:39 AM Java Jake Excel Worksheet Functions 6 December 31st 04 05:05 PM ibrettferguson Excel Worksheet Functions 1 November 8th 04 03:24 AM

All times are GMT +1. The time now is 04:48 AM.