Email Hyperlink Multiple Recipients

K

Kim

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?
 
D

Dave Peterson

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.
 
K

Kim

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...
 
Top