Email Hyperlink Multiple Recipients
 

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?

Email Hyperlink Multiple Recipients
 

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.

Kim wrote:

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?

--

Dave Peterson

Email Hyperlink Multiple Recipients
 

Thank you. That is much better than retyping.

"Dave Peterson" wrote:

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.

Kim wrote:

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?

--

Dave Peterson