LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
John87111
 
Posts: n/a
Default copy the underlying e-mail hyperlink information...

I have copied a web page into EXCEL that contains numerous hyperlinks labeled
"e-mail". When I click on the hyperlink Outlook opens and the e-mail address
is populated on the "to:" line. I want copy the underlying e-mail address in
the adjacent cell, but can not find a way to do it (all I get is another cell
labeled "e-mail"). I can do it by right clicking on the cell and selecting
"edit hyperlink" and do a copy/paste w/ the e-mail address. However, I have
a ton to do and was hoping to find a quick way to copy the email address,
Thanks for your help.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy subtotal information to new sheet Patience Excel Worksheet Functions 2 June 15th 05 04:03 PM
How do I copy the underlying e-mail hyperlink information from a . John87111 Excel Discussion (Misc queries) 3 April 26th 05 05:05 PM
how do i copy subtotals without the underlying data? Homer Excel Discussion (Misc queries) 4 April 26th 05 04:22 PM
Copy and paste Internet information into Excel 2003 Michael Excel Discussion (Misc queries) 0 February 10th 05 09:51 PM
how to copy 2350 hyperlink full paths to any column in a worksheet ? kontiki Excel Discussion (Misc queries) 4 December 10th 04 10:00 PM


All times are GMT +1. The time now is 07:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"