I am not computer savvy. Is there a way to covert a column of hyperlinks to email addresses? The 500 emails are listed as hyperlinks with the people's names. I need to be able to see their email addresses. Thanks for any help.
I am not computer savvy. Is there a way to covert a column of hyperlinks to email addresses? The 500 emails are listed as hyperlinks with the people's names. I need to be able to see their email addresses. Thanks for any help.
Could you post some examples?
Screen Shot 2019-04-04 at 12.01.52 AM.png
Here is a snapshot
so what happens when you click on say Robert Morris hyperlinked cell??
Cheers
Jmac1947
1. Please consider clicking on the * Add Reputation if you think this post has helped you
2. Mark your thread as SOLVED when question is resolved
It just opens my email with one email address. I need to paste all the emails for a mass email.
1. Select all the cells.
2. CTRL+C
3. Open your E-mail client and click into the To: box.
4. CTRL+V
All the addresses will appear in the To: box.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
This only pastes the names into the email client, not the email addresses. I need to turn the column of hyperlinks into email addresses first.
Then do that.
That's my question, how do I convert the entire column without clicking on 500 emails one by one?
See this post for a VBA solution.
Thanks for the info. Where exactly do I paste the code?
Open VB Editor with alt+F11. In "Sheet1" area, paste the VB code. You'll need to adjust this line to fit your circumstances:
Once that's done, go back to your workbook. Hit alt+F8 to open the macros list, and run the new macro.Please Login or Register to view this content.
Thanks. It worked perfectly. I appreciate the help.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks