software

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:
=b1amp;quot;;quot;amp;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:
gt;
gt; I have a column that contains an e-mail link in each cell. Is there a way to
gt; hyperlink to one blank e-mail message containing all of the addresses in
gt; column?

--

Dave Peterson

Thank you. That is much better than retyping.

quot;Dave Petersonquot; wrote:

gt; How about a small workaround?
gt;
gt; Say your data is in A1:A10
gt; Put this in B1:
gt; =a1
gt; But this in B2:
gt; =b1amp;quot;;quot;amp;a2
gt; and drag down to A10.
gt;
gt; Now copy and paste the value in A10 to your To: field in your email program.
gt;
gt; Not quite a hyperlink, but not too bad.
gt;
gt; Kim wrote:
gt; gt;
gt; gt; I have a column that contains an e-mail link in each cell. Is there a way to
gt; gt; hyperlink to one blank e-mail message containing all of the addresses in
gt; gt; column?
gt;
gt; --
gt;
gt; Dave Peterson
gt;