Hyperlink for a group of addresses without individual entries?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In excel, how do you make hyperkinks for 200 email addresses without
individual entries?
 
You have 200 addresses in A1:A200?

If yes, then maybe
=hyperlink("mailto:" & a1)
in B1 and drag it down.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Activate email hyperlinks in imported data 1
Fomrulae to Hyperlink to cell in another tab with the same value/n 8
Creating an email list 2
Hyperlinks changed by Excel again! 5
autocad Hyper links 3
Multiple data entries in one cell for filtering purposes 2
Which is the best RPMSG to PDF converter in 2026? 0
How to Migrate IMAP Email to Office 365 Easily 0

Back
Top