If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Separating an email address embedded in a "mail to:" hyperlink
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 real email address. |
#2
|
|||
|
|||
Hi
Try this with the hyperlinks in column A Sub test3() Dim hlnk As Hyperlink For Each hlnk In Columns("A").Hyperlinks 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 real email address. |
#3
|
|||
|
|||
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() Dim hlnk As Hyperlink For Each hlnk In Columns("A").Hyperlinks 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 real email address. |
#4
|
|||
|
|||
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 please. =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 real email address. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Why is my default email address not being used for sent mail? | Craig H. Foster | General Discussion | 2 | April 11th, 2005 06:14 PM |
Improve the Address Book | Bill Molony | General Discussions | 10 | February 17th, 2005 11:49 PM |
Outlook 2002 - changing 'display' email address | Lobster | Installation & Setup | 0 | November 21st, 2004 06:26 PM |
Wrong From E-Mail Address When Sending Faxes From Outlook | Marc Bressman | Fax | 3 | August 13th, 2004 07:14 AM |
Outlook is putting my intranet email as return email address | as | General Discussion | 11 | August 5th, 2004 03:24 AM |