Email Hyperlink Multiple Recipients

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

Guest

I have a column that contains an e-mail link in each cell. Is there a way to
hyperlink to one blank e-mail message containing all of the addresses in
column?
 
How about a small workaround?

Say your data is in A1:A10
Put this in B1:
=a1
But this in B2:
=b1&";"&a2
and drag down to A10.

Now copy and paste the value in A10 to your To: field in your email program.

Not quite a hyperlink, but not too bad.
 
Thank you. That is much better than retyping.

Dave Peterson said:
How about a small workaround?

Say your data is in A1:A10
Put this in B1:
=a1
But this in B2:
=b1&";"&a2
and drag down to A10.

Now copy and paste the value in A10 to your To: field in your email program.

Not quite a hyperlink, but not too bad.
Click to expand...
 
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
Ruined hyperlinks... 1
How do I disable the hyperlink for e-mail addresses in Excel? 1
Moving Hyperlinks 2
Text to Hyperlink 2
Open specific hyperlink (accept) automatically in email with outlook 0
email hyperlink won't change when cell content changes 2
Would like to send an e-mail to multiple address entered as data. 1

Back
Top